READ Free Dumps For Oracle- 1z0-061
| Question ID 21032 | Examine the data in the CUST_NAME column of the customers table.
You need to display customers' second names where the second name starts with "Mc" or "MC."
Which query gives the required output?
|
| Option A | Option A
|
| Option B | Option B
|
| Option C | Option C
|
| Option D | Option D
|
| Correct Answer | B |
Explanation
| Question ID 21033 | Evaluate the following query:
SQL> SELECT TRUNC(ROUND(156.00, -1), -1)
FROM DUAL;
What would be the outcome?
|
| Option A | 16
|
| Option B | 100
|
| Option C | 160
|
| Option D | 200
|
| Option E | 150
|
| Correct Answer | C |
Explanation 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