QUESTION 29
Which two are true about collections and RECORD types? (Choose two.)

QUESTION 30
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 31
Sequence S and table PRODUCTS exist in your schema.
Examine the table description:

Now, examine this block of code:

Which two lines each result in a compilation error? (Choose two.)

QUESTION 32
Which is the correct method to implement a local subprogram in an anonymous block?

QUESTION 33
Examine this table in the SH schema:

Now, examine this code:

Which two changes are required to ensure that PDT_REPORT executes successfully? (Choose two.)

QUESTION 34
Examine this DECLARE section:

Which line will cause an error upon execution?

QUESTION 35
Examine these statements which execute successfully:

Which anonymous block executes successfully?

QUESTION 36
Which two are true about lexical units? (Choose two.)

QUESTION 37
Examine these statements and output:

The procedure is created successfully.

User ora2 has password ora2 in pdb1.
Which script will execute successfully?

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

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

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

QUESTION 41
For which three SYSTEM EVENTS can triggers be created? (Choose three.)

QUESTION 42
Which two are true about INDEX-BY tables? (Choose two.)

QUESTION 43
Which three statements are true about passing parameters to subprograms? (Choose three.)