

MCQOPTIONS
Saved Bookmarks
1. |
Which of the following code is used to enable compression on a table? |
A. | EXEC sp_estimate_compression_savings 'Production', 'TransactionHistory', NULL, NULL, 'ROW' ; |
B. | EXEC sp_estimate_compression_savings 'Production', 'TransactionHistory', NULL, NULL, 'ROW' ; |
C. | EXEC sp_estimate_compression_savings 'Production', 'TransactionHistory', NULL, NULL, 'ROW' ; |
D. | EXEC sp_estimate_compression 'Production', 'TransactionHistory', NULL, NULL, 'ROW' ; |
Answer» B. EXEC sp_estimate_compression_savings 'Production', 'TransactionHistory', NULL, NULL, 'ROW' ; | |