PrepAway - Latest Free Exam Questions & Answers

You have an index called Employee_IDX on the table Employees. Which of the following will rebuild this index o

You have an index called Employee_IDX on the table Employees. Which of the following will rebuild this index online?

A. ALTER INDEX Employee_IDX ON Employees REBUILD WITH (ONLINE = ON);

B. CREATE INDEX Employee_IDX ON Employees REBUILD WITH (ONLINE = ON);

C. REBUILD ONLINE INDEX Employee_IDX ON Employees;

D. ALTER INDEX REBUILD ONLINE Employee_IDX;

References:


Leave a Reply