PLSQL INTERVIEW QUESTIONS

7) what are the commands used to open a CURSOR FOR loop
are --
1. open

2. fetch
3. parse

4. None, cursor for loops handle cursor openingimplicitly.

8) What happens when rows are found using a FETCH statement
1. It causes the cursor to close 2. It causes the cursor to open 3. It loads the current row values into variables 4. It creates the variables to hold the currentrow values

9) Read the following code:
CREATE OR REPLACE PROCEDURE find_cpt (v_movie_id
{Argument Mode} NUMBER, _cost_per_ticket
{argument mode} NUMBER)
IS BEGIN IF v_cost_per_ticket > 8.5 THEN SELECT cost_per_ticket INTO v_cost_per_ticket FROM gross_receipt WHERE movie_id = v_movie_id; END IF; END;

Q) Which mode should be used for V_COST_PER_TICKET?
1. IN
2. OUT
3. RETURN 4. IN OUT

10) Read the following code:
CREATE OR REPLACE TRIGGER update_show_gross {trigger information} BEGIN {additional code} END; The trigger code should only execute when the column, COST_PER_TICKET, is greater than $3.
Which trigger information will you add?
1. WHEN (new.cost_per_ticket > 3.75)

2. WHEN (:new.cost_per_ticket > 3.75

3. WHERE (new.cost_per_ticket > 3.75)

4. WHERE (:new.cost_per_ticket > 3.75)

11) What is the maximum number of handlers processed before the PL/SQL block is exited when an exception occurs?
1. Only one
2. All that apply
3. All referenced

4. None

12) For which trigger timing can you reference the NEW and OLD qualifiers?
1. Statement and Row
2. Statement only

3. Row only

4. Oracle Forms trigger