Oracle
1Z0-071 · Question #442
An Oracle Database session has an uncommitted transaction in progress which updated 5000 rows in a table. In which three situations does the transaction complete thereby committing the updates?…
Sign in or unlock 1Z0-071 to reveal the answer and full explanation for question #442. The question stem and answer options stay visible for context.
Question
An Oracle Database session has an uncommitted transaction in progress which updated 5000 rows in a table. In which three situations does the transaction complete thereby committing the updates? (Choose three.)
Options
- Awhen a CREATE TABLE AS SELECT statement is issued in the same session but fails with a
- Bwhen a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then
- Cwhen the session logs out successfully
- Dwhen a CREATE INDEX statement is executed successfully in the same session
- Ewhen a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a
- Fwhen a COMMIT statement is issued by the same user from another session in the same
Unlock 1Z0-071 to see the answer
You've previewed enough free 1Z0-071 questions. Unlock 1Z0-071 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.