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

An advantage of partitioning is:

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

Which key does not have uniqueness property?

• Candidate A
• Foreign 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

• 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

An attribute is also known as:

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

A \t is used for:

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

Object used to retrieve data from database is called:

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

The function clrscr ( ) is defined in

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

Relationship are

• uni-directional A
• bi-directional B
• tri-directional C
• none of these 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

An index may be created on:

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

In a loop semicolon is placed at the end of condition:

• While A
• For B
• Do-while C
• None of these 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

Every relation must have:

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

Escape sequence starts with the character

• % A
• / B
• # C
• none D

A person's name, birthday and social security number are examples of:

• Attributes A
• Entities B
• Relationships C
• Descriptors D