Question

a) Differentiate CHAR and VARCHAR data types in SQL (2M)
b) Write SQL command to create table CLUB with following structure. (M
Field
Type Constraint
MEMBER_No Integer Primary Key
Member_Name Varchar(30) Not Null
Join Date
Date
Member_Type 1 char
Charges
Float
Insert 3 tuples with some data.​

Answer 1

Answer:

Char

• have Fixed length
• uses the same amount of storage space per entry

Varchar

• have variable length
• only uses the amount necessary to store the actual text