1. What is the main advantage of developing an application using an API ?

The application can be connected to any back end server that is supported by the API.

2. In a client server environment, what would be the major work that the client deals with ?

The client deals with the user interface part of the system.

3. Which of the following is not a feature of a cursor FOR loop?

•  Record type declaration.
•  Opening and parsing of SQL statements.
•  Fetches records from cursor.
•  Requires exit condition to be defined.

4. What is a join? Explain the different types of joins?

Join                - query, which retrieves related columns or rows from multiple tables.
Self Join         - Joining the table with itself.
Equi Join        - Joining two tables by equating two common columns.
Non-Equi Join - Joining two tables by equating two common columns.
Outer Join      - Joining two tables in such a way that query can also retrieve rows that do not have corresponding join value in the other table.

5. Which command executes the contents of a specified file?

START or @.

6. Operators used in SELECT statements

• = Equal
• <> or != Not equal
• > Greater than
• <>= Greater than or equal
• <= Less than or equal BETWEEN Between an inclusive range LIKE Search for a pattern

7. Set Transaction

             Set Transaction is to establish properties for the current transaction.

8. Consistency

              Assures users that the data they are changing or viewing is not changed until the are thro' with it.

9. Under which circumstance must you recompile the package body after recompiling the package specification?

• Altering the argument list of one of the package constructs
• Any change made to one of the package constructs
• Any SQL statement change made to one of the package constructs
• Removing a local variable from the DECLARE section of one of the package constructs

10. What is the sub-query?

Sub-query is a query whose return values are used in filtering conditions of the main query.