1z0-149 Exam - Question 15

Question

User ORA41 executes these statements successfully:

Now, examine this statement which is executed successfully by user ORA61 after a successful login:

EXECUTE ora41.update_emp_proc(100,25000);

Which two are true? (Choose two.)

Examice · Accepted Answer

The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41 because the procedure is defined with AUTHID CURRENT_USER, meaning it will execute with the privileges of ORA41 who owns the procedure and the EMPLOYEES table. The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure because ORA41 has granted execute rights on the procedure to ORA61, but no additional update privileges specifically for the table.

alinaabalasei · Answer

C and D are correct.

jfc1 · Answer

C and D are correct because of the invoker's right

egznrd · Answer

C is correct. Tested. Notice, that question says that statement was executed successfully by user ORA61 after a successful login. Procedure update_emp_proc was executed in the context of CURRENT_SCHEMA (ORA61) . That means, that ORA61.employees table was updated successfuly. Reference https://docs.oracle.com/en/database/oracle/oracle-database/19/lnpls/plsql-subprograms.html#GUID-41D23DE7-3C07-41CF-962B-F92B696594B5

pmeyer · Answer

I think is D and E.

Click · Answer

AD is correc

Mcromeo · Answer

CD are correct

1z0-149 Exam - Question 15

Discussion