C2090-619 Free Practice Test

What is the primary benefit of a Storage Pool?

1. A. It allows data to be shared across instances.
2. B. It allows data to be shared across dbspaces.
3. C. It allows space to automatically be added to dbspaces.
4. D. It allows space to be reserved for critical database operations.

Correct Answer: C

When KAIO is available and raw disk is used, which statement is true?

1. A. Logical Log IO is performed by the LIO VP.
2. B. Physical Log IO is performed by the PIO VP.
3. C. Logical Log IO is performed by the KAIO VP.
4. D. Physical Log IO is performed by the CPU VP.

Correct Answer: D

Which object can be compressed?

1. A. dictionary table
2. B. temporary table
3. C. attached b-tree index
4. D. detached b-tree index

Correct Answer: D

When executing the following command: execute function sysadmin task("table compress", "customer") what will happen to the customer table?

1. A. Only newly added rows will be compressed.
2. B. Only existing data will be compressed, new data will remain uncompressed.
3. C. Row data and partition blobs will be compressed and any free table space will be released.
4. D. Row data and partition blobs will be compressed and the space allocated to the table will remain.

Correct Answer: C

Which SQL statement is used to remove detailed statistical information from the sysdistrib catalog table?

1. A. UPDATE STATISTICS DISTRIBUTIONS ONLY
2. B. UPDATE STATISTICS LOW DROP DISTRIBUTIONS
3. C. UPDATE STATISTICS LOW REMOVE DISTRIBUTIONS
4. D. UPDATE STATISTICS MEDIUM REMOVE DISTRIBUTIONS

Correct Answer: B