Oracle
1Z0-074 · Question #85
1Z0-074 Question #85: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-074 to reveal the answer and full explanation for question #85. The question stem and answer options stay visible for context.
Question
An Oracle database server session has an uncommitted transaction in progress which updated 5000 rows in a table. In which three situations does the transactions complete thereby committing the updates? (Choose three.)
Options
- Awhen a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues
- Bwhen a CREATE INDEX statement is executed successfully in the same session
- Cwhen a COMMIT statement is issued by the same user from another session in the same database
- Dwhen the session logs out successfully
- Ewhen a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a
- Fwhen a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session
Unlock 1Z0-074 to see the answer
You've previewed enough free 1Z0-074 questions. Unlock 1Z0-074 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.