Which of the following statements are correct with regard to WHERE and HAVING clauses?

Evaluate the following SQL statement: SELECT e.employee_id, (.15* e.salary) + (.5 * e.commission_pct) + (s.sales_amount * (.35 * e.bonus)) AS CALC_VALUE FROM employees e, sales s WHERE e.employee_id = s.emp_id; What will happen if all the parentheses are removed from the calculation?

Which of the following is an iSQL*Plus command?

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?

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;

Which of the following SQL statements accepts user input for the columns to be displayed, table name, and the WHERE condition?

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

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

Top N analysis requires _____ and _____.

What does the TRUNCATE statement do?