ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 043-134

043-134

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-09 15:51:49 0 删除 编辑
134. Consider the following scenario: You have a directory, data, und
er the disk group tdgroup A. You want to create an alias for one of t
he 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 relocates 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 remaining the file to datafile.dbf.
D. The command creates a synonym, datafile.dbf, and places it in +tdg
roupA/data and does not remove the +tdgroupA.231.45678 file.
E. The command creates a file, datafile.dbf, in +tdgroupA/ data and r
emoves the references for +tdgroupA.231.45678 from the data dictionar
y views.
Answer: D
Alias names (or just "aliases") are intended to provide a more us
er-friendly means of referring to ASM files, rather than using the sy
stem-generated filenames. You can create an alias for a file when you
create it in the database, or you can add an alias to an existing fi
le using the ADD ALIAS clause of the ALTER DISKGROUP statement. You c
an create an alias in any system-generated or user-created ASM direct
ory. You cannot create an alias at the root level (+), however. The f
ollowing statement adds a new alias name for a system-generated file
name:
ALTER DISKGROUP dgroup1 ADD ALIAS '+dgroup1/mydir/second.dbf' FOR '+d
group1/sample/datafile/mytable.342.3';

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/11312660/viewspace-718168/,如需转载,请注明出处,否则将追究法律责任。

上一篇: 032-133
下一篇: 043-135
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    203134