QUESTION 17
Which three are true about PL/SQL subprograms? (Choose three.)

QUESTION 18
The SH schema contains the PRODUCTS table with column PDT_NAME defined as VARCHAR2(10).
Which two blocks of code execute successfully when invoked by user SH? (Choose two.)

QUESTION 19
Which two are true about implicit data type conversion? (Choose two.)

QUESTION 20
Which three are true about user-defined functions? (Choose three.)

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

QUESTION 22
Which three PL/SQL-only data types can be used in queries and native dynamic SQL issued from PL/SQL in the server? (Choose three.)

QUESTION 23
Examine these statements from a block of code:

Which two are true? (Choose two.)

QUESTION 24
Examine this DECLARE section:

Which line will cause an error upon execution?

QUESTION 25
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?

QUESTION 26
Which three are true about anonymous blocks and subprograms? (Choose three.)

QUESTION 27
Examine this code:
ALTER SESSION SET plsql_warnings=’ENABLE:ALL’;
/
You compile this function:

What happens when the function is created with PLSQL_WARNINGS set to ‘ENABLE: ALL’?

QUESTION 28
Examine these statements:

Which two are true? (Choose two.)

QUESTION 29
Examine this statement which executes successfully:
SQL> SET SERVEROUTPUT ON;
Now, examine this code which is executed:

What is true about the result?

QUESTION 30
In which type of trigger can :OLD and :NEW identifiers be used?

QUESTION 31
Which two are true about named notations in a PL/SQL subprogram? (Choose two.)

QUESTION 32
Which three are true about DDL triggers? (Choose three.)

QUESTION 33
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?

QUESTION 34
Which three are true regarding code based access control (CBAC)? (Choose three.)

QUESTION 35
Which three are valid PL/SQL variable names? (Choose three.)