Question

The basic data type char(n) is a _____ length character string and varchar(n) is _____ length character.

(a) Fixed, equal

(b) Equal, variable

(c) Fixed, variable

(d) Variable, equal

I got this question in exam.

I want to ask this question from SQL Basics and SQL Data Definition topic in section SQL : Queries, Constraints and Triggers of Database Management

Answer 1

Right option is (c) Fixed, variable

Easy explanation - Varchar changes its length accordingly whereas char has a specific length which has to be filled by either letters or spaces.