Multiple choice technology databases

You omit the UNDO tablespace clause in your CREATE DATABASE statment. The UNDO_MANAGEMENT parameter is set to AUTO. What is the result of your CREATE DATABASE statement ?

  1. The oracle server creates no undo tablespace.

  2. The oracle server creates an undo segment in the system tablespace.

  3. The oracle server cerates one undo tablespace with the name SYS_UNDOTBS.

  4. Database creation fails because you did not specify an undo tablespace on the create database statment.
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

When UNDO_MANAGEMENT is AUTO but no UNDO tablespace is specified in CREATE DATABASE, Oracle automatically creates an undo tablespace named SYS_UNDOTBS. This is default behavior to ensure automatic undo management works properly. Oracle does not create undo segments in the SYSTEM tablespace, nor does database creation fail.

AI explanation

When UNDO_MANAGEMENT=AUTO and no UNDO TABLESPACE clause is given in CREATE DATABASE, Oracle doesn't fail or skip undo setup — it automatically creates a default undo tablespace named SYS_UNDOTBS (later renamed via ALTER TABLESPACE if you want a custom name). This is Oracle's built-in fallback so automatic undo management always has a tablespace to use.

Keep practicing — related questions