Online Access Free 1z1-149 Exam Questions

Which block of code displays the error message "Incorrect price value"?

• A.
• B.
• C.
• D.

Examine these statements:

Which two are true? (Choose two.)

• A.Only one table will have a row inserted and committed.
• B.The transaction for the bank_activity_proc is independent of the bank_transaction_proc.
• C.The bank_activity_proc will not compile because of the commit.
• D.Neither table will have a row inserted and committed.
• E.Both tables will have a row inserted and committed.

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

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

Which three are true about the procedure overloading feature? (Choose three.)

• A.Each procedure can be a standalone subprogram.
• B.Each procedure must use named notation to specify the corresponding actual parameters.
• C.Each procedure can be a nested subprogram.
• D.Each procedure must use positional notation to specify the corresponding actual parameters.
• E.Each procedure's formal parameters can differ in data type or name.
• F.Each procedure's formal parameters must differ in name.
• G.Each procedure can be a packaged subprogram.

Which two blocks of code display a numerical zero? (Choose two.)

• A.
• B.
• C.
• D.