Ace Your SQL Interviews: Easy Questions for Beginners Quiz

1. Understanding SQL Keywords

   Which SQL keyword is used to retrieve data from a database table? For example, to view all records in a table named 'students'.

   1. A. SELECT
   2. B. CHOOSE
   3. C. EXTRACT
   4. D. COLLECT
   5. E. SLECT

2. Filtering Results

   In SQL, which clause would you use to specify a condition so that only rows meeting certain criteria are shown? For example, finding all employees with salary greater than 50000.

   1. A. WHO
   2. B. WHERE
   3. C. WARE
   4. D. WHEN
   5. E. WIHERE

3. Sorting Query Output

   What clause helps you sort the results of a query in ascending or descending order? For example, arranging product prices from lowest to highest.

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

4. Combining Conditions

   If you want both conditions to be true in a SQL query, which operator should you use? For example, retrieving users who are older than 18 AND active.

   1. A. AND
   2. B. OR
   3. C. NOT
   4. D. BAND
   5. E. END

5. Updating Data

   Which SQL command allows you to change existing values in a table? For example, increasing a user's score by 10 points.

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