SQL Mastery Quiz: Test Your Database Skills Quiz

1. SQL Basics

   What does SQL stand for in the context of database management?

   1. A. Structured Query Language
   2. B. Simple Question Language
   3. C. Standard Query Linguistics
   4. D. Structured Question Logic
   5. E. Sequenced Query Language

2. CRUD Operations

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

   1. A. CREATE
   2. B. UPDATE
   3. C. INSERT
   4. D. DELETE
   5. E. SELECT

3. SQL Operators

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

   1. A. LIKE
   2. B. IN
   3. C. EQUALS
   4. D. BETWEEN
   5. E. COMPARE

4. Aggregation Functions u0026 Constraints

   Which SQL aggregate function calculates the average value of a numeric column?

   1. A. COUNT
   2. B. SUM
   3. C. AVG
   4. D. MIN
   5. E. MAX

5. Joins u0026 Functions

   What type of SQL join returns all rows from the left table and matching rows from the right table?

   1. A. INNER JOIN
   2. B. RIGHT JOIN
   3. C. FULL OUTER JOIN
   4. D. LEFT JOIN
   5. E. CROSS JOIN

6. Indexes u0026 Transactions

   What is the purpose of an index in a SQL database?

   1. A. To enforce data integrity
   2. B. To speed up data retrieval
   3. C. To store metadata
   4. D. To define relationships between tables
   5. E. To compress data

7. Query-Based Questions

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

   1. A. GROUP BY
   2. B. SORT BY
   3. C. ORDER BY
   4. D. ARRANGE
   5. E. CLASSIFY

8. SQL Basics

   Which SQL command is used to modify existing data in a database table?

   1. A. INSERT
   2. B. MODIFY
   3. C. UPDATE
   4. D. ALTER
   5. E. CHANGE

9. CRUD Operations

   What does the acronym 'CRUD' stand for in database operations?

   1. A. Create, Read, Update, Delete
   2. B. Compile, Run, Upload, Download
   3. C. Connect, Retrieve, Upgrade, Disconnect
   4. D. Control, Revise, Undo, Deploy
   5. E. Collect, Register, Utilize, Distribute

10. SQL Operators

    Which operator is used to compare a value to a list of specified values?

    1. A. EQUALS
    2. B. LIKE
    3. C. BETWEEN
    4. D. IN
    5. E. WITHIN

11. Aggregation Functions u0026 Constraints

    Which constraint prevents duplicate values in a column?

    1. A. NOT NULL
    2. B. PRIMARY KEY
    3. C. FOREIGN KEY
    4. D. UNIQUE
    5. E. CHECK

12. Joins u0026 Functions

    Which SQL join returns only rows where there is a match in both tables?

    1. A. LEFT JOIN
    2. B. RIGHT JOIN
    3. C. FULL OUTER JOIN
    4. D. INNER JOIN
    5. E. CROSS JOIN

13. Indexes u0026 Transactions

    What does ACID stand for with respect to database transactions?

    1. A. Atomicity, Consistency, Isolation, Durability
    2. B. Accuracy, Completeness, Integrity, Dependability
    3. C. Application, Control, Interface, Design
    4. D. Access, Correction, Information, Distribution
    5. E. Authentication, Creation, Identification, Deletion

14. Query-Based Questions

    Which SQL clause is used to filter data after grouping?

    1. A. WHERE
    2. B. GROUP BY
    3. C. ORDER BY
    4. D. HAVING
    5. E. FILTER

15. SQL Basics

    Which SQL command is used to remove a table from a database?

    1. A. DELETE TABLE
    2. B. REMOVE TABLE
    3. C. DROP TABLE
    4. D. ERASE TABLE
    5. E. KILL TABLE