12th Class ICS Computer Science Online MCQ Test for (Data Base Process)

• mendatory A
• optional B
• may be many C
• none of theses D

_______________ refers to a method of database distribution in which one database contains data that are included in another database.

• Splitting A
• Partitioning B
• Replication C
• Dividing D

In a relational database a single piece of information is called:

• Table A
• Record B
• Entity C
• Attribute D

A data model is :

• A logical representation of the structure of the database A
• Shown as an entity-relationship diagram B
• Transformed into tables and relationships C
• All D

Format specifier starts with the symbol

• # A
• % B
• * C
• all D

In hybrid distribution, what types of fragments are stored at only one site?

• Critical fragments A
• Non-critical fragments B
• Critical and non-critical fragments C
• Only large fragments D

An advantage of partitioning is:

• Efficiency A
• Extra space B
• Reliabilty C
• Accuracy D

An entity related to itself in an ERD model refers to :

• Recursive relationship A
• One-to-many relationship B
• Many-to-many relationship C
• One-to-one relationship D

Which of the following key does not hold uniqueness property ?

• candidate key A
• foreign key B
• primary key C
• Secondary key D

Which component of physical database design refers to the consistency of data?

• Indexes A
• Integrity constaint B
• File organization C
• Data distribution strategy D

Which of the following is used to associate entities with one another?

• Entity A
• Attribute B
• Identifier C
• Relationship D

Which of the following represents the entities?

• Teacher A
• Student B
• Aero plane C
• All D

An entity related to itself in an ERD model refers to

• recursive relationship A
• one-to-many relationship B
• many to many relationship C
• on to one relationship D

Optional is represented by

• 0 A
• 1 B
• 2 C
• none of these D

Which of the following is basic data distribution strategy?

• Centralized A
• Partitioned B
• Replication C
• All D

The output of the statement print ("%2f', 11.4519), is

• 11.4519 A
• 11.45 B
• 11.51 C
• 11 D

Which of the following can be used as flag value

• + A
• # B
• - C
• all D