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
This section is not available anymore. Please use the main Exam Page.1z0-149 Exam Questions
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
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.
alinaabalasei
Highly Voted 1 year, 11 months agojfc1
Highly Voted 1 year, 9 months ago2708b98
Most Recent 5 months, 1 week ago2708b98
5 months, 1 week agoTLA_CJ
6 months, 3 weeks agoMcromeo
11 months, 3 weeks agoegznrd
1 year, 7 months agopmeyer
1 year, 11 months agoMcromeo
11 months, 3 weeks agoClick
2 years ago