Free Oracle 1Z1-144 Exam Dumps Questions & Answers

Which two statements correctly differentiate functions and procedures? (Choose two.)

• A.  A function may return one or more values to the calling environment, whereas a procedure must return a single value to its calling environment.
• B.  A function can be called only as part of a SQL statement, whereas a procedure can be called only as a PL7SQL statement.
• C.  A function must return a value to the calling environment, whereas a procedure can return zero or more values to its calling environment.
• D.  A function can be called as part of a SQL statement or PL/SQL expression, whereas a procedure can be called only as a PL/SQL statement.

ORDER_TOTAL is a column in the orders table with the data type and size as number (8, 2) Examine the following code:

Which statement is correct about the above code?

• A.  It gives an error in line 6
• B.  It executes successfully and displays the output.
• C.  It gives an error in line 3
• D.  It gives an error in line 4

Examine the following snippet of PL/SQL code:

View the exhibit for table description of EMPLOYEES table. The EMPLOYEES table has
200 rows.

Identify open statement for opening the cursor that fetches the result as consisting of employees with JOB_ID as 'ST_CLERK' and salary greater than 3000.

• A.  OPEN c1 (NULL, 3000);
• B.  OPEN c1 (EMP_job, emp_salary);
• C.  OPEN c1 (3000, emp_salary);
• D.  OPEN c1 ('ST_CLERK', 3000)
• E.  OPEN c1 (emp_job, 3000);

Which two statements are true about the exit statement encountered in loop? (Choose two)

• A.  The loop completes immediately and control passes to the statement after end loop
• B.  The PL/SQL block execution terminates immediately after the exit statement.
• C.  The statements after the exit statement in the Iteration are not executed before terminating the LOOP.
• D.  The current iteration of the loop completes immediately and control passes to the next iteration of the loop.

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