New Year Sale ! Hurry Up, Grab the Special Discount - Save 25% - Ends In 00:00:00 Coupon code: SAVE25

- Free Preparation Discussions

Oracle Exam 1Z0-071 Topic 15 Question 54 Discussion

Actual exam question for Oracle's 1Z0-071 exam

Question #: 54
Topic #: 15

Examine this partial statement:

SELECT ename, sal,comm FROM emp

Now examine this output:

WHICH ORDER BY clause will generate the displayed output?

AORDER BY NVL(enam,0) DESC, ename

BORDER BY NVL(comm,0) ASC NULLS FIRST, ename

CORDER BY NVL(comm,0) ASC NULLS LAST, ename

DORDER BY comm DESC NULLS LAST, ename

Show Suggested Answer

Suggested Answer: A, D

by Dalene at May 05, 2022, 09:11 PM

Limited Time Offer

25%

Off

Contribute your Thoughts:

Submit Cancel

Currently there are no comments in this discussion, be the first to comment!

Warning: Cannot modify header information - headers already sent by (output started at /pass.php:70) in /pass.php on line 77