WGU C170 - Quiz 4 Answers 100% PASSED
An inequality condition is also known as a natural join and an equality condition is also called a theta
join. - ✔✔False
When using a(n) _____ join, only rows that meet the given criteria are returned. - ✔✔inner
The statement SELECT * FROM T1, T2 produces a(n) _____ join. - ✔✔cross
A(n) _____ join will select only the rows with matching values in the common attribute(s). -
✔✔natural
If a designer wishes to create an inner join, but the two tables do not have a commonly named
attribute, he can use a(n) _____ clause. - ✔✔JOIN ON
The ANSI standard defines _____ type(s) of outer join(s). - ✔✔three
A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching
values in the common columns) but also the rows with unmatched values. - ✔✔outer
The syntax for a left outer join is _____. - ✔✔SELECT column-list
FROM table1 LEFT OUTER JOIN table2
ON join-condition
A _____ join returns rows with matching values and includes all rows from both tables (T1 and T2)
with unmatched values.
This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this
task are A to H and alt+1 to alt+9. - ✔✔full outer
All join conditions are connected through a(n) _____ logical operator. - ✔✔AND
, An alternate syntax for a join is: SELECT column-list FROM table1 JOIN table2 _____________
(common-column). - ✔✔USING
The _____________ determines the common attribute or attributes by looking for identically named
attributes and compatible data types. - ✔✔natural join
How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B
contains 18? - ✔✔144
A _____ is a query inside a query. - ✔✔subquery
In subquery terminology, the first query in the SQL statement is known as the _____ query. -
✔✔outer
Which of the following is a feature of a correlated subquery? - ✔✔The outer subquery initiates the
process of execution in a subquery.
In a subquery, the _____ query is executed first. - ✔✔inner
When using a subquery, the output of a(n) ________ query is used as the input for the outer query. -
✔✔inner
The __________ clause is used to restrict the output of a GROUP BY query by applying a conditional
criteria to the grouped rows. - ✔✔HAVING
The IN subquery uses a(n) _____________ operator. - ✔✔equality
The use of the ________ operator allows you to compare a single value with a list of values returned
by the first subquery (sqA) using a comparison operator other than EQUALS. - ✔✔ALL
A(n) ____________ subquery is a subquery that executes once for each row in the outer query. -
✔✔correlated
An inequality condition is also known as a natural join and an equality condition is also called a theta
join. - ✔✔False
When using a(n) _____ join, only rows that meet the given criteria are returned. - ✔✔inner
The statement SELECT * FROM T1, T2 produces a(n) _____ join. - ✔✔cross
A(n) _____ join will select only the rows with matching values in the common attribute(s). -
✔✔natural
If a designer wishes to create an inner join, but the two tables do not have a commonly named
attribute, he can use a(n) _____ clause. - ✔✔JOIN ON
The ANSI standard defines _____ type(s) of outer join(s). - ✔✔three
A(n) _____ join returns not only the rows matching the join condition (that is, rows with matching
values in the common columns) but also the rows with unmatched values. - ✔✔outer
The syntax for a left outer join is _____. - ✔✔SELECT column-list
FROM table1 LEFT OUTER JOIN table2
ON join-condition
A _____ join returns rows with matching values and includes all rows from both tables (T1 and T2)
with unmatched values.
This task contains the radio buttons and checkboxes for options. The shortcut keys to perform this
task are A to H and alt+1 to alt+9. - ✔✔full outer
All join conditions are connected through a(n) _____ logical operator. - ✔✔AND
, An alternate syntax for a join is: SELECT column-list FROM table1 JOIN table2 _____________
(common-column). - ✔✔USING
The _____________ determines the common attribute or attributes by looking for identically named
attributes and compatible data types. - ✔✔natural join
How many rows would be returned from a cross join of tables A and B, if A contains 8 rows and B
contains 18? - ✔✔144
A _____ is a query inside a query. - ✔✔subquery
In subquery terminology, the first query in the SQL statement is known as the _____ query. -
✔✔outer
Which of the following is a feature of a correlated subquery? - ✔✔The outer subquery initiates the
process of execution in a subquery.
In a subquery, the _____ query is executed first. - ✔✔inner
When using a subquery, the output of a(n) ________ query is used as the input for the outer query. -
✔✔inner
The __________ clause is used to restrict the output of a GROUP BY query by applying a conditional
criteria to the grouped rows. - ✔✔HAVING
The IN subquery uses a(n) _____________ operator. - ✔✔equality
The use of the ________ operator allows you to compare a single value with a list of values returned
by the first subquery (sqA) using a comparison operator other than EQUALS. - ✔✔ALL
A(n) ____________ subquery is a subquery that executes once for each row in the outer query. -
✔✔correlated
