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

Local variables are also called:

• Automatic variables A
• Global variables B
• Grid Variables C
• None of these 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

Object used to retrieve data from database is called:

• Forms A
• Repons B
• Queries C
• Tables D

An attribute is also known as:

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

Data type int contain bytes:

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

The function clrscr ( ) is defined in

• stdio.h A
• math.h B
• canio.h C
• graphic.h 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

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

A technique for physically arranging the records of a file on secondary storage devices is called:

• Physical pointer A
• Retrieval program B
• File organization C
• Update program 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

Types of translators are:

• Compiler A
• Interpreter B
• Assembler 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

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

• Attributes A
• Entities B
• Relationships C
• Descriptors 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
• on to one relationship D

Conditional operator is alternative of:

• If A
• If-else B
• Nested if-else C
• None of these 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

Organizing the database in computer disk storage is done in:

• Logical design A
• Physical design B
• Analysis C
• Implimentation D