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

Which of the following escape sequence is used for beep

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

Format specifier starts with the symbol

• # A
• % B
• * 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

Every relation must have:

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

An disadvantage of partitioning is:

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

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

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

Which of the following key does not hold uniqueness property ?

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

A \t is used for:

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

Conditional operator is alternative of:

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

In a loop semicolon is placed at the end of condition:

• While A
• For B
• Do-while C
• None of these D

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

Getch stands for:

• Go character A
• Give character B
• Get character C
• All of these 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

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