Test: Quiz: Defining Not Null and Unique Constraints

Review your answers, feedback, and question scores below. An asterisk (*) indicates a correct answer.

	Section 1
		1.	A table can have more than one UNIQUE key constraint. True or False?		Mark for Review (1) Points
			True (*)
			False
				Correct
		2.	A column defined as NOT NULL can have a DEFAULT value of NULL. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct
		3.	Which of the following is not a valid Oracle constraint type?		Mark for Review (1) Points
			UNIQUE KEY
			NOT NULL
			EXTERNAL KEY (*)
			PRIMARY KEY
				Correct
		4.	If the employees table has a UNIQUE constraint on the DEPARTMENT_ID column, we can only have one employee per department. True or False?		Mark for Review (1) Points
			True (*)
			False
				Correct
		5.	A unique key constraint can only be defined on a not null column. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct
		6.	A table must have at least one not null constraint and one unique constraint. True or False?		Mark for Review (1) Points
			True
			False (*)
				Correct

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