Which task would be accomplished by the command?

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?

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 relocates the file to +tdgroupA/data and renames the file to
datafile.dbf.

C.
The command creates a synonym, datafile.dbf, and places it in +tdgroupA/data and does
not remove the +tdgroupA.231.45678 file.

D.
The command creates a copy of the +tdgroupA.231.45678 file and places it in
+tdgroupA/data after renaming the file to datafile.dbf.

E.
The command creates a file, datafile.dbf, in +tdgroupA/data and removes the references
for +tdgroupA.231.45678 from the data dictionary views.



Leave a Reply 0

Your email address will not be published. Required fields are marked *