Oracle Database Administration I — Question 79

Which two statements are true about views used for viewing tablespace and datafile information? (Choose two.)

Answer options

• A. Tablespace free space can be viewed in V$TABLESPACE
• B. V$TABLESPACE displays information that is contained in the controlfile about tablespaces
• C. V$TABLESPACE displays information about tablespaces contained in the data dictionary
• D. Tablespace free space can be viewed in DBA_TABLESPACES
• E. A datafile can be renamed when the database is in MOUNT state and the new file name is displayed when querying DBA_DATA_FILES after the database is opened

Correct answer: B, E

Explanation

Option B is correct because V$TABLESPACE provides information sourced from the controlfile about tablespaces. Option E is also valid since it confirms that datafiles can be renamed in MOUNT state, and the changes will be reflected in DBA_DATA_FILES post database opening. Options A, C, and D are incorrect as they do not accurately describe the information displayed in the specified views.