1. COMPUTE - command control computations on subsets created by the BREAK command.

2. Rollback - Rollback causes work in the current transaction to be undone.

3. BETWEEN ... AND

SELECT column_name FROM table_name WHERE column_name BETWEEN value1 AND value2 The values can be numbers, text, or dates.

4. What are the wildcards used for pattern matching.?

_ for single character substitution and % for multi-character substitution.

5. What is difference between CHAR and VARCHAR2? What is the maximum SIZE allowed for each type?

CHAR pads blank spaces to the maximum length.
VARCHAR2 does not pad blank spaces.
For CHAR the maximum length is 255 and 2000 for VARCHAR2.

6. Which line in the following statement will produce an error?

•  cursor action_cursor is
•  select name, rate, action
•  into action_record
•  from action_table;
•  There are no errors in this statement

7. A stored function must return a value based on conditions that are determined at runtime. Therefore, the SELECT statement cannot be hard-coded and must be created dynamically when the function is executed. Which Oracle supplied package will enable this feature?

•  DBMS_DDL
•  DBMS_DML
•  DBMS_SYN
•  DBMS_SQL

8. What will be the output of the following query?

SELECT REPLACE(TRANSLATE(LTRIM(RTRIM('!! ATHEN !!','!'), '!'), 'AN', '**'),'*','TROUBLE') FROM DUAL;?
TROUBLETHETROUBLE. p>

9. What's an SQL injection?

SQL Injection is when form data contains an SQL escape sequence and injects a new SQL query to be run.

10. What is the parameter substitution symbol used with INSERT INTO command?

Answer : &