All the packages can be recompiled by using an Oracle utility called:

A CALL statement inside the trigger body enables you to call:

An internal LOB is _____.

In Explicit lock, two database operations wait for each other to release a lock.

Examine the following function: CREATE OR REPLACE FUNCTION PLAYER_AVG (V_ID in PLAYER.PLAYER_ID%TYPE) RETURN NUMBER IS V_AVG NUMBER; BEGIN SELECT HITS INTO V_AVG FROM PLAYER WHERE PLAYER_ID = V_ID; RETURN (V_AVG); END; Which of the following statements will successfully invoke this function in SQL *Plus?

Which command is used to disable all the triggers on the EMPLOYEES table?

Which cursor attribute returns the number of rows fetched from the active set in the case of an explicit cursor?

SQL%ISOPEN always evaluates to false in case of:

The process of Breaking Sql sentence into words and then checking them for syntax and object privileges is called:

Consider the following code: declare v_id number(3):=50; V_message(30):='Product 10012'; begin declare v_id number(3):=40; V_message(30):='welcome to world'; v_locn:='Europe; begin v_id:=v_id+20; end; end; Determine the value of V_ID variable in the outer block.

Which table should be queried to determine when a procedure was last compiled?