WGU C170 with a Focused on Advanced SQL
Exam Questions and verified Answers
2024/2025
............ is a relational set operator. - correct answer MINUS
The ............ statement can be used to combine rows from two queries, returning only
the rows that appear in both sets. - correct answer INTERSECT
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. - correct answer JOIN ON
The syntax of the MINUS statement in Oracle is ............. - correct answer query
MINUS query
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. - correct answer ALL
The ............ operator could be used in place of INTERSECT if the DBMS does not
support it. - correct answer IN
The syntax of the DECODE function is ............. - correct answer DECODE(expression,
search, result [, search, result]...[, default])
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 Duanne
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? - correct
answer 17
, A(n) ............ subquery is a subquery that executes once for each row in the outer query.
- correct answer correlated
Which of the following is a feature of a correlated subquery? - correct answer The
outer subquery initiates the process of execution in a subquery.
............ is a string function that returns the number of characters in a string value. -
correct answer LENGTH
Assume you are using the INTERSECT 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 Duanne
and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2
table. How many records are returned when using the INTERSECT operator? - correct
answer 2
When using the Oracle TO_NUMBER function to convert a character string into a
number, ............ represents a digit. - correct answer 9
In Oracle, the ............ function converts a date to a character string. - correct answer
TO_CHAR()
The ............ data type is compatible with NUMBER. - correct answer SMALLINT
When using the Oracle TO_DATE function, the code ............ represents a three-letter
month name. - correct answer MON
The Oracle ............ function compares an attribute or expression with a series of values
and returns an associated value or a default value if no match is found. - correct
answer DECODE
In a subquery, the ............ query is executed first. - correct answer inner
Exam Questions and verified Answers
2024/2025
............ is a relational set operator. - correct answer MINUS
The ............ statement can be used to combine rows from two queries, returning only
the rows that appear in both sets. - correct answer INTERSECT
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. - correct answer JOIN ON
The syntax of the MINUS statement in Oracle is ............. - correct answer query
MINUS query
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. - correct answer ALL
The ............ operator could be used in place of INTERSECT if the DBMS does not
support it. - correct answer IN
The syntax of the DECODE function is ............. - correct answer DECODE(expression,
search, result [, search, result]...[, default])
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 Duanne
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? - correct
answer 17
, A(n) ............ subquery is a subquery that executes once for each row in the outer query.
- correct answer correlated
Which of the following is a feature of a correlated subquery? - correct answer The
outer subquery initiates the process of execution in a subquery.
............ is a string function that returns the number of characters in a string value. -
correct answer LENGTH
Assume you are using the INTERSECT 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 Duanne
and Olowski are included in the CUSTOMER table as well as in the CUSTOMER_2
table. How many records are returned when using the INTERSECT operator? - correct
answer 2
When using the Oracle TO_NUMBER function to convert a character string into a
number, ............ represents a digit. - correct answer 9
In Oracle, the ............ function converts a date to a character string. - correct answer
TO_CHAR()
The ............ data type is compatible with NUMBER. - correct answer SMALLINT
When using the Oracle TO_DATE function, the code ............ represents a three-letter
month name. - correct answer MON
The Oracle ............ function compares an attribute or expression with a series of values
and returns an associated value or a default value if no match is found. - correct
answer DECODE
In a subquery, the ............ query is executed first. - correct answer inner
