最新の1Z0-147問題集で試験を準備する

Examine this code:
CREATE OR REPLACE PACKAGE bonus
IS
g_max_bonus NUMBER := .99;
FUNCTION calc_bonus (p_emp_id NUMBER)
RETURN NUMBER;
FUNCTION calc_salary (p_emp_id NUMBER)
RETURN NUMBER;
END;
/
CREATE OR REPLACE PACKAGE BODY bonus
IS v_salary employees.salary%TYPE; v_bonus employees.commission_pct%TYPE; FUNCTION calc_bonus (p_emp_id NUMBER) RETURN NUMBER IS BEGIN SELECT salary, commission_pct INTO v_salary, v_bonus FROM employees WHERE employee_id = p_emp_id; RETURN v_bonus * v_salary; END calc_bonus FUNCTION calc_salary (p_emp_id NUMBER) RETURN NUMBER IS BEGIN SELECT salary, commission_pct INTO v_salary, v_bonus FROM employees WHERE employees RETURN v_bonus * v_salary + v_salary; END cacl_salary; END bonus; / Which statement is true?

• A. You can call the BONUS.CALC_SALARY packaged function from an UPDATE command against the EMPLOYEES table.
• B. You can call the BONUS.CALC_SALARY packaged function from a SELECT command against the EMPLOYEES table.
• C. You can call the BONUS.CALC_SALARY packaged function from an INSERT command against the EMPLOYEES table.
• D. You can call the BONUS.CALC_SALARY packaged function form a DELETE command against the EMPLOYEES table.

Which statements are true? (Choose all that apply)

• A. If errors occur during the compilation of a trigger, the trigger is still created.
• 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 you can go into SQL *Plus and query the USER_TRIGGERS data dictionary view to see the compilation errors.
• D. 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.

You have the following table:
CREATE TABLE Emp_log ( Emp_id NUMBER Log_date DATE, New_salary NUMBER, Action VARCHAR(20));
You have the following data in the EMPLOYEES table:
EMPLOYEE_ID LAST_NAME SALARY DEPARTMENT_ID
100 King 24000 90 101 Kochhar 17000 90 102 De Haan 17000 90 103 Hunold 9000 60 104 Ernst 6000 60 105 Austin 4800 60 106 Pataballa 4800 60 107 Lorentz 4200 60 108 Greenberg 12000 100 201 Hartstein 13000 20 202 Fay 6000 20
You create this trigger:
CREATE OR REPLACE TRIGGER Log_salary_increase AFTER UPDATE ON employees FOR EACH ROW WHEN (:new.Salary > 1000) BEGIN INSERT INTO Emp_log (Emp_id, Log_date, New_Salary, Action) VALUES (new.Employee_id, SYSDATE, :new.SALary, 'NEW SAL'); END /
Then, you enter the following SQL statement:
UPDATE Employee SET Salary = Salary + 1000.0 Where Department_id = 20M
What are the result in the EMP_LOG table?
A EMP_ID LOG_DATE NEW_SALARY ACTION
201 24-SEP-02 13000 NEW SAL 202 24-SEP-02 600 NEW SAL

• A. EMP_ID LOG_DATE NEW_SALARY ACTION
  201 24-SEP-02 NEW SAL 202 24-SEP-02 NEW SAL
• B. No rows are inserted.
• C. EMP_ID LOG_DATE NEW_SALARY ACTION
  201 24-SEP-02 14000 NEW SAL 202 24-SEP-02 7000 NEW SAL

This statement fails when executed:
CREATE OR REPLACE TRIGGER CALC_TEAM_AVG
AFTER INSERT ON PLAYER
BEGIN
INSERT INTO PLAYER_BATSTAT (PLAYER_ID, SEASON_YEAR,AT_BATS,HITS)
VALUES (:NEW.ID, 1997, 0,0);
END;
To which type must you convert the trigger to correct the error?

• A. Before
• B. Row
• C. Statement
• D. ORACLE FORM trigger

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?

• A. The location table has one row.
  The departments and the employees tables are empty.
• B. The locations, departments, and employees tables are empty.
• C. The locations table and the departments table both have one row. The employees table is empty.
• D. The departments table has one row.
  The locations and the employees tables are empty.