Explanation:DBCC DBREINDEX rebuilds one or more indexes for a table in the specified database. 4. Which of the following query can enable all indexes onj Employee table ?
A. DBCC DBREINDEX (“Employee”, ” “);
B. DBCC DBREINDEX (“EMP”, ” “);
C. DBCC DBREINDEX (“HumanResources.Employee”, “ALL”);
D. None of the mentioned
Answer:A
Explanation:DBCC DBREINDEX rebuilds one or more indexes for a table in the specified database. 4. Which of the following query can enable all indexes onj Employee table ?
A. DBCC DBREINDEX (“Employee”, ” “); B. DBCC DBREINDEX (“EMP”, ” “); C. DBCC DBREINDEX (“HumanResources.Employee”, “ALL”); D. None of the mentioned
Explanation:DBCC DBREINDEX can enable all indexes for a table in the specified database. 5. Point out the wrong statement :