Oracle
1Z0-071 · Question #442
1Z0-071 Question #442: Real Exam Question with Answer & Explanation
The correct answer is A. when a CREATE TABLE AS SELECT statement is issued in the same session but fails with a C. when the session logs out successfully D. when a CREATE INDEX statement is executed successfully in the same session. See the full explanation below for the reasoning.
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
Community Discussion
No community discussion yet for this question.