Senior Database Indexing

Test your Senior-level Caching Performance Database Indexing skills in Database Data Management. This timed assessment evaluates your expertise in Information Technology.

Duration: 5 minutes

•40 questions

Time Remaining: 05:00

Progress: 0%

40 questions remaining

Question 1 of 40Assessment

In a multi-column index (A, B, C), why is a query with a WHERE clause on (B, C) unable to use an index seek?

A. The database engine requires all columns of a composite index to be present in the ORDER BY clause.

B. The statistics for Column B are only collected when Column A is also included in the query predicate.

C. The index is sorted primarily by Column A, making it impossible to navigate the tree without a value for A.

D. Non-prefix columns in a composite index are stored as uncompressed blobs that cannot be searched.

Keyboard Shortcuts

↑↓Navigate options

EnterSelect answer

←→Prev/Next question

SSkip question

1-4Select A-D

EscClear answer

SpaceNext question

BackspacePrevious question