Mastering Constraints

Check (correct)

Primary key

Unique

Not null

Primary key constraint

Foreign key constraint

Column constraint

Table constraint (correct)

To combine NOT NULL and UNIQUE properties

To ensure a column may not have duplicate values

To ensure a field has a value

To reference a field in another table (correct)

<p>&lt;table_name&gt;<em>&lt;field_name&gt;</em><abbreviation></p> Signup and view all the answers

<p>It allows for more descriptive error messages when a constraint is violated</p> Signup and view all the answers