module 1 part #2

Question 1

columns have different value for every row; Ensures that a column will not have duplicate values

Answer 1

UNIQUE constraint

Question 2

columns must have a value

Answer 2

NOT NULL constraint

Question 3

Validates data in an attribute

Answer 3

CHECK command

Question 4

A join that performs a relational product (or Cartesian product) of two tables.

Answer 4

Cross join

Question 5

A SQL clause that adds conditional restrictions to a SELECT statement that limit the rows returned by the query.

Answer 5

WHERE

Question 6

A query that is embedded (or nested) inside another query. Also known as a nested query or an inner query.

Answer 6

subquery