Question

Which of the following is not a valid data type of SQL?

• A. CHAR(n)
• B. VARCHAR(n)
• C. STR(n)
• D. DATE

Hint:

SQL does not use STR(n) — use CHAR, VARCHAR, or TEXT for strings.

Answer 1

The Correct Option is C

In SQL, data types define the kind of data that can be stored in a column.
- CHAR(n) is a fixed-length character type.
- VARCHAR(n) is a variable-length character type.
- DATE is used to store calendar dates.
However, STR(n) is not a standard SQL data type — it may appear in other programming languages like Python (as "str"), but not in SQL syntax.
Hence, it is the incorrect or invalid option in the context of SQL data types.