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

Oracle 1Z0-147 試験概要:

Oracle 1Z0-147 試験シラバストピック:

Oracle9i program with pl/sql 認定 1Z0-147 試験問題：

1. Which three are true statements about dependent objects? (Choose three)

A) Invalid objects cannot be described.
B) The Oracle server automatically records dependencies among objects.
C) You can view whether an object is valid or invalid in the USER_OBJECTS data dictionary view.
D) All schema objects have a status that is recorded in the data dictionary.
E) You can view whether an object is valid or invalid in the USER_STATUS data dictionary view.
F) An object with status of invalid cannot be a referenced object.

2. Which statement about triggers is true?

A) You use a database trigger to fire when an INSERT statement occurs.
B) You use INSTEAD OF trigger to fire when a SELECT statement occurs.
C) You use a system event trigger to fire when an UPDATE statement occurs.
D) You use an application trigger to fire when a DELETE statement occurs.

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

A) Overloading allows different subprograms with the same name, but different in either number, type or order of parameters.
B) Overloading allows different subprograms with the same number, type and order of parameters.
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 functions with the same name that differ only in their return types.

4. Which code can you use to ensure that the salary is not increased by more than 10% at a time nor is it ever decreased?

A) CREATE OR REPLACE TRIGGER check_sal
AFTER UPDATE OR sal ON emp
WHEN (new.sal < old.sal OR
-new.sal > old.sal * 1.1)
BEGIN
RAISE_APPLICATION_ERROR ( - 20508, 'Do not decrease
salary not increase by more than 10%');
END;
B) CREATE OR REPLACE TRIGGER check_sal
BEFORE UPDATE OF sal ON emp
WHEN (new.sal < old.sal OR
new.sal > old.sal * 1.1)
BEGIN
RAISE_APPLICATION_ERROR ( - 20508, 'Do not decrease
salary not increase by more than 10%');
END;
C) ALTER TABLE emp ADD
CONSTRAINT ck_sal CHECK (sal BETWEEN sal AND sal*1.1);
D) CREATE OR REPLACE TRIGGER check_sal
BEFORE UPDATE OF sal ON emp
FOR EACH ROW
WHEN (new.sal < old.sal OR
new.sal > old.sal * 1.1)
BEGIN
RAISE_APPLICATION_ERROR ( - 20508, 'Do not decrease
salary not increase by more than 10%');
END;

5. When using a packaged function in a query, what is true?

A) The packaged function can execute an INSERT, UPDATEM or DELETE statement against the table that is being queried if the pragma RESTRICT REFERENCE is used.
B) The packaged function can execute and INSERT, UPDATE, or DELETE statement against the table that is being queried if it is used in a subquery.
C) You can not use packaged functions in a query statement.
D) The COMMIT and ROLLBACK commands are allowed in the packaged function.
E) The packaged function cannot execute an INSERT, UPDATE, or DELETE statement against the table that is being queried.

質問と回答：