QUESTION 23
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 24
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 25
Which two statements are true about the RETURNING clause when used with DML? (Choose two.)

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

QUESTION 27
User ORA41 executes these statements successfully:
Now, examine this statement which is executed successfully by user ORA61 after a successful login:
EXECUTE ora41.update_emp_proc(100,25000);
Which two are true? (Choose two.)

QUESTION 28
Examine the structure of the ora1.depts table:

Now, examine these statements issued by user ora1 which execute successfully:
Create or replace view dep_vu as select * from depts;
Alter table depts add dep_email varchar2(20);
Finally, examine this block of code executed by user ora1:

Which is true?

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

QUESTION 30
Examine this DECLARE section:

Which line will cause an error upon execution?

QUESTION 31
Examine these statements from a block of code:

Which two are true? (Choose two.)

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

QUESTION 33
Examine the SH.PRODUCTS table:

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?

QUESTION 34
Which three are true about functions and procedures? (Choose three.)

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

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

What is true about the result?

QUESTION 37
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.)