PLSQL Set 7

Asynchronous ✘ Synchronous ✘ Asymmetric ✘ Symmetric ✔

getArray() ✘ getOracleArray() ✘ get() ✘ None of these ✔

l_names.Truncate; ✘ l_names.DELETE; ✘ l_names.TRIM; ✘ None of these ✔

FETCH ✘ LOCK TABLE ✘ FOR UPDATE ✘ OPEN ✔

The nested cursor is explicitly closed by the user. ✘ The parent cursor is re-executed. ✘ The parent cursor is closed. ✘ All of these ✔

EXISTS(n) returns true if the nth element in a collection exists. ✘ EXISTS method is used to avoid referencing nonexistent elements. ✘ EXISTS method with the DELETE method can work with sparse nested tables. ✘ All of these ✔

On the right side of the the SET clause in an UPDATE statement ✘ In the VALUES clause of an INSERT statement ✘ In the INTO subclause of a RETURNING clause ✘ All of these ✔

TYPE numbers_vat IS VARRAY(10) ✘ TYPE numbers_vat IS NUMBER; ✘ TYPE numbers_vat IS VARRAY(10) OF NUMBER; ✘ TYPE numbers_vat VARRAY(10) NUMBER ; ✔

COLLECTION_IS_NULL ✘ NO_DATA_FOUND ✘ SUBSCRIPT_BEYOND_COUNT ✘ All of these ✔

The 'FIRST' collection will return a null value. ✘ The 'LAST' collection will return a null value ✘ Both the collections will return a null value. ✘ None of these ✔