SQL> select * from borrower; CUSTOMER_NAME LOAN_NUMBER --------------- ---------
ID: 3596564 • Letter: S
Question
SQL> select * from borrower;
CUSTOMER_NAME LOAN_NUMBER
--------------- ---------------
Adams L-16
Curry L-93
Hayes L-15
Jackson L-14
Jones L-17
McBride L-20
Smith L-11
Smith L-21
Smith L-23
Williams L-17
10 rows selected.
SQL> select * from depositor;
CUSTOMER_NAME ACCOUNT_NUMBER
--------------- ---------------
Hayes A-101
Hayes A-102
Johnson A-101
Johnson A-201
Johnson A-444
Jones A-217
Lindsay A-222
Majeris A-333
Smith A-215
Smith A-444
Turner A-305
11 rows selected.
Question:
What is the output of this SQL statement:
SELECT DISTINCT customer_name FROM borrower INTERSECT SELECT customer_name FROM depositor;
A. CUSTOMER_NAME
---------------
Jones
Hayes
Smith
Smith
Smith
B. None; The SQL statement produces error.
C. CUSTOMER_NAME
---------------
Jones
Hayes
Smith
D. CUSTOMER_NAME
---------------
Adams
Curry
Jackson
McBride
Williams
Explanation / Answer
Answer:
D. CUSTOMER_NAME
---------------
Adams
Curry
Jackson
McBride
Williams
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.