Free 1z0-060 Sample Question 20
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.
Correct Answer: C
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.