首页计算机考试Oracle认证
(多选题)

A constraint in a table is defined with the INITIALLY IMMEDIATE clause. You executed the ALTER TABLEcommand with the ENABLE VALIDATE option to enable the constraint that was disabled.  What are the twoeffects of this command()

AIt fails if any existing row violates the constraint.

BIt does not validate the existing data in the table.

CIt enables the constraint to be enforced at the end of each transaction.

DIt prevents insert, update, and delete operations on the table while the constraint is in the process of beingenabled

正确答案

来源:www.examk.com

答案解析

相似试题

  • (单选题)

    What is true regarding a transaction executed in Automatic Undo Management mode?()

    答案解析

  • (单选题)

    Which statement is true about a whole consistent database backup on a database running in ARCHIVELOGmode()

    答案解析

  • (单选题)

    Given: What creates the appropriate DateFormat object and adds a day to the Date object?()

    答案解析

  • (多选题)

    You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader direct pathload method to perform this task. The table in which you plan to load data is an important table having variousintegrity constraints defined on it.  Which constraints will remain enabled by default during this operation()

    答案解析

  • (多选题)

    You plan to move data from a flat file to a table in your database. You decide to use SQL*Loader directpath load method to perform this task. The table in which you plan to load data is an important tablehaving various integrity constraints defined on it.  Which constraints will remain enabled by default during this operation()

    答案解析

  • (单选题)

    Given: Which exception or error will be thrown when a programmer attempts to run this code?()

    答案解析

  • (单选题)

    Which statement explicitly names a constraint?()

    答案解析

  • (单选题)

    Which statement explicitly names a constraint? ()

    答案解析

  • (单选题)

    Which statement explicitly names a constraint?()

    答案解析

快考试在线搜题