ExamQuestions.com

Register
Login
Oracle Database 12c Installation and Administration Exam Questions

Oracle

Oracle Database 12c Installation and Administration

153 / 190

Question 153:

Examine the parameters for a database instance: 
image
Your database has three undo tablespaces and the default undo tablespace is not autoextensible. Resumable space allocation is not enabled for any sessions in the database instance. What is the effect on new transactions when all undo space in the default undo tablespace is in use by active transactions? 

Answer options:

A. Transactions write their undo in the SYSTEM undo segment.
B. Transactions fail.
C. Transactions wait until space becomes available in UNDOTBS1.
D. Transactions write their undo in a temporary tablespace.