Mastering SQL: A Level Quiz

Which of the following is a valid SQL data type for storing textual data?

• INTEGER

• VARCHAR

• BOOLEAN

• FLOAT

What SQL data type would you use to store a date value?

• DATE

• TEXT

• CHAR

• TIMESTAMP

Which SQL clause is used to combine rows from two or more tables, based on a related column between them?

• SELECT

• JOIN

• WHERE

• GROUP BY

What type of SQL JOIN returns all records from the left table and the matched records from the right table?

• INNER JOIN

• LEFT JOIN

• RIGHT JOIN

• FULL JOIN

In SQL, which command is used to remove all records from a table without removing the table itself?

• DELETE

• DROP

• TRUNCATE

• REMOVE

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

• INSERT INTO

• UPDATE

• ALTER

• MODIFY

What is the purpose of the SQL WHERE clause?

• To specify the columns to be displayed

• To filter records

• To sort the result set

• To group records

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

• SUM()

• COUNT()

• AVG()

• TOTAL()

What is the result of the following SQL query: `SELECT * FROM Employees WHERE Salary > 50000;`?

• It selects all employees with a salary less than £50,000.

• It selects all employees with a salary greater than £50,000.

• It selects all employees with a salary equal to £50,000.

• It selects all employees regardless of salary.

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

• ORDER BY

• SORT BY

• GROUP BY

• ARRANGE BY