CONSTRAINTS ACTUAL EXAM QUESTIONS AND CORRECT ANSWERS

CONSTRAINTS ACTUAL EXAM QUESTIONS AND
CORRECT ANSWERS
A(n) ____________________ constraint limits the value that can be placed in a specific column,
irrespective of values that exist in other table rows - CORRECT ANSWERS column



A(n) ____________________ constraint is a table constraint that specifies that a column must
have a unique value for every table row. - CORRECT ANSWERS unique



____________________ are restrictions on the data values that a column can store. - CORRECT
ANSWERS constraints



A primary key is defined using an integrity constraint. - CORRECT ANSWERS True



Which of the following is a table constraint? - CORRECT ANSWERS unique constraint



Which of the following is not created using an integrity constraint? - CORRECT
ANSWERS surrogate key



____ constraints define specific data values or data ranges that must be inserted into columns
and whether values must be unique or not NULL. - CORRECT ANSWERS Value



A(n) ____________________ enables you to specify that a column value must be a specific
value or fall within a range of values. - CORRECT ANSWERS check constraint



Which command would be used to delete table x and all foreign key constraints to x? - CORRECT
ANSWERS drop x cascade constraints