Oracle Database SQL 12c 1z0-071 Exam Practice Test 4

Question : 39 of 57

Marks: +1, -0

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.)

when a DBA issues a successful SHUTDOWN TRANSACTIONAL statement and the user then issues a COMMIT
when a CREATE INDEX statement is executed successfully in the same session
when a COMMIT statement is issued by the same user from another session in the same database instance
when the session logs out successfully
when a DBA issues a successful SHUTDOWN IMMEDIATE statement and the user then issues a COMMIT
when a CREATE TABLE AS SELECT statement is executed unsuccessfully in the same session

Validate

Go to Question:

Prev Question

Next Question