Prepare
Practice
Interview
Aptitude
Reasoning
English
GD
Placement papers
HR
Current affairs
Engineering
MCA
MBA
Online test
Login
Online Practice Test
>
PLSQL 1
« Previous
Next »
Which type of collection exception is raised for situation like “You try to operate on an atomically null collection”?
Options
- COLLECTION_IS
- NULL
- COLLECTION_IS_NULL
- VALUE_ERROR
CORRECT ANSWER : COLLECTION_IS_NULL
Discussion Board
Collection Exceptions
A collection is an ordered group of elements having the same data type. Each element is identified by a unique subscript that represents its position in the collection. Following are the collection exceptions:
1. COLLECTION_IS_NULL : You try to operate on an atomically null collection.
2. NO_DATA_FOUND : A subscript designates an element that was deleted, or a nonexistent element of an associative array.
3. SUBSCRIPT_BEYOND_COUNT : A subscript exceeds the number of elements in a collection.
4. SUBSCRIPT_OUTSIDE_LIMIT : A subscript is outside the allowed range.
5. VALUE_ERROR : A subscript is null or not convertible to the key type. This exception might occur if the key is defined as a PLS_INTEGER range, and the subscript is outside this range.
Prajakta Pandit 02-21-2017 03:37 AM
« Previous
Next »
Write your comments
*
*
Email must be in the form someone@domain.com
*
*
Enter the code shown above:
Please enter the code shown above
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)
Related Content
Oracle (40)
Oracle (30)
Oracle (49)
Oracle (51)
Oracle (52)
Oracle DBA (29)
Oracle PLSQL (30)
Oracle Replication (20)
Oracle Architecture (20)
Oracle Transaction (20)
PLSQL (22)
PLSQL (24)
PLSQL (50)
Advertisement
▲