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?

Options

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
Explanation/Reference:

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.

Show Answer
FOR COMPLETE DUMPS4DOWNLOAD 1z0-060 DUMPS PDF FILE

2 Exams PDF Files

$90 Original Price $ 100

  • Latest and Most Up-todate Dumps
  • Free 3 Months Updates
  • Exam Passing Guarantee
  • Secure Payment
  • Privacy Protection

3 Exams PDF Files

$125 Original Price $ 150

  • Latest and Most Up-todate Dumps
  • Free 3 Months Updates
  • Exam Passing Guarantee
  • Secure Payment
  • Privacy Protection

4 Exams PDF Files

$165 Original Price $ 200

  • Latest and Most Up-todate Dumps
  • Free 3 Months Updates
  • Exam Passing Guarantee
  • Secure Payment
  • Privacy Protection

5 Exams PDF Files

$190 Original Price $ 250

  • Latest and Most Up-todate Dumps
  • Free 3 Months Updates
  • Exam Passing Guarantee
  • Secure Payment
  • Privacy Protection