Get Unlimited Contributor Access to the all ExamTopics Exams!
Take advantage of PDF Files for 1000+ Exams along with community discussions and pass IT Certification Exams Easily.
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.
Mcromeo
1 week, 5 days agoegznrd
8 months, 1 week agojfc1
10 months, 2 weeks agopmeyer
12 months agoMcromeo
1 week, 5 days agoalinaabalasei
1 year agoClick
1 year, 1 month ago