nerdexam
Oracle

1Z0-043 · Question #159

Consider the following scenario: You have a directory, data, under the disk group tdgroup You want to create an alias for one of the data files and you execute the following command: ALTER DISKGROUP…

The correct answer is D. The command creates a synonym, datafile.dbf, and places it in +tdgroupA/data and does not. See the full explanation below for the reasoning.

Question

Consider the following scenario:

You have a directory, data, under the disk group tdgroup You want to create an alias for one of the data files and you execute the following command:

ALTER DISKGROUP tdgroupA ADD ALIAS '+tdgroupA/data/datafile.dbf' For '+tdgroupA.231.45678'; Which task would be accomplished by the command?

Options

  • AThe command drops the file +tdgroupA.231.45678
  • BThe command physically relocates the file to +tdgroupA/data and renames the file to datafile.dbf.
  • CThe command creates a copy of the +tdgroupA.231.45678 file and places it in +tdgroupA/data
  • DThe command creates a synonym, datafile.dbf, and places it in +tdgroupA/data and does not
  • EThe command creates a file, datafile.dbf, in +tdgroupA/ data and removes the references for

How the community answered

(32 responses)
  • A
    3% (1)
  • B
    16% (5)
  • C
    6% (2)
  • D
    72% (23)
  • E
    3% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice