CSE MCQs :: SQL Server MCQs
- Point out the correct statement :
- To remove archival compression and restore the data to columnstore compression :
- Point out the correct statement :
- ______________ allow concurrent transactions to read (SELECT) a resource.
- Point out the correct statement :
- To produce execution plan output by using most Showplan Transact-SQL SET options, users must have
- Point out the correct statement :
- Enabling the Resource Governor requires _________ permission.
- ____________ rolls back a user-specified transaction to the beginning of the transaction.
- ____________ is the preferred statement for indicating errors in the transaction.
Whatsapp
Facebook
|
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
|
|
A.
On x86-based systems, creating a table or index with more than 1000 partitions is possible
|
|
B.
Compressing large tables or indexes can have manageability and performance benefit
|
|
C.
Partitioning slow tables or indexes can have the following manageability and performance benefit
|
|
D.
None of the mentioned
|