SQL - Quiz

What does SQL stand for?

• Structured Question Language
• Structured Query Language
• Simple Query Language
• Sequential Query Language

Which of the following is used to retrieve data from a database?

• INSERT
• UPDATE
• SELECT
• DELETE

What command is used to remove all records from a table without deleting the table?

• DELETE
• DROP
• REMOVE
• TRUNCATE

Which MySQL command is used to change data in a table?

• SELECT
• MODIFY
• UPDATE
• SET

What is the default port for MySQL?

• 1433
• 1521
• 3306
• 5432

Which keyword is used to eliminate duplicate rows in a SELECT statement?

• UNIQUE
• DELETE
• DISTINCT
• FILTER

What does the WHERE clause do in a SQL query?

• Filters columns
• Filters rows
• Groups results
• Sorts records

Which of the following is not a valid MySQL data type?

• VARCHAR
• INTEGER
• STRING
• DATE

What does the LIMIT clause do in a SELECT query?

• Groups records
• Restricts column output
• Restricts number of rows returned
• Defines permissions

Which SQL statement is used to create a new table?

• MAKE TABLE
• INSERT TABLE
• CREATE TABLE
• ADD TABLE