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 loading of data into the table using SQL *Loader.

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

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

E.
The constraint remains valid.



Leave a Reply 2

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


awing

awing

DISABLE VALIDATE disables the constraint and drops the index on the constraint, but keeps the constraint valid.

awing

awing

All other modifications to the table (inserts, updates, and deletes) by other SQL statements are disallowed.