多做题,通过考试没问题!

Oracle认证考试

睦霖题库>其他计算机考试>Oracle认证考试

You execute this command to drop the ITEM table, which has the primary key referred in the ORDERtable:  SQL> DROP TABLE scott.item CASCADE CONSTRAINTS PURGE;  Which two statements are true about the effect of the command()

  • A、No flashback is possible to bring back the ITEM table.
  • B、The ORDER table is dropped along with the ITEM table.
  • C、The dependent referential integrity constraints in the ORDER table are disabled.
  • D、The dependent referential integrity constraints in the ORDER table are removed.
  • E、The table definition of the ITEM table and associated indexes are placed in the recycle bin.
正确答案:A,D
答案解析:
进入题库查看解析

微信扫一扫手机做题