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

A factor to consider when choosing a file organization is:

• Fast retrieval A
• Security B
• Efficient storage C
• All D

Optional is represented by

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

A file is stored in:

• RAM A
• ROM B
• Cache C
• Hard disk D

Which of the following keys us not unique:

• Candidate key A
• Forein key B
• Primary key C
• Secondary key 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

A \t is used for:

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

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

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

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

Data type int contain bytes:

• 10 A
• 4 B
• 2 C
• 1 D

Local variables are also called:

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

Which of the following represents the entities?

• Teacher A
• Student B
• Aero plane 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

Format specifier starts with the symbol

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

Which of the following can be used as flag value

• + 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

Which of the following is basic data distribution strategy?

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

Which of the following is basic data distribution strategy?

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