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'?

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

Where is the GROUP BY clause statement placed in a SELECT statement that includes a WHERE clause?

Which of the following statements are correct with regard to NULL values?

Which of the following operations cannot be performed using the ALTER TABLE statement?

Which of the following is an iSQL*Plus command?

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 statements are correct with regard to WHERE and HAVING clauses?

What kinds of commands can you enter at the command prompt in 9i Sql Plus?

Which of the following statements is a complete transaction?