Consider the following scenario:
You have a directory, data, under the disk group tdgroup
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 relocates 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 remaining the file to datafile.dbf.
D.
The command creates a synonym, 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 removes the references for +tdgroupA.231.45678 from the data dictionary views.
Answer C is shown as being the right answer, but it looks like D is more accurate.