Setting the SORT_IN_TEMPDB option to ON can direct the SQL Server Database Engine to use ________ to store the intermediate sort results.
A. tempdb
B. master
C. msdb
D. model
Answer:A
Setting the SORT_IN_TEMPDB option to ON can direct the SQL Server Database Engine to use ________ to store the intermediate sort results.
A. tempdb B. master C. msdb D. model
Explanation:It is required to create or rebuild an index when tempdb is on a set of disks different from that of the user database. 2. Point out the correct statement :