可学答题网 > 问答 > 1Z0-052题库
目录: 标题| 题干| 答案| 搜索| 相关
问题

You execute this comma


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()

  • ANo flashback is possible to bring back the ITEM table.
  • BThe ORDER table is dropped along with the ITEM table.
  • CThe dependent referential integrity constraints in the ORDER table are disabled.
  • DThe dependent referential integrity constraints in the ORDER table are removed.
  • EThe table definition of the ITEM table and associated indexes are placed in the recycle bin.
参考答案
参考解析:
分类:1Z0-052题库
相关推荐

1、You executed the follo

You executed the following procedure to collect statistics regarding an index:      ...

2、You execute the follow

You execute the following command to enable a session in resumable mode: SQL> ALTER SESSION&en...

3、You execute the follow

You execute the following command to audit the database activities:  SQL> AUDIT DROP ANY ...

4、You execute the follow

You execute the following command in your Supportcenter.cn production database to change the width&e...

5、You executed the follo

You executed the following code:  BEGIN  DBMS_SCHEDULER.SET_ATTRIBUTE (  NAME => ’JOB_A&rsqu...

6、You execute the follow

You execute the following command to start an Automatic Storage Management (ASM) instance:  ...