Explanation:When the internal sort buffers have been filled with leaf index entries, the entries are sorted and written to disk as an intermediate sort run. 3. Which of the following query enables the IX_Employee_OrganizationLevel_OrganizationNode index on the Employee table ?
A. DBCC DBREINDEX (“Employee”, IX_Employee_OrganizationLevel_OrganizationNode);
B. DBCC REINDEX (“Employee”, IX_Employee_OrganizationLevel_OrganizationNode);
C. DBCC DBINDEX (“Employee”, IX_Employee_OrganizationLevel_OrganizationNode);
D. All of the mentioned
Answer:A
Explanation:When the internal sort buffers have been filled with leaf index entries, the entries are sorted and written to disk as an intermediate sort run. 3. Which of the following query enables the IX_Employee_OrganizationLevel_OrganizationNode index on the Employee table ?
A. DBCC DBREINDEX (“Employee”, IX_Employee_OrganizationLevel_OrganizationNode); B. DBCC REINDEX (“Employee”, IX_Employee_OrganizationLevel_OrganizationNode); C. DBCC DBINDEX (“Employee”, IX_Employee_OrganizationLevel_OrganizationNode); D. All of the mentioned
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 ?