Which method is used to remove (n) elements from the end of collection?

Options
- TRIM
- DELETE
- TRIM (n)
- DELETE (n)


CORRECT ANSWER : TRIM (n)

Discussion Board
Collection Methods

TRIM procedure has two forms. TRIM removes one element from the end of a collection. TRIM(n) removes n elements from the end of a collection. If n is greater than COUNT, TRIM(n) raises SUBSCRIPT_BEYOND_COUNT. You cannot use TRIM with index-by tables.TRIM operates on the internal size of a collection. If TRIM encounters deleted elements, it includes them in its tally.

Prajakta Pandit 02-21-2017 03:36 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement