Ace the Basics: 10 Essential SQL Interview Questions Quiz

1. Identifying SQL Statement Types

   Which SQL statement is used to retrieve data from a database table, for example, finding the list of all employees in a company?

   1. A. SELECT
   2. B. INSERT
   3. C. UPDATE
   4. D. REMVOE
   5. E. CREAT

2. Understanding Joins

   If you want to return all rows from the left table and only the matching rows from the right table, which type of join should you use in SQL?

   1. A. LEFT JOIN
   2. B. RIGHT JOIN
   3. C. INNER JION
   4. D. SPIKE JOIN
   5. E. RANDOM JOIN

3. SQL Syntax

   What keyword completes a SQL query that counts the total number of records in a table, such as 'SELECT COUNT(*) FROM students;'?

   1. A. COUNT
   2. B. TOTAL
   3. C. SUMM
   4. D. NUMBER
   5. E. COUNTS

4. Filtering Records

   Which SQL clause is used to filter records in a SELECT query, for example, showing only customers from a specific city?

   1. A. WHERE
   2. B. HAVNING
   3. C. ORDER
   4. D. FILTERS
   5. E. GROUP

5. Updating Data

   Suppose you want to change a user's email address in a table. Which SQL statement is typically used for this purpose?

   1. A. UPDATE
   2. B. INSERT
   3. C. ALTER
   4. D. REPLACE
   5. E. UDATE

6. Sorting Results

   What clause should be used to sort the results of a SELECT statement in ascending or descending order, such as alphabetical order of last names?

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

7. Grouping Data

   Which SQL clause groups rows that have the same values into summary rows, such as the total number of orders by each customer?

   1. A. GROUP BY
   2. B. BUNDLE
   3. C. WITH
   4. D. GORUP BY
   5. E. TOGETHER

8. Primary Key Concept

   What is the name for a field or set of fields in a table that uniquely identifies each row, such as a student ID in a student records table?

   1. A. Primary Key
   2. B. Foreign Key
   3. C. Index
   4. D. Unique Row
   5. E. Perimary Key

9. Aggregate Functions

   Which function would you use to find the average score in a 'grades' column of a database table?

   1. A. AVG
   2. B. MEAN
   3. C. MID
   4. D. AVRG
   5. E. SUMA

10. Removing Records

    If you wish to delete one or more rows from a table where a certain condition is met, which SQL command should you use?

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