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;
Answer:A
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;