A data file was moved to another physical location because of a media failure, and the ALTER DATABASE RENAME FILE statement was issued. Which of the following files is automatically updated to reflect this change?
-
Control
-
Alert
-
Registry
-
Parameter
A
Correct answer
Explanation
The control file contains the database's physical structure metadata including all data file names and locations. When you execute ALTER DATABASE RENAME FILE, Oracle automatically updates the control file to reflect the new path. Alert log entries are chronological records, parameter files are manual configs, and Registry stores Oracle software metadata - none auto-update from rename operations.