Multiple choice technology databases

Your database contains at least one undo tablespace. You attempt to start an instance in Automatic Undo Management mode, but without specifying an undo tablespace in the initialization parameter file. What happens?

  1. The instance will not start.

  2. The instance starts up and uses the SYSTEM rollback segment for all undo entries.

  3. The instance starts up and uses the SYSTEM tablespace for the automatic undo segments.

  4. The instance starts up and uses the first available undo tablespace for the automatic undo segments.
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

In Automatic Undo Management mode, if no UNDO_TABLESPACE parameter is specified, Oracle automatically selects the first available undo tablespace. The instance starts successfully and uses this available undo tablespace. It doesn't fail, and doesn't fall back to SYSTEM rollback segments or tablespace for undo data.

Keep practicing — related questions