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 one is not a legal declaration?

A function CALTAX is given below: CREATE OR REPLACE FUNCTION caltax (sal NUMBER) RETURN NUMBER IS BEGIN RETURN (sal * 0.05); END CALTAX; Which of the following statements is correct in case you want to run this function from the SQL *Plus prompt?

You need to drop a table from within a stored procedure. How would you do this?

Examine the following code: CREATE OR REPLACE PROCEDURE add_dept ( p_name dept.dname%TYPE DEFAULT 'unknown', p_loc dept.locE%TYPE DEFAULT 1700) IS BEGIN INSERT INTO dept VALUES (dept_seq.NEXTVAL,p_name, p_loc); END add_dept; / You created the add_dept procedure above. Now you want to invoke the procedure in SQL *Plus. Which of the following are the valid invocations?

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

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?

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?

When the procedure or function is invoked, Oracle engine loads the compiled procedure or function in the memory area called:

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