98. Consider the following scenario: You have a directory, data, unde

r 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?

A. The command drops the file +tdgroupA.231.45678.

B. The command physically relocated the file to +tdgroupA/data and re

names the file to datafile.dbf.

C. The command creates a copy of the +tdgroupA.231.45678 file and pla

ces it in +tdgroupA/data after renaming the file to datafile.dbf.

D. The command creates an alias, datafile.dbf, and places it in +tdgr

oupA/data and does not remove the tdgroupA 231.45678 file.

E. The command creates a file, datafile.dbf, in +tdgroupA/data and re

moved the references for +tdgroupA.231.45678 from the data dictionary

views.

Answer: D

ALTER DISKGROUP tdgroupA ADD ALIAS '+tdgroupA/data/datafile.dbf'

FOR '+tdgroupA.231.45678'

该命令创建了一个同义词datafile.dbf 并放在+tdgroupA/data/目录下，

但不影响原来的的+tdgroupA.231.45678 文件

ITPub博客

043-098