Examine this code:
CREATE OR REPLACE PACKAGE metric_converter
IS
c_height CONSTRAINT NUMBER := 2.54;
c_weight CONSTRAINT NUMBER := .454;
FUNCTION calc_height (p_height_in_inches NUMBER)
RETURN NUMBER;
FUNCTION calc_weight (p_weight_in_pounds NUMBER)
RETURN NUMBER;
END;
/
CREATE OR REPLACE PACKAGE BODY metric_converter
IS
FUNCTION calc_height (p_height_in_inches NUMBER)
RETURN NUMBER
IS
BEGIN
RETURN p_height_in_inches * c_height;
END calc_height;
FUNCTION calc_weight (p_weight_in_pounds NUMBER)
RETURN NUMBER
IS
BEGIN
RETURN p_weight_in_pounds * c_weight
END calc_weight
END metric_converter;
/
CREATE OR REPLACE FUNCTION calc_height (p_height_in_inches NUMBER)
RETURN NUMBER
IS
BEGIN
RETURN p_height_in_inches * metric_converter.c_height;
END calc_height;
/
Which statement is true?

• A. The stand alone function CALC_HEIGHT cannot be created because its name is used in a packaged function.
• B. If you remove the package specification, then the package body and the stand alone stored function CALC_HEIGHT are removed.
• C. If you remove the stand alone stored function CALC_HEIGHT, then the METRIC_CONVERTER package body and the package specification are removed.
• D. If you remove the package specification, then the package body is removed.
• E. If you remove the package body, then the package specification and the stand alone stored function CALC_HEIGHT are removed.
• F. If you remove the package body, then the package specification is removed.

Examine this code:
CREATE OR REPLACE PROCEDURE set_bonus
(p_cutoff IN VARCHAR2 DEFAULT 'WEEKLY'
p_employee_id IN employees_employee_id%TYPE
p_salary IN employees_salary%TYPE,
p_bonus_percent IN OUT NUMBER DEFAULT 1.5,
p_margin OUT NUMBER DEFAULT 2,
p_bonus_value OUT NUMBER)
IS
BEGIN UPDATE emp_bonus SET bonus_amount =(p_salary * p_bonus_percent)/p_margin WHERE employee_id = p_employee_id; END set_bonus; /
You execute the CREATE PROCEDURE statement above and notice that it fails. What are two reasons why it fails? (Choose two)

• A. The formal parameter p_cutoff cannot have a DEFAULT clause.
• B. The format parameter p_bonus_value is declared but is not used anywhere.
• C. The syntax of the UPDATE statement is incorrect.
• D. You cannot update a table using a stored procedure.
• E. The declaration of the format parameter p_margin cannot have a DEFAULT clause.
• F. The declaration of the format parameter p_bonus_percent cannot have a DEFAULT clause.

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. Statement
• B. Before
• C. ORACLE FORM trigger
• D. Row

Examine the trigger heading:
CREATE OR REPLACE TRIGGER salary_check BEFORE UPDATE OF sal, job ON emp FOR EACH ROW
Under which condition does this trigger fire?

• A. When any column other than the SAL and JOB columns in a row are updated in the EMP table.
• B. Only when both values of the SAL and JOB columns in a row are updated together in the EMP table.
• C. When a row is inserted into the EMP table.
• D. When the value of the SAL or JOB column in a row is updated in the EMP table.