WGU C170 Advanced SQL
In a subquery, the _____________ query is executed first. - Answer INNER
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. - Answer ALL
How many rows would be returned from a cross join of tables A and B, if A contains 8
rows and B contains 18? - Answer 144
In subquery terminology, the first query in the SQL statement is known as the _______
query. - Answer outer
"Union compatible" means that the ______________ attributes must be the same and
their data types must be alike. - Answer names of the relation attributes must be the
same and their data types must be alike
The _________ clause is used to restrict the output of a GROUP BY query by applying
a conditional criteria to the grouped rows. - Answer having
The Oracle ___________ function returns the current date. - Answer SYSDATE
The ANSI standard defines __________ type(s) of outer join(s) - Answer three
The Oracle string concatenation function is ____ - Answer II
The syntax of the DECODE function starts with ________________. - Answer
DECODE(e, x, y, d).
Assume you are using the UNION ALL operator to combine the results from two tables
with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table
contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne
and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2
table. How many records are returned when using the UNION ALL operator? - Answer
17
The ________________ data type is compatible with NUMBER. - Answer SMALLINT
The syntax for the UNION query is query UNION query. - Answer query UNION query
If the DBMS does not support the INTERSECT statement, one can use a(n) ___
subquery to achieve the same result. - Answer IN
In a subquery, the _____________ query is executed first. - Answer INNER
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. - Answer ALL
How many rows would be returned from a cross join of tables A and B, if A contains 8
rows and B contains 18? - Answer 144
In subquery terminology, the first query in the SQL statement is known as the _______
query. - Answer outer
"Union compatible" means that the ______________ attributes must be the same and
their data types must be alike. - Answer names of the relation attributes must be the
same and their data types must be alike
The _________ clause is used to restrict the output of a GROUP BY query by applying
a conditional criteria to the grouped rows. - Answer having
The Oracle ___________ function returns the current date. - Answer SYSDATE
The ANSI standard defines __________ type(s) of outer join(s) - Answer three
The Oracle string concatenation function is ____ - Answer II
The syntax of the DECODE function starts with ________________. - Answer
DECODE(e, x, y, d).
Assume you are using the UNION ALL operator to combine the results from two tables
with identical structure, CUSTOMER and CUSTOMER_2. The CUSTOMER table
contains 10 rows, while the CUSTOMER_2 table contains 7 rows. Customers Dunne
and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2
table. How many records are returned when using the UNION ALL operator? - Answer
17
The ________________ data type is compatible with NUMBER. - Answer SMALLINT
The syntax for the UNION query is query UNION query. - Answer query UNION query
If the DBMS does not support the INTERSECT statement, one can use a(n) ___
subquery to achieve the same result. - Answer IN
