A data file was moved to another physical location because of a media failure, and the ALTER DATABASE RENAME FILE statement was issued. Which file is automatically updated to reflect this change?
-
Control
-
Alert
-
Registry
-
Parameter
A
Correct answer
Explanation
The correct answer is A because the control file is automatically updated to reflect the new data file location when ALTER DATABASE RENAME FILE is executed. The control file maintains the database's physical structure. Options B (Alert log), C (Registry), and D (Parameter file) are not automatically updated by this operation.