Oracle 1Z0-144 Online Practice Questions and Exam Preparation

Oracle 1Z0-144 Online Questions & Answers

• Question 11:

  Examine the following block of code:

  

  Which line in the above code would result in errors upon execution?

  A. line 5
  B. line 8
  C. line 2
  D. line 7
  B. line 8

• Question 12:

  Examine the following PL/SQL code:

  

  The serveroutput is on for the session. Which statement is true about the execution of the code?

  A. It displays NULL if no employee with employee_id 123 exists.
  B. It produces the ORA-01403: no data found error if no employee with employee_id 123 exists.
  C. It displays an error because the SELECT * INTO clause cannot be used to populate the PL/SQL record type.
  D. The code executes successfully even if no employee with employee_id 123 exists and displays Record Not Found.
  B. It produces the ORA-01403: no data found error if no employee with employee_id 123 exists.

• Question 13:

  Which statements correctly describe the features of functions and procedures? (Choose two.)

  A. A procedure can contain a RETURN statement without a value.
  B. A function can return multiple values using a single RETURN clause.
  C. A procedure can be executed as part of a SQL expression or as a PL/SQL statement.
  D. A function can contain zero or more parameters that are transferred from the calling environment.
  A. A procedure can contain a RETURN statement without a value.
  D. A function can contain zero or more parameters that are transferred from the calling environment.

• Question 14:

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

  

  View Exhibit 2 and examine the PL/SQL block of code.

  

  What is the outcome?

  A. It gives an error because the return type is not valid.
  B. It gives an error because the record type is not defined within the function.
  C. It gives an error because the function call in DBMS_OUTPUT. PUT__LINE is not valid
  D. It executes successfully and displays the names and salaries of all employees who earn the highest salary.
  E. It executes successfully but does not display the names and salaries of all employees who earn the highest salary.
  E. It executes successfully but does not display the names and salaries of all employees who earn the highest salary.

• Question 15:

  Which statement is true about transactions in PL/SQL?

  A. A transaction can span multiple blocks.
  B. A block can contain only a single transaction.
  C. SERVERPOINTS cannot be created in a PL/SQL block.
  D. The END keyword signals the end of a PL/SQL block and automatically commits the transaction in the block.
  A. A transaction can span multiple blocks.

• Question 16:

  View the Exhibits and examine the structure of the EMPLOYEES, DEPARTMENTS AND EMP_BY_DEPT tables. EMPLOYEES

  

  DEPARTMENTS

  

  EMP_BY_DEPT

  

  Examine the following code:

  

  What is the outcome on execution of the above code?

  A. It executes successfully but the output statements show different values.
  B. It executes successfully and both output statements show the same values.
  C. It gives an error because the SQL%ROWCOUNT attribute cannot be used with BULK COLLECT.
  D. It gives an error because the INSERT SELECT construct cannot be used with the FORALL
  A. It executes successfully but the output statements show different values.

• Question 17:

  Examine the following code:

  

  What is the outcome?

  A. The procedure is created successfully and displays the values 20 and 30 when it is called.
  B. The procedure gives errors because the parameters should be in OUT mode.
  C. The procedure gives errors because the host variables cannot be referenced anywhere in the definition of a PL/SQL stored procedure.
  D. The procedure is created successfully, but does not display any values when it is called because the host variables cannot be displayed inside the procedure.
  C. The procedure gives errors because the host variables cannot be referenced anywhere in the definition of a PL/SQL stored procedure.

• Question 18:

  View the Exhibit to examine the PL/SQL code.

  

  Which statement is true about the exception handlers in the PL/SQL code?

  A. All the exceptions in the code are trapped by the exception handler.
  B. All the "no data found" errors in the code are trapped by the exception handler.
  C. The PL/SQL program does not execute because an exception is not declared in the DECLARE section.
  D. An exception handler in the code traps the "no data found" error after executing the handler code and the program flow returns to the next line of code.
  B. All the "no data found" errors in the code are trapped by the exception handler.

• Question 19:

  View Exhibit 1 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 DIRECTORY my_dir AS '/temp/my_files';

  SQL>GRANT WRITE ON DIRECTORY my_dir TO scott;

  View Exhibit 2 and examine the procedure code.

  

  You issue the following command:

  SQL>EXEC sal_status ('MY_DIR', `EMPREPORT.TXT')

  What is the outcome?

  A. It executes successfully and creates the report.
  B. It gives an error because the text file should be opened in append mode.
  C. It gives an error because the "no data found" condition is not handled to come out of the loop.
  D. It gives an error because user SCOTT should be granted both read and write privileges to the directory alias.
  E. 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.
  A. It executes successfully and creates the report.

• Question 20:

  Identify two features of obfuscation. (Choose two.)

  A. The Import and Export utilities accept wrapped files.
  B. SQL' Plus cannot process the obfuscated source files.
  C. Only the wrap utility can obfuscate multiple programs at a time.
  D. Both the DBMS_DDL package and the Wrap utility can obfuscate multiple programs at a time.
  E. The source code is visible only through the DBA_SOURCE view and not through the USER_SOURCE or ALL_SOURCE View
  A. The Import and Export utilities accept wrapped files.
  C. Only the wrap utility can obfuscate multiple programs at a time.