1Z0-147 試験問題を無料オンラインアクセス

試験コード:1Z0-147
試験名称:Oracle9i program with pl/sql
認定資格:Oracle
無料問題数:111
更新日:2026-11-15
評価
100%

問題 1

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?

問題 2

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?

問題 3

Which two statements about object dependencies are accurate? (Choose two.)

問題 4

Examine this code:
CREATE OR REPLACE PRODECURE add_dept (p_dept_name VARCHAR2 DEFAULT 'placeholder', p_location VARCHAR2 DEFAULT 'Boston')
IS BEGIN INSERT INTO departments VALUES (dept_id_seq.NEXTVAL, p_dept_name, p_location); END add_dept; /
Which three are valid calls to the add_dep procedure? (Choose three)

問題 5

You have a row level BEFORE UPDATE trigger on the EMP table. This trigger contains a SELECT statement on the EMP table to ensure that the new salary value falls within the minimum and maximum salary for a given job title.
What happens when you try to update a salary value in the EMP table?

コメントを追加

あなたのメールアドレスが公開されることはありません。個人情報に関する内容は隠されます *

insert code
画面にある文字を入力してください。