What is the result?

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.231.45678’;
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.