1z0-149 Practice Test

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

Question 11

Which two are true about collections and RECORD types? (Choose two.)

  1. A variable of RECORD type can contain fields of another RECORD type or any collection type.
  2. Only associative arrays and nested tables can have elements of RECORD type.
  3. All collections and RECORD types can be defined in PL/SQL blocks, packages, or at the schema level.
  4. Collections and RECORD types are always dense.
  5. All collections and RECORD types can be stored in table columns.
  6. VARRAYS, nested tables and each field in %ROWTYPE type variables have a default value of null.

Question 12

Examine this table in the SH schema: User SH executes this code: The program must terminate with a user-defined message and no rows displayed if more than one product's price is 1000. With which option must “---placeholder” be replaced?

Question 13

Examine this row of data from the EMPLOYEES table: Now, examine this block of code which executes successfully: What is the value of v_commission?

  1. 5000
  2. 15000
  3. 2500
  4. 10000