Online Access Free 1Z0-149 Exam Questions

Which two are true about Conditional Compilation in PL/SQL using $IF, $ELSE, $END, and $ERROR? (Choose two.)

• A.It is newer syntax that works the same way as 'IF , ELSEIF , ELSE, and END IF'.
• B.PL/SQL code can be compiled and executed based on different versions of the operating system.
• C.PL/SQL code can be compiled and executed based on different versions of Oracle.
• D.Conditional compilation is disabled by default.
• E.The PL/SQL compiler can conditionally include selected parts of a program.

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

• A.
• B.
• C.
• D.

Which is true about EXIT and CONTINUE statements?

• A.They can be used in any type of loop.
• B.They must have a WHEN condition.
• C.They must use labels.
• D.They have the same effect on the execution of a loop.

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

• A.
• B.
• C.
• D.
• E.

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

• A.In line 1, change IN OUT mode to IN mode.
• B.In line 2, change IN OUT mode to IN mode.
• C.In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.
• D.In line 2, add the default parameter DEFAULT 2000.
• E.In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.
• F.In line 1, add the default parameter DEFAULT 2000.