Oracle
1Z0-082 · Question #120
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?
The correct answer is A. DBA_DATA_FILES displays the original name for the data files. C. DBA_DATA _FILES displays both the new name and the old name for the data files. See the full explanation below for the reasoning.
Manage Tablespaces and Datafiles
Question
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?
Options
- ADBA_DATA_FILES displays the original name for the data files.
- BV$DATAFILE displays the new names for the data files.
- CDBA_DATA _FILES displays both the new name and the old name for the data files.
- DDBA_DATA_FILES displays the new name for the data files.
- EDBA_DATA_FILES must be resynchronized manually with the control file an order to have it
How the community answered
(38 responses)- A74% (28)
- B3% (1)
- D16% (6)
- E8% (3)
Topics
#DBA_DATA_FILES#V$DATAFILE#datafile rename#control file
Community Discussion
No community discussion yet for this question.