Oracle
1Z0-082 · Question #122
1Z0-082 Question #122: Real Exam Question with Answer & Explanation
The correct answer is A. when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then B. when a CREATE INDEX statement is executed successfully in the same session D. when the session logs out successfully. 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. Which three situations does the transaction complete thereby committing the updates?
Options
- Awhen a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then
- 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
- 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
Community Discussion
No community discussion yet for this question.