Exactprep 1z0-144 Questions

Oracle Database 11g: Program with PL/SQL Questions and Answers

Question 13

Identify the scenario in which you would use the current of clause for an update or delete statement to rows fetched from a cursor.

when you want to lock the rows fetched by the cursor

when you want to update or delete the result set without affecting the rows in the table

when you want the database not to wait if the requested rows are locked by another user

when you want to ensure that the current rows fetched by the cursor are updated or deleted

Question 14

In which of the following scenarios would you recommend using PL/SQL records?

when you want to retrieve an entire row from a table and perform calculations

when you know the number of elements in advance and the elements are usually accessed sequentially

when you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries

when you want to create a relatively small lookup table, where the collection can be constructed in memory each time a subprogram is invoked

Question 15

View the Exhibit to examine the PL/SQL code.

SERVEROUTPUT is on for the session.

Which statement is true about the execution of the code?

The execution fails because of the misplaced else clause.

The execution is successful even if there is no employee with EMPLOYEE_ID 115.

The execution falls and throws exceptions if no employee with EMPLOYEE_ID us is found.

The execution is successful, but it displays an incorrect output if no employee with EMPLOYEE_ID 115 is found.