Advanced SQL, Chapter 9

A(n) ____ query can be used to produce a relation that retains duplicate rows.
1. UNION
2. UNION ALL
3. INTERSECT
4. MINUS
A ____ is a query inside a query.
1. subquery
2. basequery
3. join
4. set query
INSERT INTO PRODUCT SELECT * FROM P; is an example of a ____.
1. join
2. subquery
3. set operator
4. stored procedure
A(n) ____ is a block of code (containing standard SQL statements and procedural extensions) that is stored and executed at the DBMS server.
1. persistent stored module
2. permanent SQL module
3. SQL statement
4. program manipulation command
A(n) ____ join returns not only the rows matching the join condition but also the rows with unmatched values.
1. outer
2. inner
3. equi-
4. cross
A(n) ____ join will select only the rows with common values in the common column(s), excluding rows with unmatched values and duplicate columns.
1. natural
2. cross
3. full
4. outer
The ____ pseudo column is used to select the next available value from a sequence.
1. CURRVAL
2. NEXTVAL
3. NEXT
4. GET_NEXT
What type of inner join requires the use of a table qualifier?
1. USING
2. NATURAL
3. EQUI-
4. JOIN ON
In addition to a WHERE clause, a subquery can be used with a(n) ____ clause.
1. ON
2. HAVING
3. GROUP BY
4. MINUS
A subquery that executes once for each row in the outer query is a(n) ____ subquery.
1. nested
2. correlated
3. inline
4. grouped
The following SQL statement uses a(n) ____. SELECT P_CODE, P_DESCRIPT, P_PRICE, V_NAME FROM PRODUCT, VENDOR WHERE PRODUCT.V_CODE = VENDOR.V_CODE;
1. set operator
2. natural join
3. "old-style" join
4. procedural statement
What type of subquery could be used in place of INTERSECT if the RDBMS does not support it?
1. IN
2. OF
3. AND
4. UNION
The ____ function returns the current system date in MS Access/SQLServer.
1. TO_DATE()
2. SYSDATE()
3. DATE()
4. TODAY()
Complete the following inner join: SELECT * FROM T1 JOIN T2 ____ (C1)
1. OF
2. USING
3. HAS
4. JOIN ON
Which operator(s) is/are used with subqueries that use inequality operators on a list of values?
1. IN
2. ANY and ALL
3. ON
4. ONLY
The Oracle ____ function returns the current date.
1. DATE
2. SYSDATE
3. CURRENT_DATE
4. TO_DATE
What type of subquery could be used in place of MINUS if the RDBMS does not support it?
1. IN
2. NOT IN
3. AND
4. UNION
If you wish to create an inner join but the two tables do not have a commonly named attribute, you can use a(n) ____ clause.
1. OF
2. USING
3. HAS
4. JOIN ON
Assume you are using the UNION ALL statement to combine the results from two identical tables CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains seven rows. There are two customers included in both tables. How many records are returned when using the UNION ALL statement?
1. 7
2. 10
3. 15
4. 17
Assume you are using the UNION statement to combine the results from two identical tables CUSTOMER and CUSTOMER_2. The CUSTOMER table contains 10 rows, while the CUSTOMER_2 table contains seven rows. There are two customers included in both tables. How many records are returned when using the UNION statement?
1. 7
2. 10
3. 15
4. 17

Advanced SQL, Chapter 9

Quiz