OCP 071中文考试题库(cuug内部资料)第8题
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;
-
标签错误:<!-- #Label#
labelId=20160707140604
moduleId=1
classId=12231768634
orderby=2
fields=url,title,u_info
attribute=
datatypeId=22192428132
recordCount=3
pageSize=
<htmlTemplate><dt><img src="/images/index_26${index}.jpg" width="100" height="62" /><a href="$url" title="${title}">${title}</a><span>${api.left(u_info,60)}</span></dt></htmlTemplate>
-->
- 我要参加技术沙龙