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.)
A.
The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41.
B.
No update happens even though the procedure executes successfully.
C.
The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.
D.
The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.
E.
ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.
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
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
2708b98
1 month, 3 weeks ago2708b98
1 month, 3 weeks agoTLA_CJ
3 months, 1 week agoMcromeo
8 months, 1 week agoegznrd
1 year, 4 months agojfc1
1 year, 6 months agopmeyer
1 year, 7 months agoMcromeo
8 months, 1 week agoalinaabalasei
1 year, 8 months agoClick
1 year, 8 months ago