【071题库】最新OCP-071考试题库解析-第4题
071考试是OCP考试科目的一种,由于071考题多变,我们专门收集整理了最新的考试题库,并对这些考题进行讲解,希望可以帮助广大考生。
每周五晚8点,我们有免费的OCP解析公开课,地址:https://ke.qq.com/course/326223 OCP题库交流群:1015267481,验证ocp
-------------------------------------------------------
071题库-第4题、choose the best answer
View the Exhibits and examine PRODUCTS and SALES tables.
You issue the following query to display product name and the number of times the
product has been sold:
SQL>SELECT p.prod_name, i.item_cnt
FROM (SELECT prod id, COUNT(*) item_cnt
FROM sales GROUP BY prod_id) i RIGHT OUTER JOIN products p
ON i.prod_id = p.prod_id;
What happens when the above statement is executed?
A) The statement executes successfully and produces the required output.
B) The statement produces an error because a subquery in the FROM clause and outer-joins cannot be used together.
C) The statement produces an error because ITEM_CNT cannot be displayed in the outer query.
D) The statement produces an error because the GROUP BY clause cannot be used in a subquery in the FROM clause.
Answer:A
(SQL> select d.dname,e.emp_cnt
from (select deptno,count(*) emp_cnt from emp group by deptno)e right outer join dept d
on e.deptno=d.deptno;
DNAME EMP_CNT
-------------- ----------
ACCOUNTING 2
RESEARCH 4
SALES 6
OPERATIONS
TRAIN)
-
标签错误:<!-- #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>
-->
- 我要参加技术沙龙