AllExam Dumps

DUMPS, FREE DUMPS, VCP5 DUMPS| VMWARE DUMPS, VCP DUMPS, VCP4 DUMPS, VCAP DUMPS, VCDX DUMPS, CISCO DUMPS, CCNA, CCNA DUMPS, CCNP DUMPS, CCIE DUMPS, ITIL, EXIN DUMPS,


READ Free Dumps For Oracle- 1z0-061





Question ID 2309

Evaluate the following query:
SQL> SELECT TRUNC(ROUND(156.00, -1), -1) FROM DUAL;
What would be the outcome?
 

Option A

A.    16
 

Option B

B.    100
 

Option C

C.    160
 

Option D

D.    200
 

Option E

E.    150
 

Correct Answer C
Explanation


Question ID 2310

You want to display 5 percent of the rows from the sales table for products with the lowest AMOUNT_SOLD and also want to include the rows that have the same AMOUNT_SOLD even if this causes the output to exceed 5 percent of the rows.
Which query will provide the required result?

Option A

A.    Option A
 

Option B

B.    Option B
 

Option C

C.    Option C

 

Option D

D.    Option D

Correct Answer D
Explanation

Send email to admin@getfreedumps for new dumps request!!!