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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.