1z0-144 Oracle Database 11g: Program with PL/SQL Questions and Answers

It gives an error because only the innermost block is labeled.

It gives an error because the same variable name cannot be used across all the nested blocks.

It executes successfully and displays the resultant values in the following sequence- 1000, 2800 50000, 2800.

It executes successfully and displays the resultant values in the following sequence: 1000, 2800, 50000, 1000.

It executes successfully but no error messages get recorded in the DEBUG_OUTPUT table

It executes successfully and any error messages get recorded in the DEBUG_OUTPUT table.

It gives an error because PRAGMA AUTONOMOUS_TRANSACTION can be used only in packaged procedures.

It gives an error because procedures containing PRAGMA AUTONOMOUS_TRANSACTION cannot be called from the exception section.

Only subprograms can be parameterized.

Only subprograms are persistent database objects.

Both anonymous blocks and subprograms can be parameterized.

Both anonymous blocks and subprograms are persistent database objects

Only subprograms can return values that persist after the execution of the subprogram.

Both anonymous blocks and subprograms can return values that persist In SQL*Plus variables after their execution.

MY_PROC2 is not recompiled.

MY_PROC1 is recompiled but remains unchanged.

MY_PROC2 is recompiled but remains unchanged.

MY_PROC1 is recompiled without the debugging code.

It executes successfully but the output statements show different values.

It executes successfully and both output statements show the same values.

It gives an error because the SQL%ROWCOUNT attribute cannot be used with BULK COLLECT.

It gives an error because the INSERT SELECT construct cannot be used with the FORALL

It should be an after trigger.

It should be a before trigger.

It should be a row-level trigger.

It should be a statement-level trigger.

It can be a before or an after trigger.

The PL/SQL block execution terminates immediately after the exit statement.

The loop completes immediately and control passes to the statement after end loop

The statements after the exit statement in the Iteration are not executed before terminating the LOOP.

The current iteration of the loop completes immediately and control passes to the next iteration of the loop.

Subprograms are by default executed with definer's rights.

The declare section is optional for both anonymous blocks and subprograms.

Both anonymous blocks and subprograms execute by default with invoker's rights.

The declare section is mandatory for anonymous blocks and optional for subprograms.

It compiles successfully and fires whenever the specified condition is met.

It compiles successfully but does not fire even when the condition is met

It gives an error on compilation because the new qualifier is prefixed with a colon.

It gives an error on compilation because the new qualifier can be used only in row-level triggers.

Only HR

SCOTT and HR

Only SCOTT

SCOTT, HR, and SYS

It compiles successfully.

It gives an error because the when condition is not valid.

It gives an error because when cannot be used for row-level triggers.

It gives an error because the statements under updating are not valid.

It gives an error because the new qualifier in the when clause requires a colon prefix.

It is used to declare a record that can hold multiple rows of a table.

The attributes of fields in the record with the %ROWTYPE attribute can be modified manually.

The attributes of fields in the record take their names and data types from the columns of the table, view, cursor, or cursor variable.

It ensures that the data types of the variables that are declared with the %ROWTYPE attribute change dynamically when the underlying table is altered.