Oracle
1Z0-060 · Question #173
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…
The correct answer is B. All pending DML statements on the SALES table will wait for 600 seconds before the procedure. Wait up to 600 seconds for required locks on SH.SALES: EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE ( 'SH', 'SALES', 'INT_SALES', 600);
New Features for Manageability
Question
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?
Options
- AAll pending DML statements on the SALES table must be committed 600 seconds before the
- BAll pending DML statements on the SALES table will wait for 600 seconds before the procedure
- CAll pending DML statements on the SALES_INT table must be committed 600 seconds before the
- DIt specifies the number of seconds the procedure waits for its required locks before it ends
How the community answered
(25 responses)- A12% (3)
- B76% (19)
- C8% (2)
- D4% (1)
Explanation
Wait up to 600 seconds for required locks on SH.SALES: EXECUTE DBMS_REDEFINITION.FINISH_REDEF_TABLE ( 'SH', 'SALES', 'INT_SALES', 600);
Topics
#online redefinition#DBMS_REDEFINITION#DML lock timeout#FINISH_REDEF_TABLE
Community Discussion
No community discussion yet for this question.