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 physically relocates the file to +tdgroupA/data and renames the file to
datafile.dbf.
B.
The command creates a synonym, datafile.dbf, and places it in +tdgroupA/data and does
not remove the +tdgroupA.231.45678 file.
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 a file, datafile.dbf, in +tdgroupA/data and removes the references
for +tdgroupA.231.45678 from the data dictionary views.
E.
The command drops the file +tdgroupA.231.45678.
Explanation: