PrepAway - Latest Free Exam Questions & Answers

What correctly describes an MDC table rollout cleanup for qualifying DELETE statements after the statement sho

What correctly describes an MDC table rollout cleanup for qualifying DELETE statements after the
statement shown below is run?
SET CURRENT MDC ROLLOUT MODE IMMEDIATE

PrepAway - Latest Free Exam Questions & Answers

A.
MDC rollout optimization is not used. The RID indexes are updated
immediately during the delete process. The deleted blocks are available for reuse after the
transaction commits.

B.
MDC rollout optimization is used. The RID indexes are updated immediately during the delete
process. The deleted blocks are available for reuse after the transaction commits.

C.
MDC rollout optimization is not used. The DELETE statement is processed in the same way as a
DELETE statement that does not qualify for rollout.

D.
MDC rollout optimization is used. The RID indexes are updated immediately during the delete
process. The deleted blocks are available for reuse after an online REORG with the new RECLAIM
EXTENTS clause.


Leave a Reply