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

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 disadvantage of partitioning is:

• Complexity A
• Extra space and update time B
• Inconsistent access speed 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

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

Conditional operator is alternative of:

• If A
• If-else B
• Nested if-else C
• None of these D

Local variables are also called:

• Automatic variables A
• Global variables B
• Grid Variables C
• None of these D

Format specifier starts with the symbol

• # A
• % B
• * C
• all D

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

Which key does not have uniqueness property?

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

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

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

Conditional operator is also called:

• True operator A
• Ternary-operator B
• Truth operator C
• All of these 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

Optional is represented by

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

Which of the following is basic data distribution strategy?

• Centralized A
• Partitioned B
• Replication C
• All D

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

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

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

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

The function clrscr ( ) is defined in

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