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

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

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

An attribute is also known as:

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

Which of the following is used to describe the characteristics of an object?

• Attribute A
• Relationship B
• Cardinality C
• Modality 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

Local variables are also called:

• Automatic variables A
• Global variables B
• Grid Variables C
• None of these 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 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

The relationship can be:

• One-to-one A
• One-to-many B
• Many-to-many C
• All D

Which of the following are ingredients of data modeling?

• Entities A
• Attributes B
• Relationship C
• All D

A factor to consider when choosing a file organization is:

• Fast retrieval A
• Security B
• Efficient storage C
• All D

Relationship are

• uni-directional A
• bi-directional B
• tri-directional C
• none of these D

Which is used to display yes/no values:

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

Which of the following can be used as flag value

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

Customers,cars and parts are examples of:

• Entities A
• Attributes B
• Cardinals C
• Relashionships D

Organizing the database in computer disk storage is done in:

• Logical design A
• Physical design B
• Analysis C
• Implimentation D

In an E-R diagram, a rectangle represents:

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

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