Oracle 1z0-144

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.

It executes successfully.

It gives an error because the SAL variable isnot visible in the increase function.

It gives an error because the increase function cannot be called from the RAISE_SALARY procedure.

It gives an error because the increase function and the RAISE_SALARY procedure should be declared at the beginningof the declare section before all the other declarations.

line 5

line 8

line 2

line 7

Delete operations cannot be performed using the instead of triggers.

The instead or triggers must be created to add or modify datathrough any view.

The instead of triggers can be written only for views, and the before and after timing options are not valid.

The check option for views is not enforced when Insertions or updates to the view are performed by using the instead of triggers.

JONES executes the procedure with definer's rights.

JONES executes the procedure with invoker's rights.

SCOTT should grant only the execute privilege for the procedure to JONES.

SCOTT should grant both the BXKCOTE privilege for the procedure and insert privilege for the table to

The Import and Export utilitiesaccept wrapped files.

SQL' Plus cannot process the obfuscated source files.

Only the wrap utility can obfuscate multiple programs at a time.

Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a time.

The sourcecode is visible only through the DBA_SOURCE view and not through the USER_SOURCE or ALL_SOURCE View

It should be an after trigger.

It should be a before trigger.

It should be a row-level trigger.

It should be astatement-level trigger.

It can be a before or an after trigger.

It givesan error in line 3.

It gives an error in line 4.

It gives an error in line 6.

It executes successfully and displays the output.

All the blocks execute successfully and the anonymous block displays123cant: 4545cnt: 45.

All the blocks execute successfully and the anonymous block displays123cut: 045cart: 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.

A function can be called only as part of a SQL statement, whereas a procedure can be called only as a PL/SQL statement.

A function must return a value to the calling environment, whereas a procedure can return zero or more values to its calling environment.

A function can be called as part of a SQL statement or PL/SQL expression, whereas a procedure can be called only as a PL/SQL statement.

A function may return one or more valuesto the calling environment, whereas a procedure must return a single value to its calling environment.