Quiz 1z0-144

Quiz 1Z0-144, Oracle Database 11g, Program with PL/SQL

Identify open statement for opening the cursor that fetches the result as consisting of employees with JOB_ID as ‘ST_CLERK’ and salary greater than 3000.

What is the outcome?

Which two statements are true about the usage of the cursor for loops?

Which statement is true about the execution of the code if the query in the PL/SQL block returns no rows?

what happens when procedure A is invoked at 1 PM?

Which statement is true about the output of the PL/SQL block?

Which statement is correct about the above snippets of code?

Why would it generate an error at run tune?

Which two statements are true about PL/SQL exception propagation?

Which tasks must be performed during the installation of the UTL_MAIL package?