1Z0-082 practice question 20 of 25

While one of your databases was in mount state, the datafiles were renamed because they had been moved to a new file system. The database was then opened. Which two statements are true?

Full set: 142 questions
Answer options
A: DBA_DATA_FILES displays the original name for the data files.
B: V$DATAFILE displays the new names for the data files. Correct answer
C: DBA_DATA _FILES displays both the new name and the old name for the data files.
D: DBA_DATA_FILES displays the new name for the data files. Correct answer
E: DBA_DATA_FILES must be resynchronized manually with the control file an order to have it display the new file names.
Correct Answer:
B. V$DATAFILE displays the new names for the data files.; D. DBA_DATA_FILES displays the new name for the data files.
Explanation

When a datafile is renamed using ALTER DATABASE RENAME FILE..., the Oracle control file is updated with the new file path. The database must be in the MOUNT state for this operation. The V$DATAFILE view displays information directly from the control file's in-memory image, so it will reflect the new, current name. The data dictionary's base tables (e.g., SYS.FILE$) are also updated by this command. The DBADATAFILES view reads from the data dictionary, so it will also display the new name after the database is opened.

Why Incorrect

A. DBADATAFILES reads from the data dictionary, which is updated by the rename command to reflect the new name, not the original one.
C. The DBADATAFILES view contains a single column (FILENAME) for the file path; it does not store a history of old names.
E. The ALTER DATABASE RENAME FILE command automatically synchronizes the control file and the data dictionary. No manual resynchronization is needed.

References

- Oracle Database Administrator's Guide

19c

Chapter 13

"Managing Data Files and Temp Files"

section "Renaming and Relocating Data Files". This section details the procedure and its effect on the control file.

- Oracle Database Reference

19c

"V$DATAFILE". It states the view "Contains datafile information from the control file."

- Oracle Database Reference

19c

"DBADATAFILES". It is described as showing "Information about database files

" which reflects the current state recorded in the data dictionary.

Scroll to Top