Oracle Exam 1Z0-062 Topic 9 Question 3 Discussion

Actual exam question for Oracle's 1Z0-062 exam

Question #: 3
Topic #: 9

A database is open READ WRITE and the instance has multiple sessions some of which have active

transactions.

You execute this command:

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

Which three are true about the active transactions? (Choose three.)

AThey may issue COMMIT OR ROLLBACK statements

BThey are suspended and unable to issue any statements

CThey may continue to issue DML statements

DThey are rolled back automatically

EThey may continue to issue queries

FThey are terminated immediately

Show Suggested Answer

Suggested Answer: B, D, F

by Annabelle at May 04, 2022, 12:07 AM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!