Oracle 1Z0-144 Online Practice Questions and Exam Preparation

Oracle 1Z0-144 Online Questions & Answers

• Question 41:

  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
  B. line 3
  D. line 5

• Question 42:

  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 function cannot be overload.
  B. Because function cannot differ only in return type.
  C. Because all the functions and procedures in the package cannot have the same number of parameters with the same parameter name.
  D. 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 differ only in return type.

• Question 43:

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

  A. All the triggers that are created on a table cannot be disabled simultaneously.
  B. Any user who has the alter privilege on a table can create a trigger using that table.
  C. Oracle provides a two-phase commit process whether a trigger updates tables in the local database or remote tables in a distributed database.
  D. Triggers become invalid if a dependent object, such as 3 stored subprogram that is invoked from the trigger body is modified, and have to be manually recompiled before the next invocation.
  C. Oracle provides a two-phase commit process whether a trigger updates tables in the local database or remote tables in a distributed database.
  D. Triggers become invalid if a dependent object, such as 3 stored subprogram that is invoked from the trigger body is modified, and have to be manually recompiled before the next invocation.

• Question 44:

  Which statements are true about the WHEN OTHERS exception handler? (Choose two.)

  A. It can be the first exception handler.
  B. It can be the only exception handler for the code.
  C. It traps all the exceptions that are not already trapped.
  D. You can have multiple OTHERS clauses to trap all the multiple unhandled exceptions.
  B. It can be the only exception handler for the code.
  C. It traps all the exceptions that are not already trapped.

• Question 45:

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

  

  View Exhibit 2 and examine the code.

  

  EKPNOS 7845 and 7900 exist in the EMP table.

  Which two calls to the RAISE_SALABY procedure in the anonymous block execute successfully? (Choose two.)

  A. call in line 6
  B. call in line 7
  C. call in line 8
  D. call in line 9
  C. call in line 8
  D. call in line 9

• Question 46:

  Which type of exceptions is qualified as nonpredefined Oracle server errors?

  A. the exceptions that are explicitly raised by the program and can be caught by the exception handler
  B. the exceptions that are raised implicitly by the Oracle server and can be caught by the exception handler
  C. an exception that the developer determines as abnormal, are in the declarative section and raised explicitly
  D. an exception that is raised automatically when the PL/SQL program violates a database rule or exceeds a system-dependent limit
  B. the exceptions that are raised implicitly by the Oracle server and can be caught by the exception handler

• Question 47:

  Examine the following partial code:

  

  Which statement is correct about the unnamed block of code at the end of a package body?

  A. It generates an error because all the blocks of code in a package body must be named.
  B. It generates an error because V_TAXRATE is a public variable that is already initialized in the package specification.
  C. It acts as a package initialization block that executes once, when the package is first invoked within the user session.
  D. It acts as a package initialization block that executes each time a package subprogram is invoked within the user session and refreshes the initialized variable's value.
  C. It acts as a package initialization block that executes once, when the package is first invoked within the user session.

• Question 48:

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

  

  You need to create a trigger to ensure that customers in category "A" and "B" have a credit limit of more than 8000. Examine the following trigger.

  

  Which statement is correct about the outcome of this trigger?

  A. It compiles successfully and fires whenever the specified condition is met.
  B. It compiles successfully but does not fire even when the condition is met.
  C. It gives an error on compilation because the NEW qualifier is prefixed with a colon.
  D. It gives an error on compilation because the NEW qualifier can be used only in row-level triggers.
  D. It gives an error on compilation because the NEW qualifier can be used only in row-level triggers.

• Question 49:

  You want to store values of different data types in a PL/SQL block and store one record at a time for processing the information. Which type of composite data type would you choose to fulfill the requirement?

  A. VARRAYS
  B. Nested table
  C. PL/SQL records
  D. Associative arrays
  C. PL/SQL records

• Question 50:

  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.
  C. It gives an error because the usage of the host variables is invalid.