Question

Character data can be stored as ______________

(a) Fixed length string

(b) Variable length string

(c) Either Fixed or Variable length string

(d) None of the mentioned

This question was addressed to me in exam.

This key question is from MySQL Datatypes in division Data Types of MySQL

Answer 1

The correct option is (c) Either Fixed or Variable length string

For explanation: To store character data we can use two definitions

Char(20)  /*fixed length */

Varchar(20) /* variable length */