최신Oracle Database 11g: Program with PL/SQL - 1Z0-144무료샘플문제
문제1
You want to create a trigger that fires whenever rows are deleted from the customer table and that displays the number of rows remaining in the table.
Which two statements are correct about the trigger to be created for the above requirement? (Choose two.)
You want to create a trigger that fires whenever rows are deleted from the customer table and that displays the number of rows remaining in the table.
Which two statements are correct about the trigger to be created for the above requirement? (Choose two.)
정답: C,E
문제2
Which two statements are correct about the usage of parameters in functions? (Choose two.)
Which two statements are correct about the usage of parameters in functions? (Choose two.)
정답: B,D
문제3
User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA. HR is an existing schema in the database.
SCOTT creates the following trigger: CREATE OR REPLACE TRIGGER drop_trigger BEFORE DROP ON hr.SCHEMA
BEGIN
RAISE_APPLICATION_ERROR (-20000, 'Cannot drop object');
END:
SCOTT does not grant the execute privilege on this trigger to any other users.
For which user(s) would this trigger fire by default when they drop an object in the hr schema?
User SCOTT has been granted CREATE ANY TRIGGER AND ALTER ANY TABLE by the DBA. HR is an existing schema in the database.
SCOTT creates the following trigger: CREATE OR REPLACE TRIGGER drop_trigger BEFORE DROP ON hr.SCHEMA
BEGIN
RAISE_APPLICATION_ERROR (-20000, 'Cannot drop object');
END:
SCOTT does not grant the execute privilege on this trigger to any other users.
For which user(s) would this trigger fire by default when they drop an object in the hr schema?
정답: A
문제4
Examine the following PL/SQL code:
Which statement is true about the execution of the PL/SQL code?
Examine the following PL/SQL code:
Which statement is true about the execution of the PL/SQL code?
정답: D
설명: (ITDumpsKR 회원만 볼 수 있음)
문제5
Which two guidelines are recommended by Oracle to reduce invalidation of dependent objects? (Choose two.)
Which two guidelines are recommended by Oracle to reduce invalidation of dependent objects? (Choose two.)
정답: A,C
문제6
Examine the following code:
The above code generates an error on execution.
What must you do to ensure that the code executes successfully?
Examine the following code:
The above code generates an error on execution.
What must you do to ensure that the code executes successfully?
정답: A
문제7
View Exhibit1 and examine the structure of the EMP table.
View Exhibit2 and examine the PIVSQL block of code.
What is the outcome?
View Exhibit1 and examine the structure of the EMP table.
View Exhibit2 and examine the PIVSQL block of code.
What is the outcome?
정답: D
문제8
Examine the following PL/SQL code:
Which statement is true about the fetch statements in the PL/SQL code?
Examine the following PL/SQL code:
Which statement is true about the fetch statements in the PL/SQL code?
정답: D