SQL MASTERCLASS

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

• GET

• OPEN

• EXTRACT

• SELECT

Which SQL clause is used to sort the result-set?

• ORDER BY

• SORT BY

• ALIGN BY

• ARRANGE BY

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

• MODIFY

• CHANGE

• UPDATE

• SAVE

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

• REMOVE

• DELETE

• ERASE

• DROP

Which SQL statement is used to insert new data into a database?

• ADD

• INSERT INTO

• NEW DATA

• CREATE

Which SQL keyword is used to retrieve only unique values?

• DIFFERENT

• DISTINCT

• UNIQUE

• SEPARATE

Which SQL function is used to count the number of rows in a SQL query?

• SUM()

• COUNT()

• NUMBER()

• TOTAL()

Which SQL clause is used to filter records?

• FILTER

• WHERE

• SEARCH

• FIND

Which SQL statement is used to create a new table?

• CREATE TABLE

• ADD TABLE

• NEW TABLE

• MAKE TABLE

What does the SQL WHERE clause do?

• It is used to limit the number of rows returned.

• It is used to filter the records.

• It is used to change the values in a table.

• It is used to arrange the data in a specific order.