大数据就业实战培训 Oracle就业实战培训

CUUG,以就业为导向,让学员学到真正实用的技术

当前位置: CUUG培训-优技培训 >> 071考试 >

【071考试】最新OCP认证071考试题库整理-第44题

【071考试】最新OCP认证071考试题库整理-第44题

来源:CUUG培训-优技培训    更新时间:2019/6/3 14:12:31    阅读次数:

071考试题库之前是比较稳定的,但随着Oracle的调整,071考试不断的增加新的考题,增加了考试的难度,所以我们专门收集整理了这些考试,并对这些考题进行解析,希望可以对考生有帮助。

每周五晚8点,我们有免费的OCP解析公开课,地址:https://ke.qq.com/course/326223  OCP题库交流群:1015267481,验证ocp

-------------------------------------------------------

071考试-第44题、choose all that apply

View the Exhibit and examine the details of the ORDER_ITEMS table.

Evaluate the following SQL statements:

Statement 1:

SELECT MAX(unit_price*quantity) "Maximum Order"

FROM order_items;

Statement 2:

SELECT MAX(unit_price*quantity) "Maximum Order"

FROM order_items

GROUP BY order_id;

Which statements are true regarding the output of these SQL statements? (Choose all that apply.)

A) Both statements would ignore NULL values for the UNIT_PRICE and QUANTITY columns.

B) Statement 1 would return only one row of output.

C) Both the statements would give the same output.

D) Statement 2 would return multiple rows of output.

E) Statement 1 would not return any row because the GROUP BY clause is missing.

Anser:ABD

(解析:对于 null 值,Oracle 计算的时候结果为空,但是在求最大值的时候,会忽略)

SQL> select sal*comm from emp;

SAL*COMM

----------

480000

625000

1750000

SQL> select max(sal*comm) from emp;

MAX(SAL*COMM)

-------------

1750000

071考试
大数据课程
WDP
oracle机构
oracle认证
oracle课程
oracle视频
CUUG就业实战培训
CUUG与ORACLE公司建立最核心、最权威、最深层次的战略合作伙伴关系;
CUUG是唯一一家只做DBA就业培训和oracle认证的授权机构,28年培养数万名oracle技术人才;
CUUG金牌讲师授课,来自一线的资深ORACLE OCM技术专家团队;
CUUG顶尖完善的学习体系,以甲骨文原厂ORACLE数据库核心技术为教学课程;

报名入口 点击进入

课程咨询:400-0909-964

考试咨询:400-0909-964

企业QQ:800060152

E-mail:cuug_bj@cuug.com