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

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

What does the TRUNCATE statement do?

Top N analysis requires _____ and _____.

Which data dictionary view holds information about the column in a view?

Which of the following SELECT statements should be used to extract the year from the system date to display it in the format '2001'?

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

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

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?

Examine the code given below: SELECT employee_id FROM employees WHERE commission_pct=.5 OR salary > 23000 Which of the following statement is correct with regard to this code?

Which of the following is an iSQL*Plus command?