An attribute A of datatype varchar(20) has the value 'xyz', and the attribute B of datatype char(20) has the value 'lmnop'. Then attribute A has ___ spaces and attribute B has ___ spaces.

1. A3,5
2. B20,20
3. C3,20
4. D20,5

Pick an option to check yourself, or open the answer below.

Show answer & explanation

Correct answer: C. 3,20

Explanation

VARCHAR stores only the 3 characters used; CHAR(20) is padded to the full 20 characters.