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.
DISABLE VALIDATE disables the constraint and drops the index on the constraint, but keeps the constraint valid.
All other modifications to the table (inserts, updates, and deletes) by other SQL statements are disallowed.