You are administering a database stored in Automatic Storage management (ASM). The files are storedin 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.