SQL Basics Quiz

What does SQL stand for?

• Structured Query Language

• Standard Query Language

• Simple Query Language

• None of the above

Which SQL statement is used to extract data from a database?

• GET

• SELECT

• EXTRACT

• OPEN

Which SQL statement is used to update data in a database?

• MODIFY

• CHANGE

• UPDATE

• EDIT

Which of the following is used to delete a table from a database?

• DROP TABLE

• DELETE TABLE

• REMOVE TABLE

• Erase TABLE

What is the correct SQL syntax to create a new table?

• CREATE TABLE table_name;

• CREATE NEW TABLE table_name;

• NEW TABLE table_name CREATE;

• None of the above

What keyword is used to sort the result set in SQL?

• ORDER BY

• GROUP BY

• SORT BY

• ARRANGE BY

Which clause is used to filter records in a SQL query?

• WHERE

• FILTER

• HAVING

• SELECT

What is the purpose of the COUNT() function in SQL?

• To count all rows

• To count non-NULL values

• To count distinct values

• To calculate the sum of values

Which of the following is used to limit the number of rows returned in a query?

• LIMIT

• LIMIT TO

• MAX ROWS

• TOP

Which SQL keyword is used to find unique records in a column?

• DISTINCT

• UNIQUE

• DIFFERENT

• NONE