The process of combining two or more tables by finding rows in the tables that have identical values in matching fields
What is join?
100
Operator that precedes a subquery to make a condition true only if it satisfies all values produced by the subquery
What is ALL?
100
An application program’s or an individual user’s picture of the database
What is a view?
100
The table referenced by a foreign key
What is parent?
100
The SQL command used to ensure that only unique values are allowed in a non-primary key column
What is CREATE UNIQUE INDEX?
200
A join that compares the tables in the FROM clause and lists only those rows that satisfy the condition in the WHERE clause
What is an inner join?
200
Operator that creates a temporary table containing the set of all rows that are in the first table but that are not in the second table
What is MINUS?
200
The SQL command used to delete a view
What is Drop View?
200
A column in one table whose values match the primary key of another table
What is a foreign key?
200
The SQL command used to delete an index
What is DROP INDEX?
300
A join in which all rows from the table on the left will be included, regardless of whether they match rows from the table on the right
What is left outer join?
300
Operator that creates a temporary table containing every row that is in either the first table, the second table, or both tables
What is the UNION?
300
A table in system catalog that contains information about views that have been created
What is SYSVIEWS?
300
he table containing the foreign key
What is a child?
300
A file that relates key values to records that contain those key values; the main mechanism for increasing the efficiency with which data is retrieved from the database
What is an index?
400
A join in which all rows from one table in a join is listed, regardless of whether they match any rows in the other table
What is an outer join?
400
Operator that checks for the existence of rows that satisfy some criterion
What is EXISTS?
400
The SQL command used to define a view
What is CREATE VIEW?
400
The clause of the ALTER TABLE command used to add a primary key after creating a table
What is a ADD PRIMARY KEY?
400
An index that ensures the uniqueness of values in a non-primary key column
What is a unique index?
500
A join in which all rows from the table on the right will be included, regardless of whether they match rows from the table on the left
What is right outer join?
500
Operator that creates a temporary table containing all rows that are in both tables
What is INTERSECT?
500
A view that consists of a subset of the rows and columns in some base table
What is a row-and-column subset view?
500
A file that relates key values to records that contain those key values; the main mechanism for increasing the efficiency with which data is retrieved from the database