Multiple choice

___________ are padded with space characters to match the specified length.

  1. VARCHAR

  2. VARCHAR2

  3. CHAR

  4. CHAR2
Reveal answer Fill a bubble to check yourself
C Correct answer
Explanation

CHAR is a fixed-length data type that pads values with space characters to match the declared length. VARCHAR and VARCHAR2 are variable-length and don't pad. CHAR2 doesn't exist in Oracle. This padding behavior is important for string comparison and storage considerations - 'abc' in CHAR(10) becomes 'abc ' (seven spaces added).

Keep practicing — related questions