1Z0-147無料問題集「Oracle9i program with pl/sql」

質問 1

You are about to change the arguments of the CALC_TEAM_AVG function.
Which dictionary view can you query to determine the names of the procedures and functions that
invoke the CALC_TEAM_AVG function?

（A）USER_REFERENCES

（B）USER_SOURCE

（C）USER_PROC_DEPENDS

（D）USER_DEPENDENCIES

正解：D 解答を投票する

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

質問 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, 'AUSTIN','LONGHORNS');

（B）EXECUTE INSERT_TEAM (V_ID := V_NAME := 'LONGHORNS', V_CITY := 'AUSTIN');

（C）EXECUTE INSERT_TEAM(3, V_NAME=>'LONGHORNS', V_CITY=>'AUSTIN');

（D）EXECUTE INSERT_TEAM;

（E）EXECUTE INSERT_TEAM (3, 'LONGHORNS');

正解：A、C 解答を投票する

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

質問 3

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）ALTER TRIGGER business_hour REMOVE;

（C）REMOVE TRIGGER business_hour;

（D）DELETE FROM USER_TRIGGERS
WHERE TRIGGER_NAME = 'BUSINESS_HOUR';

（E）DROP TRIGGER business_hour;

正解：E 解答を投票する

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

質問 4

You have an AFTER UPDATE row-level on the table EMP. The trigger queries the EMP table and inserts the updating user's information into the AUDIT_TABLE.
What happens when the user updates rows on the EMP table?

（A）The trigger fires successfully. The update on the EMP table occurs, and data is inserted into theAUDIT_TABLE table.

（B）A runtime error occurs. The update on the EMP table does not take place, but the insert into the AUDIT_TABLE occurs.

（C）A runtime error occurs. The effect of trigger body is rolled back, but the update on the EMP table takes place.

（D）A compile time error occurs.

（E）A runtime error occurs. The effect of trigger body and the triggering statement are rolled back.

正解：E 解答を投票する

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

質問 5

Which statement about triggers is true?

（A）You use INSTEAD OF trigger to fire when a SELECT statement occurs.

（B）You use a system event trigger to fire when an UPDATE statement occurs.

（C）You use a database trigger to fire when an INSERT statement occurs.

（D）You use an application trigger to fire when a DELETE statement occurs.

正解：A、C 解答を投票する

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

質問 6

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）All schema objects have a status that is recorded in the data dictionary.

（D）You can view whether an object is valid or invalid in the USER_OBJECTS data dictionary view.

（E）An object with status of invalid cannot be a referenced object.

（F）You can view whether an object is valid or invalid in the USER_STATUS data dictionary view.

正解：A、B、D 解答を投票する

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

1Z0-147 無料問題集「Oracle9i program with pl/sql」

弊社を連絡する

関連リンク

トップ試験