Multiple choice technology databases

Which three of the following methods make PL/SQL tables easier to use? (Choose three)

  1. EXISTS

  2. SUBSTR

  3. TRIM

  4. FLOOR

  5. COUNT

  6. UPPER
Reveal answer Fill a bubble to check yourself
A,C,E Correct answer
Explanation

EXISTS checks if a specific element exists in a PL/SQL table, preventing NO_DATA_FOUND exceptions. TRIM removes elements from the end of a PL/SQL table (not string trimming - it's a collection method). COUNT returns the number of elements in a PL/SQL table. These are built-in PL/SQL table methods that make manipulation easier. SUBSTR, FLOOR, and UPPER are general SQL/PL functions, not specific PL/SQL table methods.

Keep practicing — related questions