MySQL Skills Audio Quiz: Test Your Practical Knowledge! Quiz

1. Identifying SQL Functions

   Which MySQL function is used to return the largest value from a set of arguments?

   1. GREATEST()
   2. MAXUMUM()
   3. HIGHEST()
   4. MOST()
   5. LARGER()

2. Selecting Minimum Values

   Which function would you use in MySQL to get the smallest number from a list of values?

   1. LEAST()
   2. MINUM()
   3. LOWEST()
   4. SMALLEST()
   5. LESS()

3. Understanding SQL UPDATE

   What is the purpose of the UPDATE statement in MySQL?

   1. To modify existing records in a table
   2. To create a new table
   3. To remove duplicate records
   4. To fetch data from tables
   5. To change the structure of a table

4. SQL Operator Usage

   Which SQL keyword is used to ensure that a value never goes below zero in a calculation?

   1. GREATEST(value, 0)
   2. IFNULL(value, 0)
   3. MIN(value, 0)
   4. LEAST(value, 0)
   5. NULLIF(value, 0)

5. Column Reference Precision

   In SQL, how do you refer to the value of the column free_sant_quartz within an UPDATE statement for the same table?

   1. By using free_sant_quartz directly
   2. By prefixing with update.free_sant_quartz
   3. By enclosing in quotes 'free_sant_quartz'
   4. By referencing as player.free_sant_quartz within the statement
   5. By using #free_sant_quartz

6. MySQL Data Types

   If columns free_sant_quartz and paid_sant_quartz store whole numbers only, which data type is best to use?

   1. INT
   2. VARCHAR
   3. FLOAT
   4. DATETIME
   5. CHAR

7. SQL Subtraction Scenario

   If a player has 15 free stones and 20 paid stones, and pays 30 stones, how many paid stones should remain after the transaction, following the specified rules?

   1. 5
   2. 10
   3. 20
   4. 0
   5. 15

8. Previewing Changes Without Updating

   Which SQL statement lets you see the result of a calculation without actually modifying the table data?

   1. SELECT
   2. UPDATE
   3. MODIFY
   4. ALTER
   5. SHOW

9. Combining Multiple Columns

   Which of the following computes the new value of paid_sant_quartz, using a deduction covered by free_sant_quartz first, then paid_sant_quartz?

   1. paid_sant_quartz + LEAST(free_sant_quartz - 30, 0)
   2. paid_sant_quartz - LEAST(free_sant_quartz, 30)
   3. paid_sant_quartz - LEAST(free_sant_quartz - 30, 0)
   4. paid_sant_quartz - GREATEST(free_sant_quartz, 30)
   5. paid_sant_quartz

10. Ensuring Atomic Operations

    Why is it important to use a single UPDATE statement when decreasing free_sant_quartz and paid_sant_quartz during a transaction?

    1. To ensure data consistency and prevent incorrect deductions
    2. Because UPDATE statements must always be singular
    3. So that you can SELECT data afterwards
    4. To make the query faster by using JOINs
    5. Because multiple UPDATEs are not allowed in SQL