ITPub博客

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

043-050

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-05 11:16:25 0 删除 编辑
50. You are managing an Oracle Database 10g database that uses Oracle
Managed Files (OMF). You enabled the block change tracking feature f
or the database. Which statement regarding the change tracking file i
s true?
A. One block change tracking file is created for each data file. By d
efault, the file is created in DB_CREATE_FILE_DEST.
B. One block change tracking file is created for each data file. By d
efault, the file is created in BACKGROUND_DUMP_DEST.
C. One block change tracking file is created for the database. By def
ault, the file is created in DB_CREATE_FILE_DEST.
D. One block change tracking file is created for the database. By def
ault, the file is created in BACKGROUND_DUMP_DEST.
Answer: C
SQL> ALTER DATABASE ENABLE BLOCK CHANGE TRACKING;
由于没有指定存放路径,那么会按照Oracle Managed Files (OMF)参数
DB_CREATE_FILE_DEST 指定的路径
Oracle managed file (OMF)
A file that is created automatically by the Oracle database server when
it is needed and automatically deleted when it is no longer needed.
如何判断你的数据库是否为支持OMF
SQL> show parameter db_create_file_dest;
如果Value 为空则不支持,有值则支持

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

上一篇: 043-049
下一篇: 困惑
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    203401