Information Management - Quiz 02 - SQL 02

Which SQL data type is used to store whole numbers?

• VARCHAR

• INT

• TEXT

• CHAR

What does the VARCHAR data type represent in SQL?

• Fixed-length character strings

• Large text data

• Variable-length character strings

• Floating-point numbers

Which SQL command is used to remove a database object like a table or a database?

• DELETE

• DROP

• ALTER

• TRUNCATE

In SQL, what does the % wildcard character represent?

• A single character

• Any number of characters

• Digits only

• No characters

Which SQL data type would be appropriate for storing a blog post's content?

• INT

• VARCHAR

• TEXT

• BOOLEAN

Which SQL command is part of Data Definition Language (DDL)?

• INSERT

• SELECT

• CREATE

• UPDATE

What is the purpose of a foreign key in SQL?

• To uniquely identify each row in a table

• To reference the primary key in another table

• To store large amounts of text

• To calculate aggregate functions

Which SQL data type is used to store logical values like TRUE or FALSE?

• BOOLEAN or BIT

• CHAR

• INT

• DATE

What does the UPDATE command in SQL do?

• Inserts new rows into a table

• Modifies existing data in a table

• Removes a table from the database

• Retrieves data from a table

What SQL data type would you use to store a date and time?

• DATETIME

• INT

• VARCHAR

• BOOLEAN