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

Optional is represented by

• 0 A
• 1 B
• 2 C
• none of these D

Relationship are

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

Which of the following can be used as flag value

• + A
• # B
• - C
• all 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 attribute is also known as:

• Table A
• Field B
• Row C
• Relation 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

-------------------- defines the nature of the relationship

• cardinality A
• entities B
• modality C
• none of these D

In ERD model, the relationship between two entities is represented by a

• diamond symbol A
• rectangular box B
• oval symbol C
• line D

The relationship can be:

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

Object used to retrieve data from database is called:

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

Which is used to display yes/no values:

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

An index may be created on:

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

Which of the following are ingredients of data modeling?

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

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

Which of the following represents the entities?

• Teacher A
• Student B
• Aero plane C
• All D

Which of the following is a valid format specifier

• %10d A
• %7.2f B
• %-7f C
• all D