examine the two sql statements given below select lastname salary hiredate..., Oracle SQL 9i, Databases

Test
- Model Test
Index

Question:Examine the two SQL statements given below:
SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC;
SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC;
What is true about them?

A The two statements produce identical results 
B The second statement returns a syntax error while first will be executed successfully 
C The second statement will return top 2 records having maximum salary, while first statement will return all records 
D There is no need to specify DESC because the results are sorted in descending order by default

/45

+ AnswerA

+ Report

Descriptive on Oracle SQL 9i Ebook

Total Preview: 12435

Question:Examine the two SQL statements given below: SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY salary DESC; SELECT last_name, salary, hire_date FROM EMPLOYEES ORDER BY 2 DESC; What is true about them?

A The two statements produce identical results

B The second statement returns a syntax error while first will be executed successfully

C The second statement will return top 2 records having maximum salary, while first statement will return all records

D There is no need to specify DESC because the results are sorted in descending order by default

A