Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
Tested on Oracle live sql.
A is correct query for the output
B comm nulls are at the top - wrong
C Turmer, Allen, Ward, Martin at the bottom - wrong
D Only Turner at the bottom - wrong
NVL lets you replace null (returned as a blank) with a string in the results of a query. If expr1 is null, then NVL returns expr2. If expr1 is not null, then NVL returns expr1. Meaning that the output would be replaced by 0. The output still remains as null.
https://docs.oracle.com/en/database/oracle/oracle-database/19/sqlrf/NVL.html
upvoted 1 times
...
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
9ramone7
1 month, 1 week agoyaya32
4 months agoRamunele
8 months agosunilrajusb
8 months, 3 weeks agoMisi_Oracle
1 week, 6 days ago