An attribute A of datatype varchar(20) has the value “Avi”. The attribute B of datatype char(20) has value ”Reed”. Here attribute A has ____ spaces and attribute B has ____ spaces.

An attribute A of datatype varchar(20) has the value “Avi”. The attribute B of datatype char(20) has value ”Reed”. Here attribute A has ____ spaces and attribute B has ____ spaces.
3, 20
Explanation: Varchar changes its length accordingly whereas char has a specific length which has to be filled by either letters or spaces.
20, 4
20, 20
3, 4

Leave a Reply

Your email address will not be published. Required fields are marked *