1z0-149 Practice Test

1z0-149 Practice Test practice questions, page 2 of 3, with answer review and explanations.

Question 6

Which three are true about anonymous blocks and subprograms? (Choose three.)

  1. Named subprograms cannot be called from other packages.
  2. PROCEDURE subprograms can accept parameters.
  3. A FUNCTION subprogram must return one or more values.
  4. Anonymous blocks cannot use packaged variables.
  5. Named subprograms are stored in the database server.
  6. Anonymous blocks must always start with the Declare keyword.
  7. FUNCTION subprograms must be called and passed through one or more parameters.

Question 7

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

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

Question 8

Examine the SH.PRODUCTS table: A row exists in SH.PRODUCTS with PDT_ID = 1. Now, examine this code and output executed by SH: Now, examine this block of code: Which error message(s) does it display on execution by user SH?

  1. Error in inner block
  2. Error in inner block Error in outer block
  3. Error in inner block Error in calling block
  4. Error in inner block Error in outer block Error in calling block

Question 9

Which two blocks of code display a numerical zero? (Choose two.)

Question 10

Which three are valid PL/SQL variable names? (Choose three.)

  1. printer_name#
  2. 1to7number
  3. yesterday's_date
  4. leap$year
  5. Number_of_days_between_March_and_April
  6. #printer_name
  7. v_fname