Q. Assigning a value to a collection element can cause exceptions, such as

  • (A) If the subscript is NULL or is not convertible to the right datatype, PL/SQL raises the predefined exception VALUE_ERROR. Usually, the subscript must be an integer. Associative arrays can also be declared to have VARCHAR2 subscripts.
  • (B) If the subscript refers to an uninitialized element, PL/SQL raises SUBSCRIPT_BEYOND_COUNT.
  • (C) If the collection is atomically null, PL/SQL raises COLLECTION_IS_NULL.
  • (D) All mentioned above
πŸ’¬ Discuss
βœ… Correct Answer: (D) All mentioned above

You must be Logged in to update hint/solution

πŸ’¬ Discussion

πŸ“Š Question Analytics

πŸ‘οΈ
326
Total Visits
πŸ“½οΈ
3 y ago
Published
πŸŽ–οΈ
Mr. Dubey
Publisher
πŸ“ˆ
92%
Success Rate