Oracle 1Z0-144 問題集

質問 1：
You create a procedure to handle the processing of bank current accounts which rolls back payment transactions if the overdraft limit is exceeded.
The procedure should return an "error" condition to the caller in a manner consistent with other Oracle server errors.
Which construct should be used to handle this requirement?
A. The RAISE_APPLICATION_ERROR procedure
B. A user-defined exception used with a raise statement
C. The SQLERRM function
D. The PRAGMA EXCEPTION_INIT function
正解：D
解説: (Topexam メンバーにのみ表示されます)

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

The record for the employee with employee__id 100 in the employees table is as follows;

Identify the correct output for the code.
A. King current sysdate 24000
B. King 17-JUN-87 24000
C. King 17-JUN-87 1500
D. King current sysdate 1500
正解：C

質問 3：
Which two statements correctly differentiate functions and procedures? (Choose two.)
A. A function must return a value to the calling environment, whereas a procedure can return zero or more values to its calling environment.
B. A function can be called only as part of a SQL statement, whereas a procedure can be called only as a PL7SQL statement.
C. A function may return one or more values to the calling environment, whereas a procedure must return a single value to its calling environment.
D. A function can be called as part of a SQL statement or PL/SQL expression, whereas a procedure can be called only as a PL/SQL statement.
正解：A,D

質問 4：
Consider the following scenario:
Local procedure a calls remote procedure B
Procedure A was compiled at 8 AM.
Procedure A was modified and recompiled at 9 AM.
Remote procedure B was later modified and recompiled at 11 AM.
The dependency mode is set to timestamp.
Which statement correctly describes what happens when procedure A is invoked at 1 PM?
A. Procedure A is invalidated and recompiled immediately.
B. Procedure B is invalidated and recompiled again when invoked.
C. Procedure A is invalidated and recompiles when invoked the next time.
D. There is no effect on procedure A and it runs successfully.
正解：C

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

SERVEROUTPUT is on for the session.
Which statement is true about the execution of the code?
A. The execution fails because of the misplaced else clause.
B. The execution is successful even if there is no employee with EMPLOYEE_ID 115.
C. The execution falls and throws exceptions if no employee with EMPLOYEE_ID us is found.
D. The execution is successful, but it displays an incorrect output if no employee with EMPLOYEE_ID 115 is found.
正解：C

質問 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