UGC NET CSE | December 2018 | Part 2 | Question: 77

Question

​​​​​​​An attribute $A$ of datatype varchar($20$) has the value $‘xyz’$, and the attribute $B$ of datatype char($20$) has the value $“lmnop”$, then the attribute $A$ has _____ spaces and attribute $B$ has ____ spaces.

• A. $3, 5$
• B. $20, 20$
• C. $3, 20$
• D. $20, 5$

Answer 1

$char(20)$ means, a complete space of $20$ characters is allocated for the variable

$varchar(20)$ means, the variable can take space upto $20$ characters, but if assigned less characters it will take less space.

$A(varchar(20))='xyz',$ takes only $3$ characters space.

$B(char(20))='lmnop',$ takes $20$ characters space.

So, $(C)$ should be correct

Answer 2

option C is correct as  data type A is varchar (20) means upto 20 characters ans data tyoe B  char (20) means strictly 20 characters. Hence A (XYZ) correspond to 3 spaces and B (lmnop) will be correspond to 20 spaces.