Beginner level sql quiz

Which SQL clause is used to remove duplicate values from the result set?

DISTINCT

UNIQUE

REMOVE

NO DUPLICATES

Which SQL statement is used to create a new database?

CREATE DATABASE

NEW DATABASE

MAKE DATABASE

ADD DATABASE

Which SQL keyword is used to combine the results of two queries?

JOIN

COMBINE

UNION

MERGE

What is the purpose of the `AND` operator in SQL?

To combine two conditions and return true if both are true

To check if either condition is true

To combine the results of two queries

To sort the results of a query

Which SQL function is used to find the maximum value in a column?

MAX()

MIN()

SUM()

AVG()

Which SQL function is used to calculate the total sum of a column?

SUM()

TOTAL()

ADD()

COUNT()

Which of the following SQL clauses is used to filter grouped records?

WHERE

HAVING

GROUP BY

ORDER BY

Which SQL statement is used to remove a table from the database?

DROP TABLE

DELETE TABLE

REMOVE TABLE

DELETE FROM

Which SQL operator is used to specify a range of values in a query?

BETWEEN

IN

LIKE

EQUALS

What is the correct SQL syntax for adding a column to an existing table?

ALTER TABLE table_name ADD column_name datatype

ADD COLUMN table_name

MODIFY TABLE table_name ADD column_name

CHANGE TABLE table_name ADD column_name