1. What does SQL stand for in MS Access?
(A) Simple Query Language
(B) Standard Question Language
(C) System Query Logic
(D) Structured Query Language
2. Which SQL statement is used to retrieve data from a database table?
(A) UPDATE
(B) INSERT
(C) SELECT
(D) DELETE
3. In SQL, which clause is used to filter records based on a condition?
(A) WHERE
(B) ORDER BY
(C) GROUP BY
(D) HAVING
4. Which SQL statement is used to add new records into a table?
(A) INSERT INTO
(B) ADD RECORD
(C) APPEND
(D) UPDATE
5. Which SQL statement is used to remove records from a table?
(A) DROP
(B) DELETE
(C) REMOVE
(D) ERASE
6. Which SQL keyword is used to sort the results of a query?
(A) GROUP BY
(B) SORT
(C) ORDER BY
(D) FILTER
7. Which clause is used in SQL to combine rows that have the same values in specified fields?
(A) ORDER BY
(B) GROUP BY
(C) DISTINCT
(D) HAVING
8. The HAVING clause in SQL is mainly used with:
(A) Table relationships
(B) Primary keys
(C) DELETE statements
(D) Aggregate functions like SUM, COUNT
9. Which SQL statement is used to modify existing data in a table?
(A) ALTER
(B) UPDATE
(C) INSERT INTO
(D) MODIFY
10. In MS Access SQL, the wildcard symbol * is used to:
(A) Multiply numbers
(B) Select all fields from a table
(C) Delete all records
(D) Create relationships