Bionthly Test Eight & Seventh Grade

What SQL command is used to retrieve data from a database?

• INSERT
• UPDATE
• SELECT
• DELETE

Which SQL clause is used to filter records?

• ORDER BY
• WHERE
• SELECT
• JOIN

What does SQL stand for?

• Structured Query Language
• Simple Query Language
• Sorted Query Language
• Server Query Language

In SQL, what command is used to add a new row to a table?

• INSERT INTO
• ADD ROW
• APPEND
• NEW ROW

What does the SQL command DELETE do?

• Adds data
• Removes data
• Modifies data
• Creates a table

Which SQL function returns the largest value?

• MIN
• MAX
• COUNT
• AVG

What is a primary key in a database?

• A unique identifier
• A foreign key
• A table name
• A column that stores keys

Which command creates a new table in SQL?

• INSERT INTO
• CREATE TABLE
• ADD TABLE
• NEW TABLE

What is a foreign key?

• A unique identifier
• Links to another table
• The main table key
• A type of index

In SQL, what does the AVG() function calculate?

• Total value
• Maximum value
• Average value
• Minimum value