C170 CH4 Glossary Review Questions with
100% Verified Correct Answers
base tables
the table on which a view is based
batch update routine
a routine that pools transactions into a single group to update a master table in a single
operation
correlated subquery
a subquery that executes once for each row in the outer query.
CREATE VIEW
a SQL command that creates a logical, 'virtual' table. the view can be treated as a real table
cross join
a join that performs a relational product (or Cartesian product) of two tables
updatable view
a view that can update attributes in base tables that are used in the view
view
a virtual table based on a SELECT query that is saved as an object in the database
What is a CROSS JOIN?
A _________ is identical to the PRODUCT relational operator. The _________ is also
known as the Cartesian product of two tables. For example, if you have two tables, AGENT,
with 10 rows and CUSTOMER, with 21 rows, the _________ resulting set will have 210
, rows and will include all of the columns from both tables. Syntax examples are:
SELECT * FROM CUSTOMER _________ AGENT;
or
SELECT * FROM CUSTOMER, AGENT
If you do not specify a join condition when joining tables, the result will be a _________ or
PRODUCT operation.
What three join types are included in the OUTER JOIN classification?
An _________ is a type of JOIN operation that yields all rows with matching values in the
join columns as well as all unmatched rows. (Unmatched rows are those without matching
values in the join columns). The SQL standard prescribes three different types of join
operations:LEFT [_________] JOIN, RIGHT [_________] JOIN, FULL [_________]
JOIN.The LEFT [_________] JOIN will yield all rows with matching values in the join
columns, plus all of the unmatched rows from the left table. (The left table is the first table
named in the FROM clause.)The RIGHT [_________] JOIN will yield all rows with
matching values in the join columns, plus all of the unmatched rows from the right table.
(The right table is the second table named in the FROM clause.)The FULL [_________]
JOIN will yield all rows with matching values in the join columns, plus all the unmatched
rows from both tables named in the FROM clause.
Syntax examples for outer joins:
SELECT * FROM T1 LEFT _____ JOIN T2 ON T1.C1 = T2.C1;
SELECT * FROM T1 RIGHT _____ JOIN T2 ON T1.C1 = T2.C1;
100% Verified Correct Answers
base tables
the table on which a view is based
batch update routine
a routine that pools transactions into a single group to update a master table in a single
operation
correlated subquery
a subquery that executes once for each row in the outer query.
CREATE VIEW
a SQL command that creates a logical, 'virtual' table. the view can be treated as a real table
cross join
a join that performs a relational product (or Cartesian product) of two tables
updatable view
a view that can update attributes in base tables that are used in the view
view
a virtual table based on a SELECT query that is saved as an object in the database
What is a CROSS JOIN?
A _________ is identical to the PRODUCT relational operator. The _________ is also
known as the Cartesian product of two tables. For example, if you have two tables, AGENT,
with 10 rows and CUSTOMER, with 21 rows, the _________ resulting set will have 210
, rows and will include all of the columns from both tables. Syntax examples are:
SELECT * FROM CUSTOMER _________ AGENT;
or
SELECT * FROM CUSTOMER, AGENT
If you do not specify a join condition when joining tables, the result will be a _________ or
PRODUCT operation.
What three join types are included in the OUTER JOIN classification?
An _________ is a type of JOIN operation that yields all rows with matching values in the
join columns as well as all unmatched rows. (Unmatched rows are those without matching
values in the join columns). The SQL standard prescribes three different types of join
operations:LEFT [_________] JOIN, RIGHT [_________] JOIN, FULL [_________]
JOIN.The LEFT [_________] JOIN will yield all rows with matching values in the join
columns, plus all of the unmatched rows from the left table. (The left table is the first table
named in the FROM clause.)The RIGHT [_________] JOIN will yield all rows with
matching values in the join columns, plus all of the unmatched rows from the right table.
(The right table is the second table named in the FROM clause.)The FULL [_________]
JOIN will yield all rows with matching values in the join columns, plus all the unmatched
rows from both tables named in the FROM clause.
Syntax examples for outer joins:
SELECT * FROM T1 LEFT _____ JOIN T2 ON T1.C1 = T2.C1;
SELECT * FROM T1 RIGHT _____ JOIN T2 ON T1.C1 = T2.C1;
