Multiple Choice Questions - Sparse Columns
1. Sparse columns make it possible to store columns more efficiently where a large percentage of the rows will be . . . . . . .
A) Non-Null
B) Null
C) Indexed
D) Sorted
2. Sparse columns require an extra . . . . . . of storage for each non-NULL, fixed-length value in the table.
A) 2 bits
B) 4 bits
C) 2 bytes
D) 4 bytes
3. SQL Server stores sparse columns in a single . . . . . . that appears to external applications and end users as a normal column.
A) bigint
B) binary
C) XML column
D) nvarchar
4. A sparse column cannot be defined with a default value.
A) True
B) False
5. A sparse column cannot be a part of a . . . . . . . .
A) clustered index
B) nonclustered index
C) XML index
D) unique primary key index
6. Sparse columns are good candidates for inclusion in . . . . . . . indexes.
A) XML
B) clustered
C) filtered
D) nonclustered
7. Sparse columns must allow NULL values and cannot include the following data types:
A) Geography
B) Varchar
C) Bigint
D) Text
E) Timestamp
8. A column cannot be changed from sparse to nonsparse or nonsparse to sparse.
A) True
B) False
9. The sparse columns feature allows you to have far more columns that you ever could before.
A) True
B) False
10. A table can only have one . . . . . defined, and when a table has a . . . . . . defined, SELECT * no longer returns individual sparse columns. Instead it returns an XML fragment containing all the non-null values for the sparse columns.
A) sql_variant
B) COLUMN_SET
C) ALL_SPARSE_COLUMNS
D) SYSTEM_VIEW
Answers