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

Object used to retrieve data from database is called:

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

Which of the following are ingredients of data modeling?

• Entities A
• Attributes B
• Relationship C
• All D

Conditional operator is also called:

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

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

Which of the following is basic data distribution strategy?

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

Getch stands for:

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

_______________ 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

Organizing the database in computer disk storage is done in:

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

Which of the following represents the entities?

• Teacher A
• Student B
• Aero plane 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

Which of the following is NOT included in the definition of an entity?

• Person A
• Object B
• Concept C
• Action D

The relationship can be:

• One-to-one A
• One-to-many B
• Many-to-many 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

Which of the following is a valid format specifier

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

Which key does not have uniqueness property?

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