Q: 1
Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)
Options
Discussion
No comments yet. Be the first to comment.
Be respectful. No spam.
Which two lines are valid? (Choose two.)
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?
Which is true?
A row exists in SH.PRODUCTS with PDT_ID = 1.
Now, examine this code and output executed by SH:
Now, examine this block of code:
Which error message(s) does it display on execution by user SH?
Now, examine this block of code which executes successfully:
What is the value of v_commission?