Oracle
1Z0-074 · Question #85
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…
The correct answer is B. when a CREATE INDEX statement is executed successfully in the same session D. when the session logs out successfully E. when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a. See the full explanation below for the reasoning.
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
How the community answered
(24 responses)- A8% (2)
- B83% (20)
- C4% (1)
- F4% (1)
Community Discussion
No community discussion yet for this question.