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

Question

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.)

Accepted Answer

A. JONES executes the procedure with definer's rights. C. SCOTT should grant only the execute privilege for the procedure to JONES.

Answer

B. JONES executes the procedure with invoker's rights.

Answer

D. SCOTT should grant both the BXKCOTE privilege for the procedure and insert privilege for the

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…

Question

Exhibit

Options

How the community answered

Community Discussion