SQL Basics Practice Test

Data types define what kind of values a column can hold. When a column is meant to store words, phrases, or any sequence of characters, a text (string) type is used. Text is the best fit because it is designed for characters and variable length. A Boolean type stores true or false values, an Integer stores whole numbers, and a Real stores numbers with decimals. Therefore, for a column that contains text, the appropriate data type is Text.