Oracle 1Z0-144 Online Practice Questions and Exam Preparation

Oracle 1Z0-144 Online Questions & Answers

• Question 61:

  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
  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

• Question 62:

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

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

• Question 63:

  Examine the following code:

  

  Which statement is true about the execution of the above code?

  A. It executes and displays null.
  B. It executes and the condition returns true.
  C. It executes and control goes to the else statement.
  D. It fails because no value is assigned to the v_myage variable.
  C. It executes and control goes to the else statement.

• Question 64:

  View the Exhibit to examine the PL/SQL code.

  

  SERVEROUTPUT is on for the session.

  Which statement is true about the execution of the code?

  A. The execution fails because of the misplaced else clause.
  B. The execution is successful even if there is no employee with EMPLOYEE_ID 115.
  C. The execution fails and throws exceptions if no employee with EMPLOYEE_ID 115 is found.
  D. The execution is successful, but it displays an incorrect output if no employee with EMPLOYEE_ID 115 is found.
  C. The execution fails and throws exceptions if no employee with EMPLOYEE_ID 115 is found.

• Question 65:

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

  

  You want to create two procedures using the overloading feature to search for employee details based on either the employee name or employee number.

  Which two rules should you apply to ensure that the overloading feature is used successfully? (Choose two.)

  A. The procedures can be either stand-alone or packaged.
  B. The procedures should be created only as packaged subprograms.
  C. The procedures should be created only as stand-alone subprograms.
  D. Each subprogram's formal parameters should differ in both name and data type.
  E. The formal parameters of each subprogram should differ in data type but can use the same names.
  B. The procedures should be created only as packaged subprograms.
  E. The formal parameters of each subprogram should differ in data type but can use the same names.

• Question 66:

  You want to maintain an audit of the date and time when each user of the database logs off. Examine the following code:

  

  Which two clauses should be used to fill in the blanks and complete the above code? (Choose two.)

  A. ON SCHEMA
  B. ON QRXABASE
  C. AFTER LOGOFF
  D. BEFORE LOGOFF
  B. ON QRXABASE
  D. BEFORE LOGOFF

• Question 67:

  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.
  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.

• Question 68:

  View the exhibit and examine the structure of the products table.

  

  Examine the following code:

  

  Which statement is true when the procedure DELETE_DETAILS is invoked?

  A. It executes successfully but no error messages get recorded in the DEBUG_OUTPUT table
  B. It executes successfully and any error messages get recorded in the DEBUG_OUTPUT table.
  C. It gives an error because PRAGMA AUTONOMOUS_TRANSACTION can be used only in packaged procedures.
  D. It gives an error because procedures containing PRAGMA AUTONOMOUS_TRANSACTION cannot be called from the exception section.
  A. It executes successfully but no error messages get recorded in the DEBUG_OUTPUT table

• Question 69:

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

  

  View Exhibit 2 and examine the code created by the user SCOTT:

  

  SCOTT grants the necessary privileges to green to access the EMP table and execute the package.

  Examine the following sequence of activities:

  SCOTT starts a session and issues the SQL>EXEC CURS_PKG.OPEN command.

  SCOTT then issues the SQL>EXEC CURS_PKG.NEXT command.

  green starts a session while SCOTT's session is running and issues THE SQL>EXEC CURS_PKG.NEXT command.

  SCOTT issues the SQI>>EXEC SCOTT.CURS_PKG.NEXT command.

  The EMP table contains sequential EMPNOS from 100 through 108.

  Which statement correctly describes the output?

  A. SCOTT's session shows the EMPNO 100, GREEN'S session shows an error, and SCOTT's session shows an error.
  B. SCOTT's session shows the EMPNO 100, GREEN'S session shows EMPNO 100, and SCOTT's session shows the EMPNO 101.
  C. SCOTT's session shows the EMPNO 100, GREEN'S session shows an error, and SCOTT's session shows the second EMPNO 101.
  D. SCOTT's session shows the EMPNO 100, GREEN'S session shows EMPNO 101, and SCOTT's session shows the second EMPNO 102.
  C. SCOTT's session shows the EMPNO 100, GREEN'S session shows an error, and SCOTT's session shows the second EMPNO 101.

• Question 70:

  Examine the following PL/SQL code; The execution of the code produces errors. Identify the error in the code.

  

  A. The OPEN cursor is missing.
  B. The FETCH clause is missing.
  C. The EXIT WHEN condition is missing.
  D. The EMP_NAME and EMP_JOB variables cannot be used in the for clause of the cursor FOR statement.
  D. The EMP_NAME and EMP_JOB variables cannot be used in the for clause of the cursor FOR statement.