module 1 part #2 Flashcards
1
Q
columns have different value for every row; Ensures that a column will not have duplicate values
A
UNIQUE constraint
2
Q
columns must have a value
A
NOT NULL constraint
3
Q
Validates data in an attribute
A
CHECK command
4
Q
A join that performs a relational product (or Cartesian product) of two tables.
A
Cross join
5
Q
A SQL clause that adds conditional restrictions to a SELECT statement that limit the rows returned by the query.
A
WHERE
6
Q
A query that is embedded (or nested) inside another query. Also known as a nested query or an inner query.
A
subquery
7
Q
A
