C170 CH4 Glossary + Review
EXAM QUESTIONS AND
VERIFED CORRECT ANSWER
GRADED A+ LATEST 2026-
2027 100% GUARANTEED
PASS
base tables - CORRECT ANSWER-the table on which a view is based
batch update routine - CORRECT ANSWER-a routine that pools transactions into a single group
to update a master table in a single operation
correlated subquery - CORRECT ANSWER-a subquery that executes once for each row in the
outer query.
CREATE VIEW - CORRECT ANSWER-a SQL command that creates a logical, 'virtual' table. the
view can be treated as a real table
cross join - CORRECT ANSWER-a join that performs a relational product (or Cartesian product)
of two tables
,updatable view - CORRECT ANSWER-a view that can update attributes in base tables that are
used in the view
view - CORRECT ANSWER-a virtual table based on a SELECT query that is saved as an object in
the database
What is a CROSS JOIN? - CORRECT ANSWER-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? - CORRECT ANSWER-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: - CORRECT ANSWER-SELECT * FROM T1 LEFT _____ JOIN T2 ON
T1.C1 = T2.C1;
, SELECT * FROM T1 RIGHT _____ JOIN T2 ON T1.C1 = T2.C1;
SELECT * FROM T1 FULL _____ JOIN T2 ON T1.C1 = T2.C1;
What is a subquery, and what are its basic characteristics? - CORRECT ANSWER-A _______ is a
query (expressed as a SELECT statement) that is located inside another query. The first SQL
statement is known as the outer query, the second is known as the inner query or subquery.
The inner query or subquery is normally executed first. The output of the inner query is used as
the input for the outer query. A subquery is normally expressed inside parenthesis and can
return zero, one, or more rows and each row can have one or more columns.
What are the three types of results a subquery can return? - CORRECT ANSWER-1) a single
value (one row, one column),2) a list of values (many rows, one column), or3) a virtual table
(many rows, many columns).
What is a correlated subquery? - CORRECT ANSWER-A __________________ is subquery that
executes once for each row in the outer query. This process is similar to the typical nested loop
in a programming language. Contrast this type of subquery to the typical subquery that will
execute the innermost subquery first, and then the next outer query ... until the last outer query
is executed. That is, the typical subquery will execute in serial order, one after another, starting
with the innermost subquery. In contrast, a correlated subquery will run the outer query first,
and then it will run the inner subquery once for each row returned in the outer subquery.
Explain the difference between a regular subquery and a correlated subquery. - CORRECT
ANSWER-A regular, or uncorrelated subquery, executes before the outer query. It executes only
once and the result is held for use by the outer query. A correlated subquery relies in part on
the outer query, usually through a WHERE criteria in the subquery that references an attribute
in the outer query. Therefore, a correlated subquery will execute once for each row evaluated
by the outer query; and the correlated subquery can potentially produce a different result for
each row in the outer query.
EXAM QUESTIONS AND
VERIFED CORRECT ANSWER
GRADED A+ LATEST 2026-
2027 100% GUARANTEED
PASS
base tables - CORRECT ANSWER-the table on which a view is based
batch update routine - CORRECT ANSWER-a routine that pools transactions into a single group
to update a master table in a single operation
correlated subquery - CORRECT ANSWER-a subquery that executes once for each row in the
outer query.
CREATE VIEW - CORRECT ANSWER-a SQL command that creates a logical, 'virtual' table. the
view can be treated as a real table
cross join - CORRECT ANSWER-a join that performs a relational product (or Cartesian product)
of two tables
,updatable view - CORRECT ANSWER-a view that can update attributes in base tables that are
used in the view
view - CORRECT ANSWER-a virtual table based on a SELECT query that is saved as an object in
the database
What is a CROSS JOIN? - CORRECT ANSWER-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? - CORRECT ANSWER-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: - CORRECT ANSWER-SELECT * FROM T1 LEFT _____ JOIN T2 ON
T1.C1 = T2.C1;
, SELECT * FROM T1 RIGHT _____ JOIN T2 ON T1.C1 = T2.C1;
SELECT * FROM T1 FULL _____ JOIN T2 ON T1.C1 = T2.C1;
What is a subquery, and what are its basic characteristics? - CORRECT ANSWER-A _______ is a
query (expressed as a SELECT statement) that is located inside another query. The first SQL
statement is known as the outer query, the second is known as the inner query or subquery.
The inner query or subquery is normally executed first. The output of the inner query is used as
the input for the outer query. A subquery is normally expressed inside parenthesis and can
return zero, one, or more rows and each row can have one or more columns.
What are the three types of results a subquery can return? - CORRECT ANSWER-1) a single
value (one row, one column),2) a list of values (many rows, one column), or3) a virtual table
(many rows, many columns).
What is a correlated subquery? - CORRECT ANSWER-A __________________ is subquery that
executes once for each row in the outer query. This process is similar to the typical nested loop
in a programming language. Contrast this type of subquery to the typical subquery that will
execute the innermost subquery first, and then the next outer query ... until the last outer query
is executed. That is, the typical subquery will execute in serial order, one after another, starting
with the innermost subquery. In contrast, a correlated subquery will run the outer query first,
and then it will run the inner subquery once for each row returned in the outer subquery.
Explain the difference between a regular subquery and a correlated subquery. - CORRECT
ANSWER-A regular, or uncorrelated subquery, executes before the outer query. It executes only
once and the result is held for use by the outer query. A correlated subquery relies in part on
the outer query, usually through a WHERE criteria in the subquery that references an attribute
in the outer query. Therefore, a correlated subquery will execute once for each row evaluated
by the outer query; and the correlated subquery can potentially produce a different result for
each row in the outer query.
