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

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

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 \t is used for:

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

An disadvantage of partitioning is:

• Complexity A
• Extra space and update time B
• Inconsistent access speed C
• All D

Which of the following is basic data distribution strategy?

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

Which key does not have uniqueness property?

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

Which of the following escape sequence is used for beep

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

An attribute is also known as:

• Table A
• Field B
• Row C
• Relation D

Which of the following activities are involved in data analysis?

• Data flow diagram A
• Decision Tables B
• Decision Trees C
• All D

An index may be created on:

• Primary key A
• Secondary key B
• Foreign key C
• All 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 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

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

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

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

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

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

Which of the following key does not hold uniqueness property ?

• candidate key A
• foreign key B
• primary key C
• Secondary key D

Data type int contain bytes:

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