Oracle 1Z0-144 Online Practice Questions and Exam Preparation

Oracle 1Z0-144 Online Questions & Answers

• Question 51:

  What is the correct definition of the persistent state of a packaged variable?

  A. It is a private variable defined in a procedure or function within a package body whose value is consistent within a user session.
  B. It is a public variable in a package specification whose value is consistent within a user session.
  C. It is a private variable in a package body whose value is consistent across all current active sessions.
  D. It is a public variable in a package specification whose value is always consistent across all current active sessions.
  B. It is a public variable in a package specification whose value is consistent within a user session.

• Question 52:

  Examine the following command:

  SQL>ALTER SESSION SET plsql_warnings * 'enable: severe', 'enable: performance', 'ERROR: 05003';

  What is the implication of the above command?

  A. It issues a warning whenever ERROR: 05003 occur during compilation.
  B. It causes the compilation to fail whenever the warning ERROR.05003 occurs.
  C. It issues warnings whenever the code causes an unexpected action or wrong results performance problems.
  D. It causes the compilation to fail whenever the code gives wrong results or contains statements that are never executed.
  B. It causes the compilation to fail whenever the warning ERROR.05003 occurs.

• Question 53:

  Which system events can be used to create triggers that fire both at DATABASE and SCHEMA levels? (Choose two.)

  A. AFTER LOGON
  B. AFTER STARTUP
  C. BEFORE SHUTDOWN
  D. AFTER SERVERERROR
  A. AFTER LOGON
  D. AFTER SERVERERROR

• Question 54:

  View the Exhibit and examine the code and its outcome on execution:

  

  What would be the effect on the two procedures if the value of debug is set to FALSE? (Choose two.)

  A. MY_PROC2 is not recompiled.
  B. MY_PROC1 is recompiled but remains unchanged.
  C. MY_PROC2 is recompiled but remains unchanged.
  D. MY_PROC1 is recompiled without the debugging code.
  C. MY_PROC2 is recompiled but remains unchanged.
  D. MY_PROC1 is recompiled without the debugging code.

• Question 55:

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

  

  View Exhibit 2 and examine the PIVSQL 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 56:

  View the Exhibit and examine the partial data in the PRODUCTS table. PROD_ID is the primary key.

  

  Examine the following code:

  

  What is the outcome on execution of the above code?

  A. It executes successfully.
  B. It gives an error because the DECODE function can be used only in a SQL statement.
  C. It gives an error because the SUBSTR and INSTR functions can be used only in a SQL statement.
  D. It gives an error because both the MAX and DECODE functions can be used only in a SQL statement.
  A. It executes successfully.

• Question 57:

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

  

  View Exhibit 2 and examine the code.

  

  The anonymous block gives an error on execution. What is the reason?

  A. The assignment in line 7 is not valid.
  B. The SQL does not support the Boolean data type.
  C. A null value cannot be applied to the bind arguments in the using clause in line 10.
  D. The names of bind variables must be the same as the using clause bind arguments in line 10.
  B. The SQL does not support the Boolean data type.

• Question 58:

  Which statements are true about database triggers? (Choose two.)

  A. They can invoke only PL/SQL procedures.
  B. They can include SQL and PL/SQL or calls to Java procedures.
  C. They are implicitly fired by an event that must occur within an application.
  D. They are implicitly fired when a triggering event occurs, depending on which user is connected.
  B. They can include SQL and PL/SQL or calls to Java procedures.
  D. They are implicitly fired when a triggering event occurs, depending on which user is connected.

• Question 59:

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

  

  View Exhibit 2 and examine the code.

  

  What is the outcome when the code is executed?

  A. Both blocks compile and execute successfully when called.
  B. Both blocks compile successfully but the CALC_SAL procedure gives an error on execution.
  C. The CALC_SAL procedure gives an error on compilation because the amt variable should be declared in the RAISE_SALARY procedure.
  D. The CALC_SAL procedure gives an error on compilation because the RAISE_SALARY procedure cannot call the stand-alone increase function.
  A. Both blocks compile and execute successfully when called.

• Question 60:

  Examine the following PL/SQL code:

  

  Which statement is true about the execution of the code if the query in the PL/SQL block returns no rows?

  A. The program abruptly terminates and an exception is raised.
  B. The program executes successfully and the output is No ROWS_FOUND.
  C. The program executes successfully and the query fetches a null value in the V_LNAME variable.
  D. Program executes successfully, fetches a NULL value in the V_LNAME variable and an exception is raised.
  A. The program abruptly terminates and an exception is raised.