Oracle Database 11g: Administration I — Question 29

Which is true about the SYSTEM and SYSAUX tablespaces?

Answer options

• A. Both tablespaces can be used for temporary storage if no temporary tablespace is defined
• B. Both tablespaces must be online for a database to be accessible
• C. The SYSAUX tablespace can be made read-only but the SYSTEM tablespace cannot
• D. Only the SYSTEM tablespace contains data dictionary tables

Correct answer: C

Explanation

The correct answer is C because the SYSAUX tablespace is designed to be flexible and can be made read-only, while the SYSTEM tablespace is essential for database operations and cannot be set to read-only. Options A and B are incorrect because these tablespaces serve specific roles and do not function as temporary storage or require both to be online for accessibility. Option D is also incorrect since the SYSTEM tablespace primarily contains data dictionary tables, but not exclusively.