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

An entity related to itself in an ERD model refers to :

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

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

The output of the statement print ("%2f', 11.4519), is

• 11.4519 A
• 11.45 B
• 11.51 C
• 11 D

Which is used to display yes/no values:

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

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

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

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

• While A
• For B
• Do-while C
• None of these D

Which of the following can be used as flag value

• + A
• # B
• - C
• all D

Data type int contain bytes:

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

In an E-R diagram, a rectangle represents:

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

The relationship can be:

• One-to-one A
• One-to-many B
• Many-to-many C
• All D

Format specifier starts with the symbol

• # A
• % B
• * 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

_______________ 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

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

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

Escape sequence starts with the character

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