nerdexam
Microsoft

98-364 · Question #9

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

The correct answer is B. Without the ONLINE keyword the index is locked for any DML operation. See the full explanation below for the reasoning.

Question

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

Options

  • AThe NOLOGGING and ONLINE keywords can never be used together.
  • BWithout the ONLINE keyword the index is locked for any DML operation.
  • CThe NOLOGGING and ONLINE keywords are always used together.
  • DWithout the ONLINE keyword the index is locked for the SELECT operation.

How the community answered

(27 responses)
  • A
    4% (1)
  • B
    78% (21)
  • C
    11% (3)
  • D
    7% (2)

Community Discussion

No community discussion yet for this question.

Full 98-364 Practice