SQL Quiz

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

• GET

• OBTAIN

• SELECT

• FETCH

In a SELECT statement, which clause is used to filter rows?

• FILTER

• WHERE

• HAVING

• CONDITION

How do you select all columns from a table named "employees"?

• SELECT all FROM employees

• SELECT employees FROM database

• SELECT * FROM employees

• SELECT (*) FROM employees

Which SQL statement is used to modify existing records in a table?

• MODIFY

• ALTER

• CHANGE

• UPDATE

In an UPDATE statement, which clause specifies which record(s) should be updated?

• SET

• WHERE

• MODIFY

• CHANGE

Which SQL statement is used to remove records from a table?

• REMOVE

• DELETE

• DROP

• ERASE

What happens if you omit the WHERE clause in a DELETE statement?

• It will delete the first record in the table

• It will delete the last record in the table

• It will delete all records in the table

• It will result in an error

Which clause is used to sort the result set in a SELECT statement?

• SORT BY

• ORDER BY

• ARRANGE BY

• GROUP BY

How can you select only unique values in a SELECT statement?

• SELECT UNIQUE

• SELECT DISTINCT

• SELECT DIFFERENT

• SELECT SINGLE

Which operator is used to search for a specified pattern in a column?

• LIKE

• MATCH

• PATTERN

• FIND