大数据就业实战培训 Oracle就业实战培训
OCP 071中文考试题库(cuug内部资料)第8题
本套题库是OCP考试中的071(中文版)试题，由CUUG整理，如有报考OCP认证意向，可以联系cuug咨询老师。
8、请选择最佳答案。
查看INVOICES表中的数据:
INVOICE_ID CURRENCY_CODE RAISED_DATE
--------------------- --------------------------- ---------------------
1 EUR 01-JAN-2019
2 USD 01-FEB-2019
3 JPY 01 -MAR-2019
查看CURRENCIES表中的数据:
CURRENCY_CODE
---------------------------
JPY
GPB
CAD
EUR
USD
哪个查询返回CURRENCIES中存在而INVOICES中不存在的货币?
A) SELECT * FROM currencies
WHERE NOT EXISTS (
SELECT NULL FROM invoices WHERE currency_code = currency_code
);
B) SELECT * FROM currencies
MINUS
SELECT * FROM invoices;
C) SELECT currency_code FROM currencies
MINUS
SELECT currency_code FROM invoices;
D) SELECT currency_code FROM currencies
INTERSECT
SELECT currency_code FROM invoices;
