CONSTRAINTS UPDATED ACTUAL EXAM QUESTIONS AND CORRECT ANSWERS

CONSTRAINTS UPDATED ACTUAL EXAM
QUESTIONS AND CORRECT ANSWERS
Purpose of Constraints - CORRECT ANSWERS Constraints are rules used to enforce
business rules, practices, and policies to ensure the accuracy and integrity of data



The Five Common Constraints - CORRECT ANSWERS Primary Key, Foreign Key,
Unique, Check, Not Null



Constraint Naming Convention - CORRECT
ANSWERS Tablename_columnname_constraintype



Not Null constraint - CORRECT ANSWERS Alter Table orders

Modify ( Customer# Constraint orders_customer#_nn Not Null);



Primary Key and Foreign Key at the Table level - CORRECT ANSWERS come at the
end of the column list



Constraint equip_equipid_pk Primary Key (equipid),



Constraint equp_dept_fk Foreign Key (deptId)



Check Constraint - CORRECT ANSWERS Alter Table Orders

Add Constraint orders_shipdate_ck Check (orderdate <= shipdate);



Unique Constraint - CORRECT ANSWERS Alter Table books

Add Constraint books_title_uk Unique (title);