1Z1-144 試験問題を無料オンラインアクセス

Which system events can be used to create triggers that fire both at database and schema levels? (Choose all that apply)

• A.AFTER SERVERERROR
• B.BEFORE SHUTDOWN
• C.AFTER LOGON
• D.AFTER STARTUP

What is the correct definition of the persistent state of a packaged variable?

• A.It is a public variable in a package specification whose value is always consistent across all current active sessions.
• B.It is a private variable defined in a procedure or function within a package body whose
  value is consistent within a user session.
• C.It is a public variable in a package specification whose value is consistent within a user session.
• D.It is a private variable in a package body whose value is consistent across all current active sessions.

Which type of exceptions is qualified as no predefined Oracle server errors?

• A.an exception that the developer determines as abnormal, are in the declarative section and raised explicitly
• B.an exception that is raised automatically when the PL/SQL program violates a database rule or exceeds a system-dependent limit
• C.the exceptions that are raised implicitly by the Oracle server and can be caught by the exception handler
• D.the exceptions that are explicitly raised by the program and can be caught by the exception handler

You execute the following block of code:

Which statement is true about the outcome?

• A.It gives an error because the V_CUSTOMER variable have different types in the nested blocks
• B.It gives an error because the nested blocks are not labeled.
• C.Both output statements show exactly the same values.
• D.Both Output statements show different values.

Which statements are true about the WHEN OTHERS exception handler? (Choose all that apply)

• A.It can be the only exception handler for the code.
• B.It can be the first exception handler.
• C.It traps all the exceptions that are not already trapped.
• D.You can have multiple OTHERS clauses to trap all the multiple unhandled exceptions.