MCQOPTIONS
Saved Bookmarks
| 1. |
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 |
| Answer» E. | |