Multiple choice technology databases

Text literals have properties of which of the following datatypes (choose all that apply):

  1. CHAR

  2. CLOB

  3. VARCHAR2

  4. Float
Reveal answer Fill a bubble to check yourself
A,C Correct answer
Explanation

Text literals in SQL have properties of both CHAR (fixed-length character strings) and VARCHAR2 (variable-length character strings) datatypes. CLOB is for large character objects, and Float is a numeric datatype unrelated to text. Text literals can be assigned to either CHAR or VARCHAR2 columns.

Keep practicing — related questions