QUESTION 25 You need to remove the database triggerBUSINESS_HOUR. Which command do you use to remove the trigger in the SQL *Plus environment? short
(A) DROP TRIGGER business_hour;
(B) DELETE TRIGGER business_hour;
(C) REMOVE TRIGGER business_hour;
(D) ALTER TRIGGER business_hour REMOVE;
(E) DELETE FROM USER_TRIGGERS WHERE TRIGGER_NAME = 'BUSINESS_HOUR';

QUESTION 21 Which type of argument passes a value from a procedure to the calling environment? (A) VARCHAR2 (B) BOOLEAN (C) OUT (D) IN

QUESTION 22 You create a DML trigger. For the timing information, which is valid with a DML trigger? (A) DURING (B) INSTEAD (C) ON SHUTDOWN (D) BEFORE (E) ON STATEMENT EXECUTION

QUESTION 23 You are about to change the arguments of the CALC_TEAM_AVG function. Which dictionary view can you query to determine the names of the procedures and functions that invoke the CALC_TEAM_AVG function? (A) USER_PROC_DEPENDS (B) USER_DEPENDENCIES (C) USER_REFERENCES (D) USER_SOURCE

QUESTION 24 A CALL statement inside the trigger body enables you to call ______. (A) A package. (B) A stored function. (C) A stored procedure. (D) Another database trigger.

QUESTION 26 How can you migrate from a LONG to a LOB data type for a column? S (A) Use the DBMS_MANAGE_LOB.MIGRATE procedure. (B) Use the UTL_MANAGE_LOB.MIGRATE procedure. (C) Use the DBMS_LOB.MIGRATE procedure. (D) Use the ALTER TABLE command. (E) You cannot migrate from a LONG to a LOB date type for a column.

複選題QUESTION 27 Examine this procedure: CREATE OR REPLACE PROCEDURE INSERT_TEAM (V_ID in NUMBER, V_CITY in VARCHAR2 DEFAULT 'AUSTIN', V_NAME in VARCHAR2) IS BEGIN INSERT INTO TEAM (id, city, name) VALUES (v_id, v_city, v_name); COMMIT; END Which two statements will successfully invoke this procedure in SQL *Plus? (Choose two) (A) EXECUTE INSERT_TEAM; (B) EXECUTE INSERT_TEAM(3, V_NAME=>'LONGHORNS', V_CITY=>'AUSTIN'); (C) EXECUTE INSERT_TEAM(3, 'AUSTIN','LONGHORNS'); (D) EXECUTE INSERT_TEAM (V_ID := V_NAME := 'LONGHORNS', V_CITY := 'AUSTIN'); (E) EXECUTE INSERT_TEAM (3, 'LONGHORNS');

QUESTION 28 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.

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

複選題QUESTION 30 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) (B) EXECUTE add_dept('Education', 2500) (C) EXECUTE add_dept('2500', p_loc =>2500) (D) EXECUTE add_dept(p_name=>'Education', 2500) (E) EXECUTE add_dept(p_loc=>2500, p_name=>'Education')

複選題QUESTION 31 Which three are valid ways to minimize dependency failure? (Choose three) not s~ (A) Querying with the SELECT * notification. (B) Declaring variables with the %TYPE attribute. (C) Specifying schema names when referencing objects. (D) Declaring records by using the %ROWTYPE attribute. (E) Specifying package.procedure notation while executing procedures.