Oracle 1Z0-144 問題集

質問 1：
View Exhibit 1 and examine the structure of the EMP and dept tables.

View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete restrict referential actions on the primary key of the dept table.

What is the outcome on compilation?
A. It compiles successfully but gives an error on execution because it is not a row-level trigger.
B. It gives an error on compilation because the exception section Is used in the trigger.
C. It gives an error on compilation because it is not a row-level trigger.
D. It compiles and executes successfully.
正解：C

質問 2：
Which two statements are true about triggers? (Choose two.)
A. All the triggers that are created on a table cannot be disabled simultaneously.
B. Triggers become invalid if a dependent object, such as 3 stored subprogram that is invoked from the trigger body is modified, and have to be manually recompiled before the next invocation.
C. Oracle provides a two-phase commit process whether a trigger updates tables in the local database or remote tables in a distributed database.
D. Any user who has the alter privilege on a table can create a trigger using that table.
正解：B,C

質問 3：
Which statements correctly describe the features of functions and procedures? (Choose all that apply.)
A. A procedure can contain a return statement without a value.
B. A function can return multiple values using a single return clause,
C. A procedure can be executed as part of a SQL expression or as a PL/SQL statement,
D. A function can contain zero or more parameters that are transferred from the calling environment.
正解：A
解説: (Topexam メンバーにのみ表示されます)

質問 4：
View the Exhibit to examine the PL/SQL code.

Which statement is true about the execution of the code?
A. It does not execute because you cannot declare an exception with a similar name in the subblock.
B. 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
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 exception raised in the code is handled by the exception handler for the PAST_DUE exception.
正解：B

質問 5：
Which two statements are true about the exit statement encountered in loop? (Choose two)
A. The current iteration of the loop completes immediately and control passes to the next iteration of the loop.
B. The statements after the exit statement in the Iteration are not executed before terminating the LOOP.
C. The loop completes immediately and control passes to the statement after end loop
D. The PL/SQL block execution terminates immediately after the exit statement.
正解：A,C
解説: (Topexam メンバーにのみ表示されます)

質問 6：
Which two statements are true about the continue statement? (Choose two.)
A. The PL/SQL block execution terminates immediately.
B. The loop completes immediately and control passes to the statement after end loop.
C. The statements after the continue statement in the iteration are executed before terminating the LOOP.
D. The current iteration of the loop completes immediately and control passes to the next iteration of the loop
E. The CONTINUE statement cannot appear outside a loop.
正解：D,E