Multiversion Schemes - DBMS Questions and Answers

1.

ANSI-standard SQL allows the use of special operators in conjunction with the WHERE clause. A special operator used to check whether an attribute value is null is

   A.) BETWEEN
   B.) IS NULL
   C.) LIKE
   D.) IN

Answer: Option 'B'

Exists is used to check whether an attribute value is null or not in conjunction with the where clause.

2.

______ means that data used during the execution of a transaction cannot be used by a second transaction until the first one is completed.

   A.) Serializability
   B.) Atomicity
   C.) Isolation
   D.) Time stamping

Answer: Option 'C'

Isolation means that data used during the execution of a transaction can’t be used by a second transaction until the first one is completed.

3.

The most recent version of standard SQL prescribed by the American National Standards Institute is

   A.) SQL 2016
   B.) SQL 2002
   C.) SQL – 4
   D.) SQL2

Answer: Option 'A'

SQL-2016 is the most recent version of standard SQL prescribed by the ANSI.

4.

A lock that prevents the use of any tables in the database from one transaction while another transaction is being processed is called a

   A.) Database-level lock
   B.) Table-level lock
   C.) Page-level lock
   D.) Row-level lock

Answer: Option 'A'

Database-level lock

5.

The file organization which allows us to read records that would satisfy the join condition by using one block read is

   A.) Heap file organization
   B.) Sequential file organization
   C.) Clustering file organization
   D.) Hash files organization

Answer: Option 'C'

Clustering file organization allows us to read records that would satisfy the join condition by using one block read.

Multiversion Schemes - DBMS Questions and Answers Download Pdf