SQL MCQ Set 1 1. 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 AnswerAnswer: a [Reason:] It is required to create or rebuild an index when tempdb is on a set of disks…
This content is for paid premium members only.
You can view complete answer after activation your membership.
Need only one answers. Simply buy single day pass and email. We will send answers for this question.
Login Buy membership