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

Which component of physical database design refers to the consistency of data?

• Indexes A
• Integrity constaint B
• File organization C
• Data distribution strategy 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

A file is stored in:

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

Data type int contain bytes:

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

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

Types of translators are:

• Compiler A
• Interpreter B
• Assembler C
• All of these 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

_______________ refers to a method of database distribution in which one database contains data that are included in another database.

• Splitting A
• Partitioning B
• Replication C
• Dividing D

The relationship can be:

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

Which of the following is basic data distribution strategy?

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

Every relation must have:

• Primary key A
• Candidate key B
• Secondary key C
• All of these D

Conditional operator is alternative of:

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

Which of the following escape sequence is used for beep

• /a A
• /b B
• /t C
• /n D

A factor to consider when choosing a file organization is:

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

An attribute is also known as:

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