DB2 10 for z/OS Database Administrator — Question 32

Which operation best describes the purpose of the SET INTEGRITY PRUNE operation?

Answer options

• A. To prune the contents of a staging table.
• B. To prune the contents of a synopsis table.
• C. To prune the contents of a materialized query table (MQT).
• D. To prune the contents of a declared global temporary table.

Correct answer: A

Explanation

The correct answer is A, as the SET INTEGRITY PRUNE operation is specifically designed to remove or prune data from a staging table. Options B, C, and D refer to other types of tables and are not relevant to the SET INTEGRITY PRUNE operation's purpose.