Multiple choice technology databases

For a certain row ina table, a VARCHAR2 coilumn contains the value TCSLTD, padded to the right with seven spaces by the application when the length() function processes the coplumn value , what will be the value returned

  1. 6

  2. 13

  3. 30

  4. 60
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

The LENGTH() function counts the total characters including trailing spaces. VARCHAR2 stores trailing spaces as part of the value when explicitly added. 'TCSLTD' (6 chars) plus 7 spaces = 13 characters total. The length is 13, not 6.

Keep practicing — related questions