Which two programming constructs can be grouped within a package?

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?

Database triggers are designed:

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.