1. What is the function of a ODBC Driver ?

The ODBC Driver allows the developer to talk to the back end database.

2. Give some examples of standard API's ?

• Open Database Connectivity (ODBC),
• Integrated Database Application Programming Interface (IDAPI),
• XOpen
• SQL/CLI

3. What is the most important requirement for OLTP ?

OLTP requires real time response.

4. Which of the following statements is true about implicit cursors?

• Implicit cursors are used for SQL statements that are not named.
• Developers should use implicit cursors with great care.
• Implicit cursors are used in cursor for loops to handle data processing.
• Implicit cursors are no longer a feature in Oracle.

5. What are the data types allowed in a table?

CHAR, VARCHAR2, NUMBER, DATE, RAW, LONG and LONG RAW.

6. What will be the output of the following query? SELECT DECODE(TRANSLATE('A','1234567890','1111111111'), '1','YES', 'NO' );?

NO

Explanation : The query checks whether a given string is a numerical digit.

7. The Update Statement:

UPDATE table_name SET column_name = new_value WHERE column_name = some_value

8. What is the function of a ODBC manager ?

The ODBC Manager manages all the data sources that exists in the system.

9. Date Functions

Date Functions are ADD_MONTHS, LAST_DAY, NEXT_DAY, MONTHS_BETWEEN & SYSDATE.

10. What is CYCLE / NO CYCLE in a Sequence?

CYCLE specifies that the sequence continue to generate values after reaching either maximum or minimum value. After pan-ascending sequence reaches its maximum value, it generates its minimum value. After a descending sequence reaches its minimum, it generates its maximum.

NO CYCLE specifies that the sequence cannot generate more values after reaching its maximum or minimum value.