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?

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



Leave a Reply 0

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