SQL Quiz

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

• SEARCH

• SELECT

• EXTRACT

• FETCH

Which SQL command is used to add new data to a database table?

• ADD

• INSERT INTO

• CREATE

• UPDATE

What SQL command is used to modify existing data in a database table?

• ALTER

• MODIFY

• UPDATE

• CHANGE

Which SQL command is used to remove records from a database table?

• DELETE

• REMOVE

• DROP

• ERASE

What SQL clause is used to filter results based on a specified condition?

• SORT

• LIMIT

• WHERE

• FILTER

Which SQL command is used to sort the result set in ascending or descending order based on specified columns?

• ORDER

• SORT

• GROUP

• ARRANGE

What SQL clause is used to group rows with the same values into summary rows, like "total" or "average" calculations?

• GROUP BY

• CATEGORIZE

• SUMMARIZE

• GROUP

Which SQL command is used to combine data from two or more database tables based on related columns?

• CONNECT

• COMBINE

• JOIN

• MERGE

What SQL clause is used to specify a condition for retrieving or manipulating data after the WHERE clause has been applied?

• FILTER

• HAVING

• WHILE

• FOLLOWING

Which SQL command is used to retrieve unique values from a specified column in the result set?

• UNIQUE

• DISTINCT

• SINGLE

• ONLY