Free Test SQL Data Types Overview – SQL

Q1: Which of the following is a valid numeric SQL data type?

A. VARCHAR B. DATE C. INT D. BOOLEAN

Q2: Which data type is used to store integer values in SQL?

A. INT B. VARCHAR C. DATE D. FLOAT

Q3: What data type should you use for a name field?

A. DATE B. INT C. VARCHAR D. FLOAT

Q4: Which SQL data type is best suited for storing monetary values?

A. FLOAT B. DECIMAL C. VARCHAR D. BOOLEAN

Q5: Which of the following is a date/time data type in SQL?

A. VARCHAR B. TIMESTAMP C. INT D. FLOAT

Q6: What is the maximum size of a VARCHAR in most SQL databases?

A. 255 characters B. 65535 characters C. 10 characters D. 1000 characters

Q7: Which data type should you use for storing true or false values?

A. BOOLEAN B. CHAR C. DECIMAL D. DATE

Q8: Which SQL type allows only fixed-length text?

A. VARCHAR B. TEXT C. CHAR D. INT

Q9: Which data type allows storage of large binary files?

A. BLOB B. BOOLEAN C. INT D. VARCHAR

Q10: Which of the following is used to store exact numbers in SQL?

A. FLOAT B. DECIMAL C. VARCHAR D. CHAR

Q11: Which type would be best for storing time only?

A. DATE B. TIME C. DATETIME D. TEXT

Q12: What does the TEXT data type store?

A. Boolean values B. Large text strings C. Date values D. Numeric values

Q13: Which of these is not a valid SQL numeric data type?

A. INT B. FLOAT C. BOOLEAN D. DECIMAL

Q14: Which data type supports time zone info?

A. TIMESTAMP WITH TIME ZONE B. TIME C. VARCHAR D. CHAR

Q15: Which SQL type stores both date and time?

A. TIME B. DATE C. DATETIME D. BOOLEAN

Q16: What data type would be used for storing exact ages?

A. FLOAT B. CHAR C. INT D. DATE

Q17: Which data type allows storage of approximate numeric values?

A. FLOAT B. CHAR C. BOOLEAN D. DATE

Q18: Which SQL data type would be ideal for a short description?

A. INT B. VARCHAR C. BOOLEAN D. DATE

Q19: Which of the following can store time data with fractional seconds?

A. TIME(0) B. TIME(3) C. BOOLEAN D. CHAR

Q20: What is the storage size of a SMALLINT?

A. 1 byte B. 2 bytes C. 4 bytes D. 8 bytes

Q21: Which data type allows very large integers to be stored?

A. BIGINT B. SMALLINT C. CHAR D. DECIMAL(2)

Quiz for SQL Data Types Overview