Multiversion Schemes - DBMS Questions and Answers

6.

A unit of storage that can store one or more records in a hash file organization is denoted as

   A.) Buckets
   B.) Disk pages
   C.) Blocks
   D.) Nodes

Answer: Option 'A'

Buckets are used to store one or more records in a hash file organization.

7.

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.

8.

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.

9.

DBMS periodically suspends all processing and synchronizes its files and journals through the use of

   A.) Checkpoint facility
   B.) Backup facility
   C.) Recovery manager
   D.) Database change log

Answer: Option 'A'

DBMS periodically suspends all processing and synchronizes its files and journals through the use of Check point facility.

10.

Which of the following is not true about B+ trees?

   A.) B+ tree index takes the form of balanced tree
   B.) Performance of B+ tree degrades as the file grows
   C.) Look-up in B+ tree is straightforward and efficient
   D.) Insertion and deletion in B+ tree is complicated but efficient

Answer: Option 'B'

Performance of B+ tree degrades as the file grows

Multiversion Schemes - DBMS Questions and Answers Download Pdf