C, D is correct
NULL values are considered in the sort operation; by default, they are treated as the lowest values in an ascending sort and as the highest values in a descending sort.
A – false; following queries are executed correctly:
SELECT * FROM employees ORDER BY 1;
SELECT emp_name, dept_id FROM employees ORDER BY emp_id;
B – false; no mention in Oracle documentation about numeric values order
C – false; Quoting Oracle documentation - options NULLS FIRST | NULLS LAST Specify whether returned rows containing null values should appear first or last in the ordering sequence. NULLS LAST is the default for ascending order, and NULLS FIRST is the default for descending order.
D – true; example: SELECT emp_name AS en, dept_id FROM employees ORDER BY en;
E – true; example:
SQL> SELECT emp_id,emp_name FROM employees WHERE UPPER(emp_name)='JONES' ORDER BY emp_name ASC;
EMP_ID EMP_NAME
---------- ----------
1 JONES
7 JONES
10 JOnes
9 Jones
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.
Rafafm
2 months, 3 weeks agoOracle2020
9 months agonautil2
1 year, 4 months agoauwia
1 year, 6 months agoDarkseid1231
1 year, 6 months agothanhnx1979
1 year, 7 months ago