SQL Data Types Quiz

What data type is used to store integer values in SQL?

• VARCHAR

• FLOAT

• INT

• TEXT

Which SQL data type is used for storing date and time information?

• BLOB

• DATETIME

• CHAR

• CLOB

What is the maximum length of a VARCHAR data type in SQL?

• 1 GB

• 4,000 characters

• 8,000 characters

• 2 GB

Which of the following is a binary data type in SQL?

• CHAR

• TEXT

• BLOB

• VARCHAR

What does the SQL data type 'CLOB' stand for?

• Complex Large Object

• Compressed Large Object

• Common Large Object

• Character Large Object

Which SQL data type is not supported by MySQL?

• BLOB

• VARCHAR

• CHAR

• NTEXT

What is the range of the SMALLINT data type in SQL?

• -9,223,372,036,854,775,808 to 9,223,372,036,854,775,807

• -32,768 to 32,767

• -2,147,483,648 to 2,147,483,647

• 0 to 255

Which SQL data type is used to store Unicode character strings?

• BLOB

• VARCHAR

• NCHAR

• TEXT

What is the purpose of the SQL data type 'TIMESTAMP'?

• Stores binary data

• Stores date and time

• Stores date only

• Stores time only

Which of the following data types can hold up to 2 GB of data?

• IMAGE

• BLOB

• CLOB

• VARCHAR