1Z0-147問題集、Oracle実際の試験問題

質問 1

Which three statements are true regarding database triggers? (Choose three)

A. A database trigger is a PL/SQL block, C, or Java procedure associated with a table, view, schema, or the database.

B. A database trigger needs to be executed explicitly whenever a particular event takes place.

C. A database trigger executes implicitly whenever a particular event takes place.

D. With a schema, triggers fire for each event for all users; with a database, triggers fire for each event for that specific user.

E. A database trigger fires whenever a data event (such as DML) or system event (such as logon, shutdown) occurs on a schema or database.

正解: A,C,E

解説: (PassTest メンバーにのみ表示されます)

質問 2

Why do you use an INSTEAD OF trigger?

A. To insert into an audit table when data is updated in a sensitive column.

B. To insert data into a view that normally does not accept inserts.

C. To modify data in which the DML statement has been issued against an inherently nonupdateable view.

D. To perform clean up actions when ending a user session.

正解: C

解説: (PassTest メンバーにのみ表示されます)

質問 3

Which two statements about the overloading feature of packages are true? (Choose two)

A. Overloading allows different subprograms with the same number, type and order of parameters.

B. Overloading allows different functions with the same name that differ only in their return types.

C. Overloading allows different subprograms with the same name and same number or type of parameters.

D. Only local or packaged subprograms can be overloaded.

E. Overloading allows different subprograms with the same name, but different in either number, type or order of parameters.

正解: D,E

解説: (PassTest メンバーにのみ表示されます)

質問 4

Examine this code:
CREATE OR REPLACE FUNCTION calc_sal(p_salary NUMBER)
RETURN NUMBER
IS
v_raise NUMBER(4,2) DEFAULT 1.08;
BEGIN
RETURN v_raise * p_salary;
END calc_sal;
/
Which statement accurately call the stored function CALC_SAL? (Choose two)

A. SELECT salary, calc_sal(salary)
FROM employees
WHERE department_id = 60;

B. DELETE FROM employees(calc_sal(salary))
WHERE calc_sal(salary) > 1000;

C. SELECT last_name, salary, calc_sal(salary)
FROM employees ORDER BY
calc_sal(salary);

D. INSERT calc_sal(salary) INTO employees
WHERE department_id = 60;

E. UPDATE employees (calc_sal(salary))
SET salary = salary * calc_sal(salary);

正解: A,C

解説: (PassTest メンバーにのみ表示されます)

質問 5

Which three are true regarding error propagation? (Choose three)

A. An exception raised inside an exception handler immediately propagates to the enclosing block.

B. An exception raised inside a declaration immediately propagates to the current block.

C. An exception cannot propagate across remote procedure calls.

D. The use of the RAISE; statement in an exception handler reraises the current exception.

正解: A,C,D

解説: (PassTest メンバーにのみ表示されます)

質問 6

You need to disable all triggers on the EMPLOYEES table.Which command accomplishes this?

A. ALTER employees DISABLE ALL TRIGGERS;

B. ALTER TABLE employees DISABLE ALL TRIGGERS;

C. None of these commands; you cannot disable multiple triggers on a table in one command.

D. ALTER TRIGGERS ON TABLE employees DISABLE;

正解: B

解説: (PassTest メンバーにのみ表示されます)

質問 7

Examine this procedure:
CREATE OR REPLACE PROCEDURE UPD_BAT_STAT (V_ID IN NUMBER DEFAULT 10, V_AB IN NUMBER DEFAULT 4) IS BEGIN UPDATE PLAYER_BAT_STAT SET AT_BATS = AT_BATS + V_AB WHERE PLAYER_ID = V_ID; COMMIT; END;
Which two statements will successfully invoke this procedure in SQL *Plus? (Choose two)

A. EXECUTE UPD_BAT_STAT(V_AB=>10, V_ID=>31);

B. RUN UPD_BAT_STAT;

C. UPD_BAT_STAT(V_AB=>10, V_ID=>31);

D. EXECUTE UPD_BAT_STAT(31, 'FOUR','TWO');

E. EXECUTE UPD_BAT_STAT;

正解: A,E

解説: (PassTest メンバーにのみ表示されます)

Oracle9i program with pl/sql - 1Z0-147 模擬練習