Bitmap Indices - Database Questions and Answers

1.

A tablespace is further broken down into ________

   A.) Tablespace
   B.) Segments
   C.) Extents
   D.) Blocks

Answer: Option 'B'

Segments

2.

In ordered indices the file containing the records is sequentially ordered, a ___________ is an index whose search key also defines the sequential order of the file.

   A.) Clustered index
   B.) Structured index
   C.) Unstructured index
   D.) Nonclustered index

Answer: Option 'A'

Clustered index

3.

To identify the deleted records we use the ______________.

   A.) Existence bitmap
   B.) Current bitmap
   C.) Final bitmap
   D.) Deleted bitmap

Answer: Option 'A'

Existence bitmap

4.

Indices whose search key specifies an order different from the sequential order of the file are called ___________ indices.

   A.) Nonclustered
   B.) Secondary
   C.) All of the mentioned
   D.)  None of the mentioned

Answer: Option 'C'

All of the mentioned

5.

Select *
from r
where gender = ’f’ and income level = ’L2’;
In this selection, we fetch the bitmaps for gender value f and the bitmap for income level value L2, and perform an ________ of the two bitmaps.

   A.) Union
   B.) Addition
   C.) Combination
   D.) Intersection

Answer: Option 'D'

Intersection

Bitmap Indices - Database Questions and Answers Download Pdf