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

If Automatic Undo Management is enabled but no undo tablespace is specified, Oracle will automatically select and use the first available undo tablespace in the database.

Keep practicing — related questions