After performing a clean shut down of the database instance for maintenance, you mount the database and then execute a command to open the database:

SQL> ALTER DATABASE OPEN; Which two statements are true? (Choose two.)

Question

After performing a clean shut down of the database instance for maintenance, you mount the database and then execute a command to open the database:

SQL> ALTER DATABASE OPEN; Which two statements are true? (Choose two.)

Accepted Answer

A. The online redo log files and online data files are opened Opening the database transitions it from MOUNT to OPEN state by opening the online redo log files and data files, making them accessible for I/O operations. B. All the online data files headers are checked for consistency During the OPEN phase, Oracle reads and validates the SCN (System Change Number) in each online data file header against the control file to ensure consistency before allowing user access.

Answer

C. Instance recovery is performed before opening the database Instance recovery is only triggered after an abnormal shutdown - after a clean shutdown all files are already consistent and no recovery is required.

Answer

D. The path and existence of all the log file members are checked The path and existence of log file members are verified during the MOUNT phase when Oracle reads the control file, not during the OPEN phase.

After performing a clean shut down of the database instance for maintenance, you mount the database and then execute a command to open the database: SQL> ALTER DATABASE OPEN; Which two statements…

Question

Options

How the community answered

Why each option

Topics

Community Discussion