Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.
Section 1
1. Once constraints have been created on a table you will have to live with them as they are unless you drop and re-create the table. True or False?Mark for Review
(1) Points
True
False (*)
2. The command to 'switch off' a constraint is:Mark for Review
(1) Points
ALTER TABLE STOP CHECKING
ALTER TABLE STOP CONSTRAINTS
ALTER TABLE DISABLE CONSTRAINT (*)
ALTER TABLE PAUSE CONSTRAINT
3. What mechamisn does Oracle use in the background to enforce uniqueness in Primary and Unique key constraints? Mark for Review
(1) Points
Ordered Lists
Internal Pointers
Nothing extra is created when Primary Keys and Unique Keys are created
Unique indexes are created in the background by Oracle when Primary and Unique constraints are created or enabled (*)
4. All of a user's constraints can be viewed in the Oracle Data Dictionary view called:Mark for Review
(1) Points
USER_TABLES
USER_CONSTRAINTS (*)
CONSTRAINTS
TABLE_CONSTRAINTS
5. You can drop a column in a table with a simple ALTER TABLE DROP COLUMN statement, even if the column is referenced in a constraint. True or False?Mark for Review
(1) Points
True
False (*)
