Exam 1z0-060 topic 2 question 2 discussion

Actual exam question from Oracle's 1z0-060

Question #: 2
Topic #: 2

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?

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.

Show Suggested Answer

Suggested Answer: B 🗳️
Wait up to 600 seconds for required locks on SH.SALES:
EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE (
'SH', 'SALES', 'INT_SALES', 600);
Reference:
http://oradb-srv.wlv.ac.uk/E50529_01/ARPLS/d_redefi.htm#ARPLS042

by Blade69 at Dec. 30, 2021, 10:05 p.m.

Comments

Submit Cancel

Blade69

3 years, 4 months ago

from https://docs.oracle.com/database/121/ARPLS/d_redefi.htm#ARPLS74410 Wait up to 600 seconds for required locks on SH.SALES: EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE ( 'SH', 'SALES', 'INT_SALES', 600);

upvoted 1 times

...

Blade69

3 years, 4 months ago

From https://docs.oracle.com/database/121/ARPLS/d_redefi.htm#ARPLS74410 dml_lock_timeout - Specifies the number of seconds the procedure waits for its required locks before failing. The permissible range of values for timeout is 0 to 1,000,000. The default is NULL (wait mode). So the Answer id D

upvoted 1 times

...

Exam 1z0-060 All Questions

View all questions & answers for the 1z0-060 exam

Exam 1z0-060 topic 2 question 2 discussion

Comments

Blade69

Blade69

SY0-701