ITPub博客

首页 > 数据库 > Oracle > Oracle OCP 1Z0 053 Q707

Oracle OCP 1Z0 053 Q707

原创 Oracle 作者:abstractcyj 时间:2016-03-31 18:55:59 0 删除 编辑
707. Because of a logical corruption in the EMPLOYES tables, you want to perform Tablespace
Point-in-Time Recovery (TSPITR) to recover the table. Before you started the TSPITR process, you
queried the TS_PITR_CHECK view and you realized that the table has a referential constraint with
DEPARTMENTS that exists in another tablespace, MASTERTBS.
Which two actions will permit the TSPITR to work? (Choose two.)
A.Taking the MASTERTBS tablespace offline
B.Dropping the relationship between the tables
C.Adding the MASTERTBS tablespace to the recovery set
D.Putting the MASTERTBS tablespace in read-only mode
Answer:BC

B: 删除表之间的外键联系
C. 将表空间MASTERTBS也加入恢复集

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

请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    555
  • 访问量
    836917