Point out the correct statement :

Question

Options:

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

Answer: Option B

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.

Was this answer helpful ?

Next Question

More Questions on This Topic :

Question 1. ______________ allow concurrent transactions to read (SELECT) a resource. ....

Question 2. Point out the correct statement : ....

Question 3. To produce execution plan output by using most Showplan Transact-SQL SET options, users must have ....

Question 4. Point out the correct statement : ....

Question 5. ____________ rolls back a user-specified transaction to the beginning of the transaction. ....

Question 6. Enabling the Resource Governor requires _________ permission. ....

Question 7. ____________ is the preferred statement for indicating errors in the transaction. ....

Question 8. Which of the log_reuse_wait_desc value has log_reuse_wait value 0 ? ....

Chapter 1 - GLOBAL STEEL SCENARIO & INDIAN STEEL INDUSTRY Part 1 : (13-04-2024) INDUSTRY AND COMPANY AWARENESS (ICA)

Direction Sense Test Part 1 Reasoning (Hindi)

Chapter 1 - RMHP / OHP / OB & BP Part 1 : (14-02-2024) GPOE

Cube & Cuboid Part 1 Reasoning (Hindi)

Data Interpretation (DI) Basic Concept Reasoning (Hindi)

Counting Figures Part 1 Counting Of Straight Lines Reasoning (Hindi)

Sail E0 free webinar Webinars

Real Numbers Part 7 Class 10 Maths

Real Numbers Part 1 Class 10 Maths

Polynomials Part 1 Class 10 Maths

DSP Combined 1 Free Revision Test SAIL JO E-0

GPOE / GPA Combined 1 Free Revision Test SAIL JO E-0

BSP Plant Specific Review Test SAIL JO E-0

BSL Combined 1 Free Revision Test SAIL JO E-0

GFM Combined 1 Free Revision Test SAIL JO E-0