Online Access Free 1Z0-149 Practice Test

Which three are true about DDL triggers? (Choose three.)

• A.They cannot include the WHEN clause.
• B.They fire only when a DDL statement is executed by the owner of the trigger.
• C.They must be created in a disabled state.
• D.They can be fired either before or after a DDL statement executes.
• E.They can be fired when a privilege is granted to a user.
• F.They can be fired when a table is truncated.
• G.They must be created in an enabled state.

Which two are true about the PLSQL_CODE_TYPE parameter? (Choose two.)

• A.If set to NATIVE, programs are stored in a PL/SQL bytecode format.
• B.It can use the REUSE SETTINGS clause to recompile a program unit without changing to the current session settings.
• C.The default value is NATIVE.
• D.Changing the parameter setting automatically changes the setting for existing PL/SQL library units.
• E.If set to NATIVE, programs are stored in platform dependent machine code.

Examine these statements issued by user SH which execute successfully:

DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; /
Now, examine this anonymous block executed by SH:

Which is true about the anonymous block?

• A.It will fail at lines 6 and 7.
• B.It will fail only at line 7.
• C.It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.
• D.It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.

Which two are true about named notations in a PL/SQL subprogram? (Choose two.)

• A.Any optional parameters can be omitted in the invocation call.
• B.Only trailing optional parameters can be omitted in the invocation call.
• C.The actual parameters must be specified in the same order as the formal parameters are declared.
• D.Specifying actual parameters in the wrong order results in the subprogram terminating with an exception.
• E.The subprogram invocations must be changed when the formal parameter list acquires new required parameters.

Which is true about EXIT and CONTINUE statements?

• A.They must use labels.
• B.They must have a WHEN condition.
• C.They have the same effect on the execution of a loop.
• D.They can be used in any type of loop.