Upgrade to Oracle Database 12c — Question 35

To complete the online redefinition procedure, you execute the following command;
EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE("˜SH', "˜SALES', "˜INT_SALES', 600);
What is the significance of the dml_lock_timeout period of 600 seconds in the preceding command?

Answer options

• A. All pending DML statements on the SALES table must be committed 600 seconds before the procedure ends gracefully.
• B. All pending DML statements on the SALES table will wait for 600 seconds before the procedure ends gracefully.
• C. All pending DML statements on the SALES_INT table must be committed 600 seconds before the procedure ends gracefully.
• D. It specifies the number of seconds the procedure waits for its required locks before it ends gracefully.

Correct answer: B

Explanation

The correct answer is B because the dml_lock_timeout specifies the waiting period for pending DML statements, allowing them to wait for 600 seconds. Option A is incorrect as it suggests a requirement for committing before the procedure ends, which is not the case. Option C incorrectly references the SALES_INT table, and option D misinterprets the purpose of the timeout, as it does not describe the waiting behavior accurately.