多选题

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

略

相似试题

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?（）
单选题查看答案

语音搜题

拍照搜题

打赏

Oracle认证