PlSQl Interview Questions

1) Which of the following statements is true aboutimplicit cursors?

1. Implicit cursors are used for SQL statements thatare not named.

2. Developers should use implicit cursors with greatcare.

3. Implicit cursors are used in cursor for loops tohandle data processing.

4. Implicit cursors are no longer a feature in Oracle.

2) Which of the following is not a feature of a cursorFOR loop?

1. Record type declaration.

2. Opening and parsing of SQL statements.
3. Fetches records from cursor.

4. Requires exit condition to be defined.

3) A developer would like to use referential datatypedeclaration on a variable. The variable name isEMPLOYEE_LASTNAME, and the corresponding table
and column is EMPLOYEE,and LNAME, respectively.

How would the developer define this variable using referential datatypes?

1. Use employee.lname%type.
2. Use employee.lname%rowtype.
3. Look up datatype for EMPLOYEE column on LASTNAMEtable and use that.

4. Declare it to be type LONG.

4) Which three of the following are implicit cursorattributes?
1. %found
2. %too_many_rows3. %notfound
4. %rowcount5. %rowtype

5) If left out, which of the following would cause aninfinite loop to occur in a simple loop?
1. LOOP
2. END LOOP
3. IF-THEN
4. EXIT

6) Which line in the following statement will produce an error?
1. cursor action_cursor is
2. select name, rate, action
3. into action_record
4. from action_table;
5. There are no errors in this statement.