Oracle 1Z0-149 Online Practice Questions and Exam Preparation

Oracle 1Z0-149 Online Questions & Answers

• Question 61:

  Which two statements are true about using the OR REPLACE clause when creating named subprograms? (Choose two.)

  A. Function based indexes remain usable when replacing the function on which the index depends.
  B. Object privileges to execute a replaced function must be regranted to those users who had the privilege.
  C. This clause can be used only for procedures and functions.
  D. A function definition can be modified without dropping and re-creating it.
  E. Object privileges to execute a replaced function are retained by those users who had the privileges.
  D. A function definition can be modified without dropping and re-creating it.
  E. Object privileges to execute a replaced function are retained by those users who had the privileges.

• Question 62:

  Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)

  A. DISABLE
  B. ENABLE
  C. ERROR
  D. ALL
  E. SEVERE
  D. ALL
  E. SEVERE

• Question 63:

  Examine these statements issued by user SH which execute successfully:

  

  DBMS_OUTPUT.PUT_LINE(p_price(i)); END LOOP; END; END products_pkg; / Now, examine this anonymous block executed by SH:

  

  Which is true about the anonymous block?

  A. It will execute successfully only if PriceList is removed from the DECLARE section and defined as a standalone collection type.
  B. It will execute successfully only if PriceList is defined as an associative array in the package and anonymous block.
  C. It will fail at lines 6 and 7.
  D. It will fail only at line 7.
  D. It will fail only at line 7.

• Question 64:

  Examine this statement which is submitted for compilation:

  

  Which three are true? (Choose three.)

  A. This is a PACKAGE specification. A PACKAGE BODY is needed to use this.
  B. This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.
  C. This program unit will compile successfully.
  D. Initialization of min_bal can be done while using this packaged constant in another program.
  E. Initialization of loan_amount can be done while using this packaged variable in another program.
  F. This will not compile successfully because the min_bal constant must be initialized.
  G. This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.
  B. This will not compile successfully because the loan_amount variable is declared NOT NULL but lacks an initialization assignment.
  F. This will not compile successfully because the min_bal constant must be initialized.
  G. This is BODILESS PACKAGE. A PACKAGE BODY is not required to use this.

• Question 65:

  Which is the correct method to implement a local subprogram in an anonymous block?

  

  

  A. Option A
  B. Option B
  C. Option C
  D. Option D
  A. Option A

  ---

  Explanation/Reference: