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

Examine this code:
CREATE OR REPLACE PROCEDURE add_dept
( p_name departments.department_name%TYPE DEFAULT 'unknown',
p_loc departments.location_id%TYPE DEFAULT 1700)
IS
BEGIN
INSERT INTO departments(department_id, department_name,
loclation_id)
VALUES(dept_seq.NEXTVAL,p_name, p_loc);
END add_dept;
/
You created the add_dept procedure above, and you now invoke the procedure in SQL *Plus.
Which four are valid invocations? (Choose four)

• A.EXECUTE add_dept(p_loc=>2500, p_name=>'Education')
• B.EXECUTE add_dept('2500', p_loc =>2500)
• C.EXECUTE add_dept(p_name=>'Education', 2500)
• D.EXECUTE add_dept(p_loc=>2500)
• E.EXECUTE add_dept('Education', 2500)

Examine this procedure:
CREATE OR REPLACE PROCEDURE DELETE_PLAYER (V_ID IN NUMBER) IS BEGIN
DELETE FROM PLAYER
WHERE ID = V_ID;
EXCEPTION
WHEN STATS_EXITS_EXCEPTION
THEN DBMS_OUTPUT.PUT_LINE
('Cannot delete this player, child records exist in PLAYER_BAT_STAT table');
END;
What prevents this procedure from being created successfully?

• A.The STATS_EXIST_EXCEPTION has not been declared as an exception.
• B.The STATS_EXIST_EXCEPTION has not been declared as a number.
• C.Only predefined exceptions are allowed in the EXCEPTION section.
• D.A comma has been left after the STATS_EXIST_EXCEPTION exception.

Which statement about triggers is true?

• A.You use INSTEAD OF trigger to fire when a SELECT statement occurs.
• B.You use an application trigger to fire when a DELETE statement occurs.
• C.You use a database trigger to fire when an INSERT statement occurs.
• D.You use a system event trigger to fire when an UPDATE statement occurs.

Which statements are true? (Choose all that apply)

• A.If errors occur during the compilation of a trigger you can go into SQL *Plus and query the USER_ERRORS data dictionary view to see compilation errors.
• B.If errors occur during the compilation of a trigger you can use the SHOW ERRORS command within iSQL *Plus to see the compilation errors.
• C.If errors occur during the compilation of a trigger, the trigger is still created.
• D.If errors occur during the compilation of a trigger you can go into SQL *Plus and query the USER_TRIGGERS data dictionary view to see the compilation errors.

Which two describe a stored procedure? (Choose two)

• A.The executable section of a stored procedure contains statements that assigns values, control execution, and return values to the calling environment.
• B.A stored procedure is a type of PL/SQL subprogram that performs an action.
• C.A stored procedure is a named PL/SQL block that can accept parameters.
• D.A stored procedure is typically written in SQL.
• E.A stored procedure has three parts: the specification, the body, and the exception handler part.