nerdexam
Oracle

1Z0-043 · Question #119

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

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

Question

Consider the following scenario:

You have a directory, data, under the disk group tdgroupA. 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 relocated 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 after
  • DThe command creates an alias, datafile.dbf, and places it in +tdgroupA/data and does not remove the
  • EThe command creates a file, datafile.dbf, in +tdgroupA/data and removed the references for

How the community answered

(25 responses)
  • A
    8% (2)
  • C
    4% (1)
  • D
    84% (21)
  • E
    4% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-043 Practice