Discussion :: SQL Server MCQs
- Point out the correct statement :
|
A.
When SORT_IN_TEMPDB is set to OFF, the default, the sort runs are stored in the source filegroup
|
|
B.
The Database Engine first scans the data pages of the base table to retrieve key values and builds an index leaf row for each data row
|
|
C.
When SORT_IN_TEMPDB is set to ON, the default, the sort runs are stored in the destination filegroup.
|
|
D.
None of the mentioned
|
Whatsapp
Facebook
Answer : Option B
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.
Be The First To Comment