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

View the Exhibit to examine the PL/SQL code.

Which statement is true about the execution of the code?

• A.The exception raised in the code is handled by the exception handler for the PAST_DUE exception.
• B.It does not execute because you cannot declare an exception with a similar name in the subblock.
• C.The PAST_DUE exception raised in the subblock causes the program to terminate abruptly because there is no exception handler in the subblock.
• D.The PAST_DUE exception raised by the enclosing block is not propagated to the outer block and it is handled by the WHEN OTHERS exception handler

Examine the following snippet of code from the DECLARE section of PL/SQL
DECLARE
Cust_name VERCHAR2 (20) NOT NULL : = 'Tom Jones':
Same_name cust_name%TYPE:
Which statement is correct about the above snippets of code?

• A.The SAME_NAME variable inherits only the data type and constraint from the CUST_NAME variable resulting in an error
• B.The SAME_NAME variable inherits only the data type from the CUST_NAME variable.
• C.The SAME_NAME variable inherits only the data type and default value from the CUST_NAME variable.
• D.The SAME_NAME variable inherits the data type, constraint, and default value from the CUST_NAME variable.

Examine the following DECLARE section of PL/SQL block:

Which line in the above declaration would generate an error?

• A.Line 6
• B.Line 2
• C.Line 4
• D.Line 5
• E.Line 3

Which two statements are true about the continue statement? (Choose two.)

• A.The loop completes immediately and control passes to the statement after end loop.
• B.The PL/SQL block execution terminates immediately.
• C.The current iteration of the loop completes immediately and control passes to the next iteration of the loop
• D.The CONTINUE statement cannot appear outside a loop.
• E.The statements after the continue statement in the iteration are executed before terminating the LOOP.

Examine the following partial code:

Which statement is correct about the unnamed block of code at the end of a package body?

• A.It generates an error because all the blocks of code in a package body must be named.
• B.It acts as a package initialization block that executes once, when the package is first invoked within the user session.
• C.It generates an error because V_TAXRATE is a public variable that is already initialized in the package specification.
• D.It acts as a package initialization block that executes each time a package subprogram is invoked within the user session and refreshes the initialized variable value.