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?

What will happen if you query the emp table shown below: selectempno,DISTINCTename,Salary from emp;

How many join conditions should be there to avoid a Cartesion Join for joining three tables?

Which operator will be evaluated first in the statement: select (2+3*4/2-8) from dual:

Which of the following SQL statements returns a numeric value?

Which of the following substitution variables should be used to reuse the variable value without prompting the user each time?

What does the TRUNCATE statement do?

Which of the following views should a user query to display the columns associated with the constraints on a table owned by the user?

Which of the following SELECT statements will get the result 'elloworld' from the string 'HelloWorld'?

Which of the following substitution variables should be used to reuse the variable value without prompting the user each time?

Which of the following SQL statements returns a numeric value?