Free Oracle 1z1-149 Exam Dumps Questions & Answers

Which is true about counter variables in a FOR loop?

• A.It cannot be NULL.
• B.It must explicitly be declared.
• C.It is accessible outside the body of the loop.
• D.It can be modified in the body of the loop.

Which two are true about exception handling? (Choose two.)

• A.Only predefined exceptions and user-defined exceptions can have a user-declared name associated with them.
• B.Predefined exceptions are globally declared in the standard package.
• C.All declared exceptions are raised implicitly by the runtime system.
• D.Internally defined exceptions can be handled only by the OTHERS exception handler.
• E.User-defined exceptions can be defined in the declarative part of any PL/SQL anonymous block, subprogram, or package.

Sequence S and table PRODUCTS exist in your schema.
Examine the table description:

Now, examine this block of code:

Which two lines each result in a compilation error? (Choose two.)

• A.line 8
• B.line 3
• C.line 1
• D.line 7
• E.line 6
• F.line 2

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

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

Which is true about EXIT and CONTINUE statements?

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