Oracle
1Z0-062 · Question #371
1Z0-062 Question #371: Real Exam Question with Answer & Explanation
Sign in or unlock 1Z0-062 to reveal the answer and full explanation for question #371. The question stem and answer options stay visible for context.
Managing the Database Instance
Question
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.)
Options
- 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
Unlock 1Z0-062 to see the answer
You've previewed enough free 1Z0-062 questions. Unlock 1Z0-062 for full answers, explanations, the timed quiz mode, progress tracking, and the master PDF. Question stem and options stay visible so you can still see what's on the exam.
Topics
#RESTRICTED SESSION#active transactions#DML#COMMIT/ROLLBACK