本套题库是OCP考试中的071(中文版)试题,由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;
领取专属 10元无门槛券
私享最新 技术干货