WGU C170 : Quiz 4 - Advanced SQL – Questions
with Verified Answers
_____ functions extract a value of a given data type and convert it to the
equivalent value in another data type. Ans✓✓✓-Conversion
_____ is a relational set operator. Ans✓✓✓-MINUS
_____ is a string function that returns the number of characters in a string value.
Ans✓✓✓-LENGTH
"Union compatible" means that the _____. Ans✓✓✓-names of the relation
attributes can be different, but the data types must be alike
A _____ is a query inside a query. Ans✓✓✓-subquery
A _____ join returns rows with matching values and includes all rows from both
tables (T1 and T2) with unmatched values. Ans✓✓✓-full outer
A(n) _____ join returns not only the rows matching the join condition (that is
rows, with matching values in the commun columns) but also the rows with
unmatched values. Ans✓✓✓-outer
A(n) _____ join will select only the rows with matching values in the common
attribute(s). Ans✓✓✓-natural
, A(n) _____ query can be used to produce a relation that retains the duplicate
rows. Ans✓✓✓-UNION ALL
A(n) _____ routine pools multiple transactions into a single batch to update a
master table field in a single operation. Ans✓✓✓-batch update
A(n) _____ subquery is a subquery that executes once for each row in the outer
query. Ans✓✓✓-correlated
A(n) _____ view is a view that can be used to update attributes in the base tables
that are used in the view. Ans✓✓✓-updatable
All join conditions are connected through a(n) _____ logical operator. Ans✓✓✓-
AND
An alternate syntax for a join is: SELECT column-list FROM table1 JOIN table2
_____ (common-column). Ans✓✓✓-USING
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? Ans✓✓✓-2
Assume you are using the MINUS 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 the
with Verified Answers
_____ functions extract a value of a given data type and convert it to the
equivalent value in another data type. Ans✓✓✓-Conversion
_____ is a relational set operator. Ans✓✓✓-MINUS
_____ is a string function that returns the number of characters in a string value.
Ans✓✓✓-LENGTH
"Union compatible" means that the _____. Ans✓✓✓-names of the relation
attributes can be different, but the data types must be alike
A _____ is a query inside a query. Ans✓✓✓-subquery
A _____ join returns rows with matching values and includes all rows from both
tables (T1 and T2) with unmatched values. Ans✓✓✓-full outer
A(n) _____ join returns not only the rows matching the join condition (that is
rows, with matching values in the commun columns) but also the rows with
unmatched values. Ans✓✓✓-outer
A(n) _____ join will select only the rows with matching values in the common
attribute(s). Ans✓✓✓-natural
, A(n) _____ query can be used to produce a relation that retains the duplicate
rows. Ans✓✓✓-UNION ALL
A(n) _____ routine pools multiple transactions into a single batch to update a
master table field in a single operation. Ans✓✓✓-batch update
A(n) _____ subquery is a subquery that executes once for each row in the outer
query. Ans✓✓✓-correlated
A(n) _____ view is a view that can be used to update attributes in the base tables
that are used in the view. Ans✓✓✓-updatable
All join conditions are connected through a(n) _____ logical operator. Ans✓✓✓-
AND
An alternate syntax for a join is: SELECT column-list FROM table1 JOIN table2
_____ (common-column). Ans✓✓✓-USING
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? Ans✓✓✓-2
Assume you are using the MINUS 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 the
