SQL quiz

What does SQL stand for?

• Structured Query Language

• Sequential Query Language

• Scripted Query Language

• Statistical Query Language

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

• SELECT

• WHERE

• FROM

• INSERT

Which SQL clause is used to filter records in a SELECT statement?

• ORDER BY

• GROUP BY

• HAVING

• WHERE

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

• REMOVE

• DELETE

• ERASE

• DROP

What does the SQL keyword 'DISTINCT' do?

• Deletes duplicate records from a result set

• Retrieves only the first record from a result set

• Groups similar records in a result set

• Orders records in a result set

Which SQL aggregate function returns the total number of rows in a table?

• AVG()

• SUM()

• COUNT()

• MAX()

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

• ASC

• SORT

• ORDER BY

• DESC

Which SQL join returns all records when there is a match in either left or right table?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL OUTER JOIN

Which SQL data type is used to store variable-length character strings?

• VARCHAR

• INT

• CHAR

• BOOLEAN

1. Which SQL statement is used to make permanent changes to the structure of a table?

• ALTER TABLE

• UPDATE TABLE

• MODIFY TABLE

• CHANGE TABLE