Oracle 1z0-149 Dumps

It is deprecated in Oracle 12c.

It can be used to obtain information about all identifiers when compiling a procedure.

It can be used to control execution of specific portions of the PL/SQL code conditionally.

It can be used to control a user's privileges on PL/SQL objects at run time.

Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available.

Users granted execute privilege on a procedure compiled with definer's rights require grants to access objects belonging to the definer that are referenced in the procedure.

Subprograms are cached by default and shared among users, thereby reducing memory requirements.

Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead.

A subprogram's session state is retained even if any of the session’s instantiated subprograms are invalidated and revalidated.

Host variables can be referenced inside any PL/SQL subprogram.

A PL/SQL procedure can invoke an external code block written in a different programming language.

They cannot include the WHEN clause.

They must be created in an enabled state.

They can be fired when a table is truncated.

They fire only when a DDL statement is executed by the owner of the trigger.

They can be fired either before or after a DDL statement executes.

They can be fired when a privilege is granted to a user.

They must be created in a disabled state.

Changing the parameter setting automatically changes the setting for existing PL/SQL library units.

The default value is NATIVE.

If set to NATIVE, programs are stored in platform dependent machine code.

It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.

If set to NATIVE, programs are stored in a PL/SQL bytecode format.

Neither table will have a row inserted and committed.

Both tables will have a row inserted and committed.

The transaction for the bank_activity_proc is independent of the bank_transaction_proc.

The bank_activity_proc will not compile because of the commit.

Only one table will have a row inserted and committed.

It must explicitly be declared.

It can be modified in the body of the loop.

It cannot be NULL.

It is accessible outside the body of the loop.

It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.

It will return an error at line 2.

It will return an error at line 3.

It will return an error at line 8.

It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.