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 questionsWhen 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.
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.
- 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.
Keep practicing
Take the free 1Z0-082 practice test
Ten exam-style questions with answers and explanations, plus the exam facts and study guides.
More questions
Other 1Z0-082 practice questions
- Question 1Which three statements are true about using SQL*Plus?
- Question 2Which three statements are true about advanced connection options supported by Oracle Net…
- Question 3Which statement is true about the INTERSECT operator used in compound queries?
- Question 5Which two statements are true about the ORDER BY clause when used with a SQL statement co…
- Question 6Which three statements are true about the tools used to configure Oracle Net Services? (C…
- Question 7In your data center, Oracle Managed Files (OMF) is used for all databases. All tablespace…
