Examice

Exam 1z0-149 All QuestionsBrowse all questions from this exam

Go to Exam

Question 15

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

The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41.

No update happens even though the procedure executes successfully.

The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.

The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.

ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.

Correct Answer: A, D

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.

Discussion

jfc1Options: CD

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

alinaabalaseiOptions: CD

C and D are correct.

egznrdOptions: CD

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

pmeyerOptions: DE

I think is D and E.

Mcromeo

E is not correct. I tested it

McromeoOptions: CD

CD are correct

ClickOptions: AD

AD is correc