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 constraints can be defined only at the column level?

Which of the following SQL statements defines a FOREIGN KEY constraint on the DEPT NO column of the EMP table?

Which of the following shows the correct use of the Trunc command on a date?

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

Which of the following statements is a complete transaction?

Which of the following constitute the attributes of /SQL*Plus?

Which of the following components are required to run iSQL*plus on PC?

An outer join is used when: