Exam Prep Questions

1:You have two undo tablespaces defined for your database, undo01 and undo02. The instance is currently using undo01. You issue this command to switch to undo02 while transactions are still active in the database: 
ALTER SYSTEM SET UNDO_TABLESPACE = undo02

Which result occurs?

  • A. New transactions will be assigned to the undo02 tablespace.

  • B. Current transactions are switched to the undo02 tablespace.

  • C. The switch to undo02 fails, and an error message is returned because transactions are using undo01.

  • D. The switch to undo02 does not take place until all transactions in undo01 are completed.

A1: Answer A is correct; new transactions will be assigned to the undo02 undo tablespace. Answer B is incorrect; current transactions will ...

Get Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial