OCP-1Z0-新051-61题版本-25

QUESTION NO: 25

Evaluate the following SQL query;

What would be the outcome?

A. 200

B. 16

C. 160

D. 150

E. 100

Answer: C

答案解析：

参考：78：http://blog.csdn.net/rlhua/article/details/12853385

sys@TESTDB>select trunc(round(156.00,-1),-1) from dual;

TRUNC(ROUND(156.00,-1),-1)

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

                       160

Explanation:

Function Purpose

ROUND(column|expression, n) Rounds the column, expression, or value to n decimal places or, if

n is omitted, no decimal places (If n is negative, numbers to the left of decimal point are rounded.)

TRUNC(column|expression, n) Truncates the column, expression, or value to n decimal places or,

if n is omitted, n defaults to zero