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' ; | |