Query Processing

1.

Which of the following is the oldest database model?

   A.) Network
   B.) Relational
   C.) Deductive
   D.) Physical

Answer: Option 'A'

Network

2.

If the state of the database no longer reflects a real state of the world that the database is supposed to capture, then such a state is called

   A.) Consistent state
   B.) Parallel state
   C.) Durable state
   D.) Inconsistent state

Answer: Option 'D'

Inconsistent state

3.

Which of the following is an attribute that can uniquely identify a row in a table?

   A.) Secondary key
   B.) Candidate key
   C.) Foreign key
   D.) Alternate key

Answer: Option 'B'

Candidate key

4.

A collection of data designed to be used by different people is called a/an

   A.) Database
   B.) Organization
   C.) Relationship
   D.) Schema

Answer: Option 'A'

Database

5.

Ensuring isolation property is the responsibility of the

   A.) Recovery-management component of the DBMS
   B.) Concurrency-control component of the DBMS
   C.) Transaction-management component of the DBMS
   D.) Buffer management component in DBMS

Answer: Option 'B'

Concurrency-control component of the DBMS

Query Processing Download Pdf