You are administering a database stored in Automatic Storage management (ASM). The files are stored in the
DATA disk group. You execute the following command:
SQL > ALTER DISKGROUP data ADD ALIAS +data/prod/myfile.dbf` FOR `+data/prod/myfile.dbf’
What is the result?
A.
The file +data.231.54769` is physically relocated to +data/prod` and renamed as myfile.dbf`.
B.
The file +data.231.54769` is renamed as myfile.dbf`, and copied to +data/prod`.
C.
The file `+data.231.54769′ remains in the same location and a synonym ‘myfile.dbf’ is created.
D.
The file myfile.dbf` is created in +data/prod` and the reference to +data.231.54769` in the data dictionary
removed.
Explanation:
ADD ALIAS
Use this clause to create an alias name for an Oracle ASM filename. The alias_name consists of the full
directory path and the alias itself.