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

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

Which is used to display yes/no values:

• Check box A
• Option buttons B
• Both a & b C
• None of these D

Conditional operator is also called:

• True operator A
• Ternary-operator B
• Truth operator C
• All of these D

Getch stands for:

• Go character A
• Give character B
• Get character C
• All of these D

Which of the following is a valid format specifier

• %10d A
• %7.2f B
• %-7f C
• all D

Types of translators are:

• Compiler A
• Interpreter B
• Assembler C
• All of these D

An attribute is also known as:

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

Format specifier starts with the symbol

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

An advantage of partitioning is:

• Efficiency A
• Extra space B
• Reliabilty C
• Accuracy D

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

An index may be created on:

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

An disadvantage of partitioning is:

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

Conditional operator is alternative of:

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

The relationship can be:

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

Which of the following key does not hold uniqueness property ?

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