returns records that have matching values in both tables
What is a JOIN or INNER JOIN
100
Returns all records when there is a match in either left or right table
What is FULL JOIN
100
give a table or column a temporary name
What is an alias or correlation name
100
result is true or false
What is a Boolean expression
100
1 customer can place many orders
What is a 1 to many relationship
200
result set that occurs from multiple joins (you don’t see this, it is temporary)
What is interim result set
200
returns all records from the right table, and the matched records from the left table
What is RIGHT JOIN
200
table name, a dot, the column name
What is a fully qualified object name
200
+ sign
What is a concatenation operator
200
1 employee can have 1 set of benefits
What is a one-to-one relationship
300
syntax without the JOIN keyed in
What is implicit syntax
300
returns all records from the left table, and the matched records from the right table
What is LEFT JOIN
300
a join based on columns that aren't keys or foreign keys
What is an ad hoc relationship
300
*, %, _
What is a wildcard character
300
A unique identifier made up from multiple columns.
What is a composite key
400
joins tables to create a grid
What is cross join
400
indicates which columns you are connecting tables on.
What is ON clause
400
temporary table
What is an interim table
400
represents nothing
What is a NULL value
400
char, varchar, int, money
What is data types
500
any operator that uses result sets (Union, Intersect and Except)
What is set operator
500
occurs when you join a table to itself.
What is Self-Join
500
theta syntax
What is implicit syntax
500
Anything in parenthesis is done first. Multiplication and division are evaluated next (from left to right), followed by addition and subtraction (from left to right).