Free Oracle 1Z1-144 Exam Dumps Questions & Answers

Examine the following partial declare section from a block of PL/SQL code

Which line(s) in the above code are NOT valid? (Choose all that apply.)

• A.line 2
• B.line 5
• C.line 3
• D.line 4

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?

• A.Because function cannot be overload
• B.Because function cannot differ only in return type.
• C.Because the search EMP (EMPDET NUMBER) procedure and the SEARCH_DEPT (EMPDET NUMBER) cannot have identical parameter names and data types
• D.Because all the functions and procedures In the package cannot have the same number of parameters with the same parameter name

View the Exhibit and examine the code:

Which statement is true about the COMPILE_CODE procedure?

• A.It gives an error in line 5.
• B.It executes successfully, but displays a warning about the unreachable code when used for the PROC1 procedure.
• C.It gives an error in line 6.
• D.It executes successfully, but a warning about the unreachable code is not displayed when used for the PROC1 procedure.
• E.It gives an error in line 8.

Examine the following DECLARE section of PL/SQL block:

Which line in the above declaration would generate an error?

• A.Line 5
• B.Line 4
• C.Line 2
• D.Line 6
• E.Line 3

Examine the following code that you plan to execute:

What correction should be performed in the above code?

• A.The PROC3 procedure header should be declared at the beginning of the package body.
• B.The variable x must be declared in the package body and removed from the specification,
• C.The PROC2 procedure code should be defined in the package body.
• D.The PROC3 procedure should be declared in the package specification.