Oracle 1Z0-144 Online Practice Questions and Exam Preparation

Oracle 1Z0-144 Online Questions & Answers

• Question 81:

  View the Exhibit to examine the PL/SQL block.

  

  Which two statements are true about the execution of the PL/SQL block? (Choose two.)

  A. It executes successfully and gives the desired output.
  B. It does not execute because the definition of type POPULATION is indexed by VARCHAR2.
  C. It executes, and the string keys of an associative array are not stored in creation order, but in sorted order.
  D. It does not execute because the value that is once assigned to the element of the associative array cannot be changed.
  A. It executes successfully and gives the desired output.
  C. It executes, and the string keys of an associative array are not stored in creation order, but in sorted order.

• Question 82:

  Which tasks must be performed during the installation of the UTL_MAIL package? (Choose two.)

  A. setting the UTL_FILE_DIR initialization parameter
  B. running the utlmail.sql and prvtmail.plb scripts
  C. setting the SMTP_OUT_SERVER initialization parameter
  D. using the CREATE DIRECTORY statement to associate an alias with an operating system directory
  E. granting read and WRITE privileges to control the type of access to files in the operating system
  B. running the utlmail.sql and prvtmail.plb scripts
  C. setting the SMTP_OUT_SERVER initialization parameter

• Question 83:

  Which two tasks should be created as functions instead of as procedures? (Choose two.)

  A. Reference host or bind variables in a PL/SQL block of code
  B. Tasks that compute and return multiple values to the calling environment
  C. Tasks that compute a value that must be returned to the calling environment
  D. Tasks performed in SQL that increase data independence by processing complex data analysis within the Oracle server, rather than by retrieving the data into an application
  C. Tasks that compute a value that must be returned to the calling environment
  D. Tasks performed in SQL that increase data independence by processing complex data analysis within the Oracle server, rather than by retrieving the data into an application

• Question 84:

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

  

  CUST_ID and CUST_CREDIT_LIMIT are existing columns in the CUSTOMER table. Examine the following trigger code:

  

  Which statement is true about the above trigger?

  A. It gives an error on compilation because it should be a statement-level trigger.
  B. It compiles and fires successfully when the credit limit is updated in the customer table.
  C. It gives an error on compilation because of the commit command in the trigger code.
  D. It compiles successfully, but gives an error when the credit limit is updated in the CUSTOMER table because the PRAGMA AUTONOMOUS_TRANSACTION statement should be introduced in the trigger.
  D. It compiles successfully, but gives an error when the credit limit is updated in the CUSTOMER table because the PRAGMA AUTONOMOUS_TRANSACTION statement should be introduced in the trigger.

• Question 85:

  In which of the following scenarios would you recommend using PL/SQL records?

  A. when you want to retrieve an entire row from a table and perform calculations
  B. when you know the number of elements in advance and the elements are usually accessed sequentially
  C. when you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries
  D. when you want to create a relatively small lookup table, where the collection can be constructed in memory each time a subprogram is invoked
  A. when you want to retrieve an entire row from a table and perform calculations

• Question 86:

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

  

  View Exhibit 2 and examine the code.

  

  What would be the outcome when the code is executed?

  A. It executes successfully.
  B. It gives an error because the SAL variable is not visible in the INCREASE function.
  C. It gives an error because the INCREASE function cannot be called from the RAISE_SALARY procedure.
  D. It gives an error because the INCREASE function and the RAISE_SALARY procedure should be declared at the beginning of the DECLARE section before all the other declarations.
  A. It executes successfully.

• Question 87:

  View the Exhibit and examine the blocks of code that you plan to execute.

  

  Which statement is true about the blocks of code?

  A. All the blocks execute successfully and the anonymous block displays123cant: 4545cnt: 45.
  B. All the blocks execute successfully and the anonymous block displays123cut: 045cart: 1.
  C. The anonymous block gives an error because the function invocation in line 2 is not valid.
  D. The procedure creation gives an error because the function invocation in line 1 is not valid.
  A. All the blocks execute successfully and the anonymous block displays123cant: 4545cnt: 45.

• Question 88:

  You execute the following block of code:

  

  Which statement is true about the outcome?

  A. Both output statements show different values.
  B. Both output statements show exactly the same values.
  C. It gives an error because the nested blocks are not labeled.
  D. It gives an error because the V_CUSTOMER variable cannot have different types in the nested blocks.
  A. Both output statements show different values.

• Question 89:

  Examine the following PL/SQL code:

  

  Which statement is true about the execution of the PL/SQL code?

  A. It executes successfully.
  B. It generates a run-time exception.
  C. It does not execute because of syntax error.
  D. It executes successfully and generates a warning.
  B. It generates a run-time exception.

• Question 90:

  Examine the following code that you plan to execute:

  

  What correction should be performed in the above code?

  A. The PROC2 procedure code should be defined in the package body.
  B. The PROC3 procedure should be declared in the package specification.
  C. The PROC3 procedure header should be declared at the beginning of the package body.
  D. The variable x must be declared in the package body and removed from the specification,
  A. The PROC2 procedure code should be defined in the package body.