Which three statements are true regarding the above command?

Examine the following statement that is used to modify the primary key constraint on the
SALES table: SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE
VALIDATE; Which three statements are true regarding the above command? (Choose
three.)

Examine the following statement that is used to modify the primary key constraint on the
SALES table: SQL> ALTER TABLE SALES MODIFY CONSTRAINT pk DISABLE
VALIDATE; Which three statements are true regarding the above command? (Choose
three.)

A.
The index on the constraint is dropped.

B.
It allows the data manipulation on the table using INSERT/UPDATE/DELETE SQL
statements.

C.
It allows the loading of data into the table using SQL *Loader.

D.
The constraint remains valid.

E.
New data conforms to the constraint, but existing data is not checked.

Explanation:



Leave a Reply 2

Your email address will not be published. Required fields are marked *


fatima

fatima

why not E

Saurabh

Saurabh

Once they disable primary key, It will not check old data to verify existing record.