Oracle Oracle Database 1Z0-144 Questions & Answers

• Question 31:

  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.

  Correct Answer: C

• Question 32:

  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.

  Correct Answer: B

• Question 33:

  Which two guidelines are recommended by Oracle to reduce invalidation of dependent objects? (Choose two.)

  A. Reference tables indirectly by using views.

  B. Reference tables directly and avoid using views.

  C. When adding new items to a package, add them to the end of the package.

  D. When adding new items to a package, add them to the beginning of the package.

  Correct Answer: AC

• Question 34:

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

  

  Examine the following code:

  

  What is the outcome?

  A. It is created successfully.

  B. It gives an error because the return clause condition is invalid.

  C. It gives an error because the usage of the host variables is invalid.

  D. It gives an error because the data type of the return clause is invalid.

  Correct Answer: C

• Question 35:

  Examine the following code: The above code generates an error on execution.

  

  What must you do to ensure that the code executes successfully?

  A. Use the TO_DATE function in line 2.

  B. Use the TO_DATE function in line 7.

  C. Use the TO_NUMBER function in line 6.

  D. Use both the TO_DATE function in line 2 and the TO_NUMBER function in line 6.

  Correct Answer: A

• Question 36:

  Which two statements are true about the PL/SQL initialization parameters? (Choose two.)

  A. To use native code compilation, PLSQL_OPTIMIZE_LEVEL should be set to a value less than or equal to l.

  B. The default value of 2 for PLSQL_OPTIMIZE_LEVEL allows the compiler to rearrange code for better performance.

  C. Setting PLSQL_CODE_TYPE to NATIVE provides the greatest performance gains only for computation-intensive procedural operations.

  D. Changing the value of the PLSQL_CODE_TYPE parameter affects all the PL/SQL library units that have already been compiled.

  Correct Answer: BC

• Question 37:

  Which two statements are true about anonymous blocks and named subprograms? (Choose two.)

  A. Subprograms are by default executed with definer's rights.

  B. The declare section is optional for both anonymous blocks and subprograms.

  C. Both anonymous blocks and subprograms execute by default with invoker's rights.

  D. The declare section is mandatory for anonymous blocks and optional for subprograms.

  Correct Answer: AB

• Question 38:

  View the Exhibit to examine the PL/SQL code.

  

  Which statement is true about the execution of the code?

  A. The exception raised in the code is handled by the exception handler for the PAST_DUE exception.

  B. It does not execute because you cannot declare an exception with a similar name in the subblock.

  C. The PAST_DUE exception raised in the subblock causes the program to terminate abruptly because there is no exception handler in the subblock.

  D. The PAST_DUE exception raised by the enclosing block is not propagated to the outer block and it is handled by the WHEN OTHERS exception handler

  Correct Answer: D

• Question 39:

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

  

  Which line(s) in the above code are NOT valid? (Choose two.)

  A. line 2

  B. line 3

  C. line 4

  D. line 5

  Correct Answer: BD

• Question 40:

  View Exhibit 1 and examine the structure of the EMP and DEPT tables.

  

  View Exhibit 2 and examine the trigger code that is defined on the DEPT table to enforce the UPDATE and DELETE RESTRICT referential actions on the primary key of the DEPT table.

  

  What is the outcome on compilation?

  A. It compiles and executes successfully.

  B. It gives an error on compilation because it is not a row-level trigger.

  C. It gives an error on compilation because the EXCEPTION section is used in the trigger.

  D. It compiles successfully but gives an error on execution because it is not a row-level trigger.

  Correct Answer: B