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.



Leave a Reply 1

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