More Classes
5th Class
6th Class
7th Class
8th Class
9th Class
10th Class
11th Class
12th Class
NAT I
NAT II
CSS
IQ
General Knowledge
MDCAT
ECAT
GAT General
GAT Subject
Other Links
Go to Home
Online Tests
Computer Science Ics Part 2 Chapter 3 Online Test MCQs With Answers
Question # 1
An entity related to itself in an ERD model refers to
Choose an answer
recursive relationship
one-to-many relationship
many to many relationship
on to one relationship
Previous
Skip
Next
Question # 2
Which of the following is NOT included in the definition of an entity?
Choose an answer
Person
Object
Concept
Action
Previous
Skip
Next
Question # 3
Which of the following is basic data distribution strategy?
Choose an answer
Centralized
Partitioned
Replication
All
Previous
Skip
Next
Question # 4
A factor to consider when choosing a file organization is:
Choose an answer
Fast retrieval
Security
Efficient storage
All
Previous
Skip
Next
Question # 5
The number of variables that can be used in printf ( ) function are
Choose an answer
one
many
three
zero
Previous
Skip
Next
Question # 6
Which of the following is used to describe the characteristics of an object?
Choose an answer
Attribute
Relationship
Cardinality
Modality
Previous
Skip
Next
Question # 7
Which component of physical database design refers to the consistency of data?
Choose an answer
Indexes
Integrity constaint
File organization
Data distribution strategy
Previous
Skip
Next
Question # 8
Choose an answer
mendatory
optional
may be many
none of theses
Previous
Skip
Next
Question # 9
Which is used to display yes/no values:
Choose an answer
Check box
Option buttons
Both a & b
None of these
Previous
Skip
Next
Question # 10
Object used to retrieve data from database is called:
Choose an answer
Forms
Repons
Queries
Tables
Previous
Skip
Next
Question # 11
In ERD model, the relationship between two entities is represented by a
Choose an answer
diamond symbol
rectangular box
oval symbol
line
Previous
Skip
Next
Question # 12
_______________ refers to a method of database distribution in which one database contains data that are included in another database.
Choose an answer
Splitting
Partitioning
Replication
Dividing
Previous
Skip
Next
Question # 13
A data model is :
Choose an answer
A logical representation of the structure of the database
Shown as an entity-relationship diagram
Transformed into tables and relationships
All
Previous
Skip
Next
Question # 14
Organizing the database in computer disk storage is done in:
Choose an answer
Logical design
Physical design
Analysis
Implimentation
Previous
Skip
Next
Question # 15
Relationship are
Choose an answer
uni-directional
bi-directional
tri-directional
none of these
Previous
Skip
Next
Question # 16
Local variables are also called:
Choose an answer
Automatic variables
Global variables
Grid Variables
None of these
Previous
Skip
Next
Question # 17
An index may be created on:
Choose an answer
Primary key
Secondary key
Foreign key
All
Previous
Skip
Next
Question # 18
A file is stored in:
Choose an answer
RAM
ROM
Cache
Hard disk
Previous
Skip
Next
Back