1z0-144 Exam Dumps - Oracle Database 11g: Program with PL/SQL

The trigger is fired, a message is displayed, and the update is successful

The trigger is fired and a message is displayed, but the update is rolled back.

The trigger is not fired because the when clause should be used to specify the condition, however, the update is successful.

The trigger is not fired because column names must be specified with the update event to identify which columns must be changed to cause the trigger to fire, however, the update is successful.

OPEN c1 (NULL, 3000);

OPEN c1 (emp_job, 3000);

OPEN c1 (3000, emp_salary);

OPEN c1 (‘ST_CLERK’, 3000)

OPEN c1 (EMP_job, emp_salary);

The exception reproduces Itself In successive enclosing blocks until a handler is found.

Exception- can propagate across the remote subprograms that are called through database links.

If you declare a local exception in a subblock and a global exception in the outer block, the local declaration overrides the global exception.

If you declare a local exception in a subblock and a global exception in the outer block, the global declaration overrides the local exception.

All the blocks execute successfully and the anonymous block displays

1

2

3

cant: 45

45

cnt: 45

All the blocks execute successfully and the anonymous block displays

1

2

3

cut: 0

45

cart: 1

The anonymous block gives an error because the function invocation in line 2 is not valid.

The procedure creation gives an error because the function invocation in line 1 is not valid.

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 gives an error because group functions cannot be used in anonymous blocks

It executes successfully and correctly gives the result of the sum of salaries in department 60.

It executes successfully and incorrectly gives the result of the sum of salaries in department 60.

It gives an error because the variable name and column name are the same in the where clause of the select statement.

All the exceptions in the code are trapped by the exception handler.

All the "no data found" errors in the code are trapped by the exception handler.

The PL/SQL program does not execute because an exception is not declared in the declare section.

An exception handler in the code traps the "no data found" error after executing the handler code and the program flow returns to the next line of code.