Explanation: Varchar changes its length accordingly whereas char has a specific length which has to be filled by either letters or spaces . 6. 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 .
A. 3, 20
B. 20, 4
C. 20 , 20
D. 3, 4
Answer:A
Explanation: Varchar changes its length accordingly whereas char has a specific length which has to be filled by either letters or spaces . 6. 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 .
A. 3, 20 B. 20, 4 C. 20 , 20 D. 3, 4
Explanation: Varchar changes its length accordingly whereas char has a specific length which has to be filled by either letters or spaces. 7. To remove a relation from an SQL database, we use the ______ command.