ExamTopics Logo
Mail Us[email protected]
Menu
Microsoft Discussions
exam questions

Exam 98-364 All Questions

View all questions & answers for the 98-364 exam
Go to Exam

Exam 98-364 topic 1 question 142 discussion

Actual exam question from Microsoft's 98-364
Question #: 142
Topic #: 1
[All 98-364 Questions]

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

  • 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.
Show Suggested Answer Hide Answer
Suggested Answer: Explanation 🗳️
by textes at Aug. 11, 2021, 2:32 a.m.

Comments

Chosen Answer:
This is a voting comment (?). It is better to Upvote an existing comment if you don't have anything to add.
Switch to a voting comment New
Submit Cancel
Vaydi
3 years, 4 months ago
Selected Answer: B
Réponse C
upvoted 1 times
...
pchelban
3 years, 6 months ago
Selected Answer: C
Explanation: The syntax of the REBUILD command has many options such as TABLESPACE, ONLINE, and NOLOGGING. The discussion is narrowed down to ONLINE and NOLOGGING options. NOLOGGING disables redo generation only for the index rebuild; all subsequent DML against the index will generate redo as normal. Without the ONLINE keywordthe index is locked for DML, but not for SELECT. However, the rebuild still continues.
upvoted 2 times
...
textes
3 years, 9 months ago
Answer C
upvoted 4 times
...
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.

Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.

SaveCancel
exam
Someone Bought Contributor Access for:
SY0-701
London, 1 minute ago