1. The Delete Statements :

DELETE FROM table_name WHERE column_name = some_value

Delete All Rows :

DELETE FROM table_name or DELETE * FROM table_name

2. What is the use of the DROP option in the ALTER TABLE command ?

It is used to drop constraints specified on the table.

3. What is difference between TRUNCATE & DELETE

TRUNCATE - commits after deleting entire table i.e., cannot be rolled back. Database triggers do not fire on TRUNCATE
DELETE      - allows the filtered deletion. Deleted records can be rolled back or committed. Database triggers fire on DELETE.

4. What is the usage of SAVEPOINTS?

SAVEPOINTS are used to subdivide a transaction into smaller parts. It enables rolling back part of a transaction. Maximum of five save points are allowed.

5. Procedure and Functions are explicitly executed. This is different from a database trigger. When is a database trigger executed?

•  When the transaction is committed
•  During the data manipulation statement
•  When an Oracle supplied package references the trigger
•  During a data manipulation statement and when the transaction is committed

6. What is the maximum number of handlers processed before the PL/SQL block is exited when an exception occurs?

•  Only one
•  All that apply
•  All referenced
•  None

7. Sort the Rows :

SELECT column1, column2, ... FROM table_name ORDER BY columnX, columnY, ..
SELECT column1, column2, ... FROM table_name ORDER BY columnX DESC
SELECT column1, column2, ... FROM table_name ORDER BY columnX DESC, columnY ASC

8. Multiple columns - Multiple columns can be returned from a Nested Subquery.

9. Posting - Posting is an event that writes Inserts, Updates & Deletes in the forms to the database but not committing these transactions to the database.

10. COLUMN - COLUMN command define column headings & format data values.