Which two statements are true about the RETURNING clause when used with DML? (Choose two.)

• A. The RETURNING INTO clause returns column values for rows affected by DML statements.
• B. The RETURNING INTO clause can be used with DML that affects multiple rows, if the BULK COLLECT clause is used.
• C. The RETURNING clause can be used for remote or parallel deletes.
• D. When using the RETURNING INTO clause, the data returned can be only single column or expression.
• E. The RETURNING INTO clause and bulk binds may not be used together.

Examine this row of data from the EMPLOYEES table:

Now, examine this block of code which executes successfully:

What is the value of v_commission?

• A. 5000
• B. 10000
• C. 15000
• D. 2500

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. No update happens even though the procedure executes successfully.
• B. The UPDATE privilege on ORA41.EMPLOYEES is not inherited by ORA61 through the procedure.
• C. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA61.
• D. ORA61 will have been granted the UPDATE privilege explicitly on ORA41.EMPLOYEES before executing the statement.
• E. The salary will be changed for employee 100 in the EMPLOYEES table owned by ORA41.

Examine these facts:
Table EMP exists in schema USERA with columns SALARY and EMP_ID.
EMP_ID is the primary key with values ranging from 1 to 100.
USERA now executes these statements successfully:

USERA then grants execute privilege on procedure MYPROC to USERB.
USERB exists in the database identified by pdb1 but does not have select privilege on USERA.EMP.
USERB now executes these statements:
conn userB/userB@pdb1
execute userA.myproc;
Which is true?

• A. It results in an error because USERB doesn't have select privilege on USERA.EMP.
• B. It executes successfully.
• C. It results in an error because Authid Definer is missing from MYPROC.
• D. It results in an error because Authid Current_User is missing from MYPROC.