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

In an E-R diagram, a rectangle represents:

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

Every relation must have:

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

Conditional operator is also called:

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

Object used to retrieve data from database is called:

• Forms A
• Repons B
• Queries C
• Tables D

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

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

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

Data type int contain bytes:

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

The function clrscr ( ) is defined in

• stdio.h A
• math.h B
• canio.h C
• graphic.h D

A file is stored in:

• RAM A
• ROM B
• Cache C
• Hard disk 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

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

In a relational database a single piece of information is called:

• Table A
• Record B
• Entity C
• Attribute D

The relationship can be:

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