Database Fundamentals — Question 106

Which of the following statements about rebuilding an index is true?

Answer options

• A. The NOLOGGING and ONLINE keywords can never be used together.
• B. The NOLOGGING and ONLINE keywords are always used together.
• C. Without the ONLINE keyword the index is locked for any DML operation.
• D. Without the ONLINE keyword the index is locked for the SELECT operation.

Correct answer:

Explanation

The correct answer is C, as when rebuilding an index without the ONLINE keyword, the index cannot be accessed for DML operations, effectively locking it. Options A and B are incorrect because NOLOGGING and ONLINE can be used together, but they are not always used together. Option D is also incorrect since the lock applies to DML operations, not just SELECT.