Examine the package given below:
CREATE OR REPLACE PACKAGE discounts IS
g_id NUMBER := 7829;
discount_rate NUMBER := 0.00;
PROCEDURE display_price (p_price NUMBER);
END discounts;
/

CREATE OR REPLACE PACKAGE BODY discounts IS
PROCEDURE display_price (p_price NUMBER) IS
BEGIN
DBMS_OUTPUT.PUT_LINE( .Discounted .||  TO_CHAR(p_price*NVL(discount_rate, 1)));
END display_price;
BEGIN
discount_rate :=0.10;
END discounts;
/
Which of the following statements is correct?

Examine the code given below: CREATE OR REPLACE PACKAGE comm_package IS g_comm NUMBER := 10; PROCEDURE reset_comm(g_comm IN NUMBER); END comm_package; User Jones executes the following code at 9:01am: EXECUTE comm_package.g_comm := 15 User Smith executes the following code at 9:05am: EXECUTE comm_paclage.g_comm := 20 Which of the following statements is correct?

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

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.

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

SQL%ISOPEN always evaluates to false in case of:

Which one is not a legal declaration?

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

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?

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

An internal LOB is _____.