Oracle9i program with pl/sql 認定 1Z0-147 試験問題:

1. What is a condition predicate in a DML trigger?

A) A conditional predicate means you use the NEW and OLD qualifiers in the trigger body as a condition.
B) A conditional predicate allows you to specify a WHEN-LOGGING-ON condition in the trigger body.
C) A conditional predicate allows you to combine several DBM triggering events into one in the trigger body.
D) A conditional predicate allows you to specify a SHUTDOWN or STARTUP condition in the trigger body.

2. Examine this package specification:
CREATE OR REPLACE PACKAGE concat_all
IS
v_string VARCHAR2(100);
PROCEDURE combine (p_num_val NUMBER);
PROCEDURE combine (p_date_val DATE);
PROCEDURE combine (p_char_val VARCHAR2, p_num_val NUMBER);
END concat_all; /
Which overloaded COMBINE procedure declaration can be added to this package specification?

A) PROCEDURE combine (p_val_1 VARCHAR2, p_val_2 NUMBER;
B) PROCEDURE combine;
C) PROCEDURE combine (p_no NUMBER);
D) PROCEDURE concat_all
(p_num_val VARCHAR2, p_char_val NUMBER);

3. To be callable from a SQL expression, a user-defined function must do what?

A) Be stored only in the database.
B) Have both IN and OUT parameters.
C) Use the positional notation for parameters.
D) Return a BOOLEAN or VARCHAR2 data type.

4. You create a DML trigger. For the timing information, which are valid with a DML trigger?

A) ON STATEMENT EXECUTION
B) BEFORE
C) ON SHUTDOWN
D) IN PLACE OF
E) DURING

5. You need to create a DML trigger. Which five pieces need to be identified? (Choose five)

A) Trigger name
B) System event
C) DML event
D) Package body
E) Trigger body
F) Table
G) Package name
H) Trigger timing

質問と回答：