Oracle 9i Fundamentals I Exam Cram™ 2 (Exam 1Z0-031)

Exam Prep Questions

1:	What command would you use to disable a constraint? A. ALTER TABLE B. DROP CONSTRAINT C. ALTER SESSION D. DELETE CONSTRAINT
A1:	Answer A is correct; you would disable the constraint with the ALTER TABLE command. Answer B is incorrect because the DROP CONSTRAINT clause to the ALTER TABLE statement would not disable the constraint but would delete it. Answer C is incorrect; ALTER SESSION allows you to change validation methods (DEFERRED, IMMEDIATE, VALIDATE, or NO VALIDATE) but does not allow you to disable it. Answer D is incorrect; DELETE CONSTRAINT isn't a valid command or clause to a command.
2:	Which keywords would you use to allow exiting data in a table to violate a constraint while causing the constraint to validate new ...