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

Data type int contain bytes:

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

Which of the following is a valid format specifier

• %10d A
• %7.2f B
• %-7f 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

Which of the following key does not hold uniqueness property ?

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

A file is stored in:

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

Conditional operator is also called:

• True operator A
• Ternary-operator B
• Truth operator C
• All 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

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

An advantage of partitioning is:

• Efficiency A
• Extra space B
• Reliabilty C
• Accuracy 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

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 is used to describe the characteristics of an object?

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

A \t is used for:

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

Which of the following are ingredients of data modeling?

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

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

• Person A
• Object B
• Concept C
• Action 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

Organizing the database in computer disk storage is done in:

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