• Description:Fundamentals I
• Passing Score:75%
• Practice Test - Number of questions:99 questions
• Simulation Test - Number of questions:99 questions
• Simulation Test Duration:90 minutes
• Has explanations:No

You are using rollback segments in your database. To ease transaction management, you want to implement automatic undo management by using the following steps: 1. creating an undo tablespace 2. setting the UNDO_MANAGEMENT parameter to AUTO in the parameter file 3. changing the tablespace that has the rollback segments to an undo tablespace by using the

Answer(s)

1. TABLESPACE command4. setting the UNDO_TABLESPACE parameter to the tablespace that has the rollback segments5. dropping the rollback segments and create undo segments in the same tablespace that has therollback segmentsWhich option would you use?A. 3 only
2. 1 and 2 only
3. 2 and 3 only
4. 3 and 5 only
5. 2 and 5 only

1 and 2 only