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

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

Which is used to display yes/no values:

• Check box A
• Option buttons B
• Both a & b C
• None of these D

A technique for physically arranging the records of a file on secondary storage devices is called:

• Physical pointer A
• Retrieval program B
• File organization C
• Update program 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

A \t is used for:

• New line A
• Tab B
• Back space C
• None of these D

An index may be created on:

• Primary key A
• Secondary key B
• Foreign key 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

In a loop semicolon is placed at the end of condition:

• While A
• For B
• Do-while C
• None of these D

Which of the following key does not hold uniqueness property ?

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

In an E-R diagram, a rectangle represents:

• Entity A
• Attributes B
• Relationship C
• None D

An attribute is also known as:

• Table A
• Field B
• Row C
• Relation D

_______________ refers to a method of database distribution in which different portions of database reside at different nodes in the network.

• Spliting A
• Partitioning B
• Replication C
• Dividing 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

Conditional operator is also called:

• True operator A
• Ternary-operator B
• Truth operator C
• All of these D

Local variables are also called:

• Automatic variables A
• Global variables B
• Grid Variables C
• None of these D

Optional is represented by

• 0 A
• 1 B
• 2 C
• none of these 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