1) The DROP TABLE statement

2) What is the maximum length of a table name in Oracle?

3) Which SQL statement is used to add a column in the existing table?

4) The order of keywords in any oracle SQL statement

5) Which operator is used to compare the NULL values in SQL?

6) In PLSQL, Which of the following is used to declare a record?

7) Is it possible to delete a column in an Oracle table that contains data?

8) Which statement will select employees hired on Monday?

9) What are the two composite data types?

10) Which of the following events CANNOT cause a trigger to fire?

11) The AVG, SUM, VARIANCE, and STDDEV functions can be used with which of the following?

12) Which aggregate function can be used on a column of the DATE data type?

13) Group functions return a value for ______ and ______ null values in their computations.

14) Which group function would you use to display the lowest value in the SALES_AMOUNT column?

15) Which SELECT statement will calculate the number of rows in the PRODUCTS table?

16) You need to join all the rows in the EMPLOYEES table to all the rows in the EMP_REFERENCE table. Which type of join should you create?

17) Which of the following Statement will cancel the SAVEPOINTS?

18) What is the main purpose of SQL?

19) What is the syntax for selecting all columns from a table named "employees"?

20) How would you sum the values in a column of a table in SQL?