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

_______________ 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 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

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

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

Which of the following is used to associate entities with one another?

• Entity A
• Attribute B
• Identifier C
• Relationship D

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

• one A
• many B
• three C
• zero 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

Escape sequence starts with the character

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

Relationship are

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

Conditional operator is alternative of:

• If A
• If-else B
• Nested if-else 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 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

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

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

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

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

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

Which is used to display yes/no values:

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

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

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