Multiple choice technology databases

Which method is correct for starting an instance to create a database?

  1. STARTUP

  2. STARTUP OPEN

  3. STARTUP MOUNT

  4. STARTUP NOMOUNT
Reveal answer Fill a bubble to check yourself
D Correct answer
Explanation

STARTUP NOMOUNT is used when creating a new database because it starts the instance (SGA and background processes) without mounting a database. At this stage, Oracle reads the parameter file but doesn't look for a control file (which doesn't exist yet for a new database). STARTUP MOUNT requires an existing control file, STARTUP OPEN requires an existing database, and plain STARTUP is equivalent to STARTUP OPEN.

Keep practicing — related questions