Which two statements are true in the above scenario?

View the Exhibit and examine the structure of the departments table in SCOTT’s schema.


Examine the following block of code:
CREATE OR REPLACE PROCEDURE add_dept(
p_id NUMBER, p_name VARCHAR2) IS
BEGIN
INSERT INTO departments VALUES <p_id, p_name, NULL, NULL);
END;
/
The above procedure is created by user SCOTT. Another user JONES needs to use the procedure.
Which two statements are true in the above scenario? (Choose two.)
A. JONES executes the procedure with definer’s rights.
B. JONES executes the procedure with invoker’s rights.
C. SCOTT should grant only the execute privilege for the procedure to JONES.
D. SCOTT should grant both the BXKCOTE privilege for the procedure and insert privilege for the table to

Download Printable PDF. VALID exam to help you PASS.

One thought on “Which two statements are true in the above scenario?

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.