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

You have two tables&en


You have two tables with referential integrity enforced between them. You need to insert data to the child tablefirst because it is going to be a long transaction and data for the parent table will be available in a later stage,which can be inserted as part of the same transaction. View the Exhibit to examine the commands used tocreate tables.  Which action would you take to delay the referential integrity checking until the end of thetransaction()

  • ASet the constraint to deferred before starting the transaction.
  • BAlter the constraint to NOVALIDATE state before starting the transaction.
  • CEnable the resumable mode for the session before starting the transaction.
  • DSet the COMMIT_WAIT parameter to FORCE_WAIT for the session before starting the transactio
参考答案
参考解析:
分类:1Z0-052题库
相关推荐

1、You have two computers

You have two computers named Computer1 and Computer2 that run Windows 7. You need to ensur...

2、You have two computers

You have two computers named Computer1 and Computer2 that run Windows 7. Computer2 is configure...

3、You have two computers

You have two computers named Computer1 and Computer2. Computer1 runs Windows Vista. Computer2runs Wi...

4、You have two computers

You have two computers named Computer1 and Computer2 that run Windows 7. You need to ensur...

5、You have two computers

You have two computers named Computer1 and Computer2 that run Windows 7. Both computers arememb...

6、You have two computers

You have two computers named Computer1 and Computer2. Computer1 runs Windows Vista. Computer2runs Wi...