Oracle Database 11g: Program with PL/SQL - 1Z0-144무료 덤프문제 풀어보기
View the Exhibit to examine the PL/SQL code.
Which statement is true about the execution of the code?
Which statement is true about the execution of the code?
정답: A
Which two tasks should be created as functions instead of as procedures? (Choose two.)
정답: A,C
설명: (Fast2test 회원만 볼 수 있음)
Examine the following package specification.
SQL>CREATE OR REPLACE PACKAGE emp_pkf IS PROCEDURE search_emp (empdet NUMBER); PROCEDURE search_emp (empdet DATE); PROCEDURE search_emp (empdet NUMBER); RETURN VERCHAR2 PROCEDURE search_emp (empdet NUMBER); RETURN DATE END emp_pkg / The package is compiled successfully
Why would it generate an error at run tune?
SQL>CREATE OR REPLACE PACKAGE emp_pkf IS PROCEDURE search_emp (empdet NUMBER); PROCEDURE search_emp (empdet DATE); PROCEDURE search_emp (empdet NUMBER); RETURN VERCHAR2 PROCEDURE search_emp (empdet NUMBER); RETURN DATE END emp_pkg / The package is compiled successfully
Why would it generate an error at run tune?
정답: A
View Exhibit 1 and examine the structure of the EMP and dept tables.
View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete restrict referential actions on the primary key of the dept table.
What is the outcome on compilation?
View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete restrict referential actions on the primary key of the dept table.
What is the outcome on compilation?
정답: A
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?
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
Examine the following PL/SQL code;
The execution of the code produces errors. Identify the error in the code.
The execution of the code produces errors. Identify the error in the code.
정답: A
You want to maintain an audit of the date and time when each user of the database logs off.
Examine the following code:
Which two clauses should be used to fill in the blanks and complete the above code?
(Choose two.)
Examine the following code:
Which two clauses should be used to fill in the blanks and complete the above code?
(Choose two.)
정답: A,B
Examine the following PL/SQL code:
The server output is on for the session. Which statement is true about the execution of the code?
The server output is on for the session. Which statement is true about the execution of the code?
정답: C