Oracle Database 11g: Administration I — Question 11

Which are three of the various resources that must be accessible to keep a database open? (Choose three.)

Answer options

• A. SYSTEM tablespace
• B. spfile
• C. all members of a redo log group
• D. SYSAUX tablespace
• E. control file

Correct answer: A, D, E

Explanation

The SYSTEM tablespace, SYSAUX tablespace, and control file are critical for the database to remain open and functional, as they store essential metadata and configuration. The spfile is necessary for startup configurations, and while redo log groups are important for recovery, they are not required for the database to stay open.