<< Prev Question Next Question >>

Question 8/21

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?

LEAVE A REPLY

Your email address will not be published. Required fields are marked *

Question List (21q)
Question 1: Which two are true about using the ACCESSIBLE BY clause? (Ch...
Question 2: Which three are true regarding code based access control (CB...
Question 3: Examine the structure of the ora1.depts table: (Exhibit) Now...
Question 4: Which two are true about INDEX-BY tables? (Choose two.)...
Question 5: Examine these statements: (Exhibit) Which is true?...
Question 6: Which two are true about exception handling? (Choose two.)...
Question 7: Which three are true about the procedure overloading feature...
Question 8: Examine these facts: Table EMP exists in schema USERA with c...
Question 9: Which statement is true about user-defined records?...
Question 10: Examine this table in the SH schema: (Exhibit) User SH execu...
Question 11: Which two are true about the PLSQL_CODE_TYPE parameter? (Cho...
Question 12: Examine this row of data from the EMPLOYEES table: (Exhibit)...
Question 13: Sequence S and table PRODUCTS exist in your schema. Examine ...
Question 14: Examine this anonymous block of code: (Exhibit) Which two st...
Question 15: Which is true about EXIT and CONTINUE statements?...
Question 16: Examine these statements from a block of code: (Exhibit) Whi...
Question 17: Examine these statements: (Exhibit) Which two are true? (Cho...
Question 18: Examine this table definition in the SH schema. (Exhibit) A ...
Question 19: Which three statements are true about passing parameters to ...
Question 20: Examine the EMPLOYEES table structure: (Exhibit) Now, examin...
Question 21: Which two statements are true about the RETURNING clause whe...