当前位置： Oracle DBA培训网-优技培训 >> 071题库 >

【071题库】最新OCP-071考试题库解析-第44题

071考试是OCP考试科目的一种，由于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

推荐机构MORE+

技术沙龙MORE+

标签错误:

我要参加技术沙龙

Oracle公开课MORE+

Oracle技术MORE+