Evaluate the following SQL query; What would be the outcome?

The correct answer is C. 160. 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 TRUNC(column|expression, n) Truncates the column, expression, or value to…

Exadata Administration

Question

Options

A200
B16
C160
D150
E100

How the community answered

(41 responses)

A
2% (1)
B
12% (5)
C
78% (32)
D
2% (1)
E
5% (2)

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 TRUNC(column|expression, n) Truncates the column, expression, or value to n decimal places or, if n is omitted, n defaults to zero

Topics

#SQL query evaluation#arithmetic operations#NVL functions#subquery results

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice