Free Oracle 1Z1-144 Exam Dumps Questions & Answers

View Exhibit1 and examine the structure of the employees table.

User SCOTT needs to generate a text report that contains the names of all employees and their salaries.
Examine the following commands issued by the DBA: SQL_CREATE DICTORY my_dir AS '/temp/my_files* ; SQL_GRANT WRITE ON DIRECTORY my_dir TO SCOTT;
View Exhibit2 and examine the procedure code. You issue the following command: You issue the following command:

SQL_EXEC sal_5tatus ('MY_DIR', 'EMPREPORT.TXT')
What is the outcome?

• A.It gives an error because the "no data found" condition is not handled to come out of the loop.
• B.It executes successfully and creates the report.
• C.It executes but no data is written to the text file because the FFLUSH subprogram is not used to write all the data buffered in memory to a file.
• D.It gives an error because the text file should be opened in append mode.
• E.It gives an error because user SCOTT should be granted both read and write privileges to the directory alias.

Which two statements are correct about the usage of parameters in functions? (Choose two.)

• A.Functions called in SQL statements cannot have out or in out mode parameters.
• B.Functions having in, out, or in out parameters can be called only in named PL/SQL subprograms
• C.Functions having in, out, or in out parameters can be called In PL/SQL procedures and anonymous blocks.
• D.Functions can have only in mode parameters.

View Exhibit 1 and examine the structure of the EMP table.

View Exhlbit2 and examine the code of the packages that you have created.

You issue the following command:
SQL> DROP PACKAGE manage_emp;
What is the outcome?

• A.It drops the MANAGE_EMP package and invalidates only the body for the EMP_DET package.
• B.It drops both the MANAGE_EMP AND EMP__DET packages because of the cascading effect.
• C.It returns an error and does not drop the MAMAGE_EMP package because of the cascading effect.
• D.It drops the MANAGE_EMP package and invalidates both the specification and body for the EMP_DET package.

Which statements are true about PL/SQL procedures? (Choose all that apply.)

• A.Reuse of parsed PL/SQL code that becomes available in the shared SQL area of the server avoids the parsing overhead of SQL statements at run time.
• B.Users with definer's rights who are granted access to a procedure that updates a table must be granted access to the table itself.
• C.Depending on the number of calls, multiple copies of the procedure are loaded into memory for execution by multiple users to speed up performance.
• D.A PL/SQL procedure executing on the Oracle database can call an external procedure or function that is written in a different programming language, such as C or Java.

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