OCP CBT Question 636

Please solve the following question.

You are starting an Oracle database instance. Which statement is true regarding the various startup modes?

sqlSQL> STARTUP NOMOUNT;SQL> ALTER DATABASE MOUNT;SQL> ALTER DATABASE OPEN;

In NOMOUNT mode, the instance is started, SGA is allocated, and background processes are started, but the control files are not read.

In MOUNT mode, the database is available for normal user connections and DML operations.

STARTUP OPEN automatically performs NOMOUNT and MOUNT stages without requiring separate commands.

When starting with STARTUP RESTRICT, only SYSDBA and SYSOPER users can connect, and it bypasses mounting the database.