SQL character data format(s)is(are)____.
A) CHAR and VARCHAR
B) VARCHAR only
C) Alphanumeric
D) CHAR only

Question

Quizplus · Accepted Answer

CHAR and VARCHAR are both character data formats in SQL, with CHAR being a fixed-length format and VARCHAR being a variable-length format. Therefore, option A is the best choice as it accurately identifies the available character data formats in SQL. Option B is incorrect as it implies that CHAR does not exist as a character data format. Option C is incorrect as it describes the type of data that can be stored in a character data format, rather than the format itself. Option D is incorrect as it excludes the widely used VARCHAR format.

SQL Character Data Format(s)is(are)____