SQL MCQ Number 01413

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.
Buy membership
Already a member? Log in here
ed010d383e1f191bdb025d5985cc03fc?s=120&d=mm&r=g

DistPub Team

Distance Publisher (DistPub.com) provide project writing help from year 2007 and provide writing and editing help to hundreds student every year.