複選題QUESTION 47 Which two program declarations are correct for a stored program unit? (Choose two) AC (A) CREATE OR REPLACE FUNCTION tax_amt (p_id NUMBER) RETURN NUMBER (B) CREATE OR REPLACE PROCEDURE tax_amt (p_id NUMBER) RETURN NUMBER (C) CREATE OR REPLACE PROCEDURE tax_amt (p_id NUMBER, p_amount OUT NUMBER) (D) CREATE OR REPLACE FUNCTION tax_amt (p_id NUMBER) RETURN NUMBER(10,2) (E) CREATE OR REPLACE PROCEDURE tax_amt (p_id NUMBER, p_amount OUT NUMBER(10, 2))

QUESTION 45 Examine this code: CREATE OR REPLACE PROCEDURE insert_dept (p_location_id NUMBER) IS v_dept_id NUMBER(4); BEGIN INSERT INTO departments VALUES (5, 'Education', 150, p_location_id); SELECT department_id INTO v_dept_id FROM employees WHERE employee_id=99999; END insert_dept; / CREATE OR REPLACE PROCEDURE insert_location ( p_location_id NUMBER, p_city VARCHAR2) IS BEGIN INSERT INTO locations(location_id, city) VALUES (p_location_id, p_city); insert_dept(p_location_id); END insert_location; / You just created the departments, the locations, and the employees table. You did not insert any rows. Next you created both procedures. You new invoke the insert_location procedure using the following command: EXECUTE insert_location (19, 'San Francisco') What is the result in thisEXECUTE command? and long (A) The locations, departments, and employees tables are empty. (B) The departments table has one row. The locations and the employees tables are empty. (C) The location table has one row. The departments and the employees tables are empty. (D) The locations table and the departments table both have one row. The employees table is empty.

其他試題