本套题库是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;
特别声明:以上内容(如有图片或视频亦包括在内)为自媒体平台“网易号”用户上传并发布,本平台仅提供信息存储服务。
Notice: The content above (including the pictures and videos if any) is uploaded and posted by a user of NetEase Hao, which is a social media platform and only provides information storage services.