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

A factor to consider when choosing a file organization is:

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

Which is used to display yes/no values:

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

Conditional operator is alternative of:

• If A
• If-else B
• Nested if-else C
• None of these D

Customers,cars and parts are examples of:

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

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

• Attribute A
• Relationship B
• Cardinality C
• Modality D

Getch stands for:

• Go character A
• Give character B
• Get character C
• All of these D

All of the following are components of physical database design EXCEPT:

• Data volume and usage anylisis A
• Data distribution strategy B
• File organization C
• Normalize the relations 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

Which of the following keys us not unique:

• Candidate key A
• Forein key B
• Primary key C
• Secondary key D

An attribute is also known as:

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

• mendatory A
• optional B
• may be many C
• none of theses 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

An advantage of partitioning is:

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

Conditional operator is also called:

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

Data type int contain bytes:

• 10 A
• 4 B
• 2 C
• 1 D

Every relation must have:

• Primary key A
• Candidate key B
• Secondary key C
• All of these D

The relationship can be:

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