1. The command used to open a CURSOR FOR loop is

•  open
•  fetch
•  parse
•  None, cursor for loops handle cursor opening implicitly

2. If unique key constraint on DATE column is created, will it validate the rows that are inserted with SYSDATE?

It won't, Because SYSDATE format contains time attached with it.

3. What command is used to get back the privileges offered by the GRANT command?

REVOKE

4. The INSERT INTO Statements :

INSERT INTO table_name VALUES (value1, value2,....)
INSERT INTO table_name (column1, column2,...) VALUES (value1, value2,....)

5. JOIN

JOIN is the form of SELECT command that combines info from two or more tables.

Types of Joins are Simple (Equi Join & Non-Equi join), Outer & Self join.

Equi Join        - returns rows from two or more tables joined together based upon a equality condition in the WHERE clause.
Non-Equi join - returns rows from two or more tables based upon a relationship other than the equality condition in the WHERE clause.
Outer Join     - combines two or more tables returning those rows from one table that have no direct match in the other table.
Self Join        - joins a table to itself as though it were two separate tables.

6. The CHECK_THEATER trigger of the THEATER table has been disabled. Which command can you issue to enable this trigger?

•  ALTER TRIGGER check_theater ENABLE;
•  ENABLE TRIGGER check_theater;
•  ALTER TABLE check_theater ENABLE check_theater;
•  ENABLE check_theater;

7. For which trigger timing can you reference the NEW and OLD qualifiers?

1. Statement and Row                  2. Statement only                       3. Row only                 4. Oracle Forms trigger

8. How many LONG columns are allowed in a table? Is it possible to use LONG columns in WHERE clause or ORDER BY?

Only one LONG column is allowed. It is not possible to use LONG column in WHERE or ORDER BY clause.

9. BREAK

BREAK command clarify reports by suppressing repeated values, skipping lines & allowing for controlled break points.

10. SQL*Plus

SQL*Plus is an application that recognizes & executes SQL commands & specialized SQL*Plus commands that can customize reports, provide help & edit facility & maintain system variables.