Beginner level sql quiz

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

SELECT

INSERT

UPDATE

DELETE

Which SQL keyword is used to filter the results of a query?

WHERE

ORDER BY

HAVING

GROUP BY

Which SQL command is used to insert data into a table?

INSERT INTO

UPDATE

SELECT INTO

CREATE TABLE

Which SQL keyword is used to sort the result-set in ascending or descending order?

ORDER BY

SORT

GROUP BY

FILTER BY

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

UPDATE

MODIFY

EDIT

CHANGE

Which SQL clause is used to group rows that have the same values?

ORDER BY

GROUP BY

HAVING

DISTINCT

What does the `COUNT()` function do in SQL?

Returns the number of rows in a table

Returns the sum of a column

Returns the maximum value in a column

Returns the average value in a column

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

DELETE

REMOVE

DROP

TRUNCATE

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

LIKE

IN

BETWEEN

IS NULL

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

CREATE TABLE table_name

MAKE TABLE table_name

NEW TABLE table_name

ADD TABLE table_name