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

The number of variables that can be used in printf ( ) function are

• one A
• many B
• three C
• zero D

An disadvantage of partitioning is:

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

A file is stored in:

• RAM A
• ROM B
• Cache C
• Hard disk D

Which of the following key does not hold uniqueness property ?

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

Relationship are

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

An advantage of partitioning is:

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

Types of translators are:

• Compiler A
• Interpreter B
• Assembler C
• All of these D

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

Which of the following keys us not unique:

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

Which of the following is NOT included in the definition of an entity?

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

Data type int contain bytes:

• 10 A
• 4 B
• 2 C
• 1 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

An index may be created on:

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

Which of the following activities are involved in data analysis?

• Data flow diagram A
• Decision Tables B
• Decision Trees C
• All D

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

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

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