Explore topic-wise MCQs in Structured Query Language (SQL).

This section includes 4 Mcqs, each offering curated multiple-choice questions to sharpen your Structured Query Language (SQL) knowledge and support exam preparation. Choose a topic below to get started.

1.

The data_compression and data_compression_desc columns include :

A. COLUMNSTOREARCHIVE
B. COLUMNSTORE_ARCH
C. COLUMNSTORE
D. None of the mentioned
Answer» D. None of the mentioned
Discussion
2.

To remove archival compression and restore the data to columnstore compression :

A. Use ALTER TABLE
B. Use ALTER COLUMN
C. Use ALTER DATABASE
D. All of the mentioned
Answer» B. Use ALTER COLUMN
Discussion
3.

Use _________ data compression to compress columnstore data with archival compression.

A. COLUMNSTOREARCHIVE
B. COLUMNSTORE_ARCHIVE
C. COLUMNSTORE
D. All of the mentioned
Answer» C. COLUMNSTORE
Discussion
4.

Which of the following compression type is supported by SQL Server 2014 ?

A. Row
B. Column
C. Both row and column
D. None of the mentioned
Answer» D. None of the mentioned
Discussion