最新的高品質 1Z0-147 考試練習題庫

Oracle 1Z0-147 考試概覽:

Oracle 1Z0-147 考試大綱主題:

最新的 9i Internet Application Developer 1Z0-147 免費考試真題：

1. 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) The declaration of the format parameter p_margin cannot have a DEFAULT clause.
E) The declaration of the format parameter p_bonus_percent cannot have a DEFAULT clause.
F) You cannot update a table using a stored procedure.

2. 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 (3, 'LONGHORNS');
B) EXECUTE INSERT_TEAM;
C) EXECUTE INSERT_TEAM (V_ID := V_NAME := 'LONGHORNS', V_CITY := 'AUSTIN');
D) EXECUTE INSERT_TEAM(3, V_NAME=>'LONGHORNS', V_CITY=>'AUSTIN');
E) EXECUTE INSERT_TEAM(3, 'AUSTIN','LONGHORNS');

3. Why do you use an INSTEAD OF trigger?

A) To perform clean up actions when ending a user session.
B) To modify data in which the DML statement has been issued against an inherently nonupdateable view.
C) To insert into an audit table when data is updated in a sensitive column.
D) To insert data into a view that normally does not accept inserts.

4. When creating a function, in which section will you typically find the RETURN keyword?

A) HEADER only
B) DECLARATIVE
C) DECLARATIVE,EXECUTABLE and EXCEPTION HANDLING
D) EXECUTABLE and HEADER

5. You need to remove the database triggerBUSINESS_HOUR.Which command do you use to remove the trigger in the SQL *Plus environment?

A) DELETE TRIGGER business_hour;
B) DROP TRIGGER business_hour;
C) REMOVE TRIGGER business_hour;
D) DELETE FROM USER_TRIGGERS
WHERE TRIGGER_NAME = 'BUSINESS_HOUR';
E) ALTER TRIGGER business_hour REMOVE;

問題與答案：