Oracle Database 19c: Program with PL/SQL - 1z1-149 模擬練習
Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)
正解: B,E
Examine these statements:
Which is true?
Which is true?
正解: B
Examine this table in the SH schema:
User SH executes this code:
The program must terminate with a user-defined message and no rows displayed if more than one product's price is 1000.
With which option must "---placeholder" be replaced?
User SH executes this code:
The program must terminate with a user-defined message and no rows displayed if more than one product's price is 1000.
With which option must "---placeholder" be replaced?
正解: C
Examine this DECLARE section:
Which line will cause an error upon execution?
Which line will cause an error upon execution?
正解: C
Which three statements can process a dynamic multi-row query? (Choose three.)
正解: A,B,G
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?
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
Which is the correct method to implement a local subprogram in an anonymous block?
正解: A