Bitmap Indices Quiz with Answers PDF Download – Test 305

MCQ 1521: The hashing technique can be used to create secondary indices, known to be:

1. Virtual indices
2. Dynamic indices
3. Hash indices
4. Extendable indices

MCQ 1522: When comparing two values of type char, if they are of different lengths, then for comparison:

1. Extra bits are added
2. Extra characters are added
3. Extra spaces are added
4. Special characters are added

MCQ 1523: In the formal, mathematical definition of the relational model, a relation is a:

1. Set
2. Table
3. Procedure
4. Method

MCQ 1524: When a transaction finishes its final statement, it enters the:

1. Partially committed state
2. Committed state
3. Active state
4. Evaluate state

MCQ 1525: The technique chosen by the database system for evaluation of an operation depends on the size of:

1. Relation
2. Distribution of columns
3. Distribution of tuples
4. Both A and B