Take Test: 2. Chapter 12 Quiz - Click Here Question 1 The > operator is referred
ID: 3578155 • Letter: T
Question
Take Test: 2. Chapter 12 Quiz - Click Here
Question 1
The > operator is referred to as a(n) ____ operator.
a.
multiple-row
b.
multiple-column
c.
none of the above
d.
single-row
0.1 points
Question 2
The ____ operator is used to determine whether a condition is present in a subquery.
a.
IN
b.
ALL
c.
EXISTS
d.
ANY
0.1 points
Question 3
Which comparison operator allows you to search for NULL values in a subquery?
a.
IS NULL
b.
=NULL
c.
NVLS
d.
NVL
0.1 points
Question 4
A complete query nested inside another query is called a(n) ____
a.
child view
b.
subquery
c.
all of the above
d.
inner view
0.1 points
Question 5
A subquery must include a(n) ____ clause.
a.
SELECT
b.
FROM
c.
WHERE
d.
both a and b
0.1 points
Question 6
Contents of the CUSTOMERS table
Based on the contents of the CUSTOMERS table, which SQL statement will display the customers residing in the same state as customer#1013?
a.
SELECT customer# FROM customers WHERE state =
(SELECT state FROM customers WHERE customer#=1013);
b.
SELECT customer# FROM customers WHERE customer# =
(SELECT state FROM customers WHERE state = 'NJ');
c.
SELECT customer# FROM customers WHERE customer# IN
(SELECT state FROM customers WHERE state = 'NJ');
d.
SELECT customer# FROM customers WHERE state EXISTS
(SELECT state FROM customers WHERE customer#=1013);
0.1 points
Question 7
Contents of the CUSTOMERS table
Based on the contents of the CUSTOMERS table, which of the following SQL statements will display the customer# of all customers who were referred by the same individual that referred customer# 1003?
a.
SELECT customer# FROM customers WHERE referred =
(SELECT referred FROM customers WHERE customer# = 1003);
b.
SELECT customer# FROM customers WHERE NVL(referred, 0) =
(SELECT NVL(referred,0) FROM customers WHERE customer# = 1003);
c.
SELECT customer# FROM customers WHERE NVL(referred,0) =
(SELECT referred FROM customers WHERE customer# = 1003);
d.
SELECT customer# FROM customers WHERE referred EXISTS
(SELECT referred FROM customers WHERE customer# = 1003);
0.1 points
Question 8
The <> operator is referred to as a(n) ____ operator.
a.
correlated
b.
single-row
c.
multiple-column
d.
multiple row
0.1 points
Question 9
The <= operator is referred to as a(n) ____ operator.
a.
multiple-row
b.
single-row
c.
uncorrelated
d.
correlated
0.1 points
Question 10
The outer query receives its input from the ____.
a.
subquery
b.
inner view
c.
nested function
d.
outer view
0.1 points
Question 11
Which of the following operators is used with a multiple-row subquery?
a.
ALL
b.
IN
c.
ANY
d.
all of the above
0.1 points
Question 12
Which operator will instruct Oracle12c to list all records with a value that is more than the highest value returned by the subquery?
a.
<all< span=""> </all<>
b.
>ALL
c.
>ANY
d.
<any< span=""></any<>
0.1 points
Question 13
With a MERGE statement, a series of ____ actions can occur with a single SQL statement.
a.
XML
b.
DML
c.
PML
d.
SGML
0.1 points
Question 14
Which clause is used when the group results of a subquery need to be restricted, based on some condition?
a.
HAVING
b.
GROUP BY
c.
ORDER BY
d.
WHERE
0.1 points
Question 15
Which of the following terms refers to a type of subquery that is processed, or executed, once for each row in the outer query?
a.
correlated subquery
b.
single-row subquery
c.
multiple-column subquery
d.
uncorrelated subquery
a.
multiple-row
b.
multiple-column
c.
none of the above
d.
single-row
Explanation / Answer
1. d. single row
2. c. exists
3. d. Nvl
4. b. subquery
5. c. both a and b
6. b. SELECT customer# FROM customers WHERE customer# =
(SELECT state FROM customers WHERE state = 'NJ');
7. b.
SELECT customer# FROM customers WHERE NVL(referred, 0) =
(SELECT NVL(referred,0) FROM customers WHERE customer# = 1003);
8. a. correlated
9. a. multiple row
10. b. inner view
11. d. All of the above
12. b. >All
13. b. DML
14. a. HAVING
15. b. single-row subquery
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.