Test: Quiz: Managing Constraints

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 (*)
				Correct
		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
				Correct
		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 (*)
				Correct
		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
				Correct
		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 (*)
				Correct

( Vrei sa traduci ceva?Want to translate something? http://translate.google.ro/# )