Which statement about adaptive compression is true?
A.
Adaptive compression uses a page-level dictionary-based compression algorithm to
compress data based on repeating patterns found within asampling of data from one extent.
B.
Adaptive compression can only be used to compress base tables, partitioned tables, and
temporary tables; MQTs, typed tables and stagingtables cannot be compressed.
C.
When you enable adaptive compression for a table, you enable it for the entire table,
even if the table contains more than one partition.
D.
You can specify that tables be compressed by using either a table-level dictionary only,
pagelevel dictionaries only, or both table-level andpage-level dictionaries.
Explanation:
How adaptive compression works
Adaptive compression actually uses two compression approaches. The first employs the same table-level compression dictionary used in classic row compression to compress data based on repetition within a sampling of data from the table as a whole. The second approach uses a page-level dictionary-based compression algorithm to compress data based on data repetition within each page of data.
0
0
Row access control and multilevel security are mutually exclusive. If a table is activated for row access control, it cannot be altered to include a security label column; if a table has a security label column, it cannot be activated for row access control. Column access control, on the other hand, is not affected by multilevel security. If a table is activated for column level access control, it can be altered to include a security label column, and vice versa.
0
0