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

An disadvantage of partitioning is:

• Complexity A
• Extra space and update time B
• Inconsistent access speed C
• All D

Which of the following is basic data distribution strategy?

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

An index may be created on:

• Primary key A
• Secondary key B
• Foreign key C
• All D

A factor to consider when choosing a file organization is:

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

Which key does not have uniqueness property?

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

Which is used to display yes/no values:

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

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

Object used to retrieve data from database is called:

• Forms A
• Repons B
• Queries C
• Tables 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 is NOT included in the definition of an entity?

• Person A
• Object B
• Concept C
• Action D

Which of the following keys us not unique:

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

The relationship can be:

• One-to-one A
• One-to-many B
• Many-to-many 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

Which of the following key does not hold uniqueness property ?

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