Online Access Free 1Z1-144 Practice Test

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

Which two statements are true about the %ROWTYPE attribute? (Choose two.)

• A.It is used to declare a record that can hold multiple rows of a table.
• B.It ensures that the data types of the variables that are declared with the %ROWTYPE attribute change dynamically when the underlying table is altered.
• C.The attributes of fields in the record take their names and data types from the columns of the table, view, cursor, or cursor variable.
• D.The attributes of fields in the record with the %ROWTYPE attribute can be modified manually.

In which of the following scenarios would you recommend using associative arrays?

• A.When you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries
• B.When you want to create a relatively small lookup table, where the collection can be constructed on memory each time a subprogram is invoked.
• C.When you want to retrieve an entire row from a table and perform calculations
• D.When you know the number of elements in advance and the elements are usually accessed sequentially

View the Exhibit and examine the structure of the employees table.

Examine the following block of code:

What is the outcome when the above code is executed?

• A.It executes successfully.
• B.It gives an error because the AVG function cannot be used in a PL/SQL block
• C.It gives an error because decode cannot be used in a PL/SQL block.
• D.It gives an error because both the AVG and decode functions cannot be used in a PL/SQL block.
• E.It gives an error because the MONTHS_BETWEEN function cannot be used in a PL/SQL block.

View the Exhibit and examine the code:

Which statement is true about the COMPILE_CODE procedure?

• A.It executes successfully, but a warning about the unreachable code is not displayed when used for the PROC1 procedure.
• 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 5.
• D.It gives an error in line 8.
• E.It gives an error in line 6.