Consider the following scenario:
You have a directory, data, under the disk group tdgroupA. You want to create an alias for one of the data files and you execute the following command:
ALTER DISKGROUP tdgroupA
ADD ALIAS ‘+tdgroupA/data/datafile.dbf’
FOR ‘+tdgroupA.231.45678’;
Which task would be accomplished by the command?
A.
The command drops the file +tdgroupA.231.45678.
B.
The command physically relocated the file to +tdgroupA/data and renames the file to datafile.dbf.
C.
The command creates a copy of the +tdgroupA.231.45678 file and places it in +tdgroupA/data after renaming the file to datafile.dbf.
D.
The command creates an alias, datafile.dbf, and places it in +tdgroupA/data and does not remove the tdgroupA 231.45678 file.
E.
The command creates a file, datafile.dbf, in +tdgroupA/data and removed the references for +tdgroupA.231.45678 from the data dictionary views.
Explanation:
Oracle Database Administrator Guide Ch12 P25