Wgu D427 1.9-1.12 Questions And Answers 100% Verified A+ Guaranteed

auto-increment column {Ans: a numeric column that is assigned an automatically incrementing value when a new row is inserted.}primary key {Ans: a column, or group of columns, used to identify a row.}ON UPDATE / ON DELETE {Ans: determine what happens to the foreign key when the referenced primary key is updated or deleted. When several foreign keys refer to the same primary key, different actions can be specified for each foreign key. Followed by either restrict, set null, set default, or cascade.}Minimal {Ans: All primary key columns are necessary for uniqueness. When any column is removed, the resulting simple or composite column is no longer unique.}CHECK {Ans: This constraint specifies an expression on one or more columns of a table. The constraint is violated when the expression is FALSE and satisfied when the expression is either TRUE or NULL.}foreign key {Ans: a column, or group of columns, that refer to a primary key.}