SQL Summoning Stones: Easy Quiz on FGO u0026 Stone Management Quiz

1. Types of Saint Quartz in FGO

   In the game context, what are the two types of Saint Quartz stones a player can hold in FGO?

   1. A. Free and Paid Saint Quartz
   2. B. Red and Blue Saint Quartz
   3. C. Silver and Golden Quartz
   4. D. Special and Normal Quartz
   5. E. Daily and Weekly Quartz

2. Spending Priority for Summoning

   When a player summons in FGO, which type of Saint Quartz is spent first according to the game's rules?

   1. A. Paid Saint Quartz
   2. B. Free Saint Quartz
   3. C. A random mix of both
   4. D. Half from each type
   5. E. The type with the highest count

3. Summoning Cost Understanding

   How many Saint Quartz are required for one 10-time summon in FGO?

   1. A. 10
   2. B. 30
   3. C. 3
   4. D. 33
   5. E. 13

4. Result of Summoning with Sufficient Free Quartz

   If a player has 40 Free Saint Quartz and 20 Paid Saint Quartz and summons 10 times, how many Free Saint Quartz will remain after the summon?

   1. A. 0
   2. B. 20
   3. C. 10
   4. D. 30
   5. E. 40

5. Result of Summoning with Insufficient Free Quartz

   If a player has 15 Free Saint Quartz and 20 Paid Saint Quartz, how many Paid Saint Quartz will remain after a 10-time summon (costing 30 stones)?

   1. A. 5
   2. B. 0
   3. C. 10
   4. D. 20
   5. E. 15

6. SQL Table Structure

   Which columns does the example 'players' table contain for storing Saint Quartz stone counts?

   1. A. free_sant_quartz and paid_sant_quartz
   2. B. quartz_free and quartz_paid
   3. C. saint_quartz and total_quartz
   4. D. quartzType and quartzCount
   5. E. player_saint_quartz and player_paid_quartz

7. Function for Non-Negative Result

   Which MySQL function is used to ensure that the number of remaining Free Saint Quartz never goes below zero in the SQL statement?

   1. A. SMALLEST()
   2. B. GREATEST()
   3. C. LEASTS()
   4. D. MAXIMAL()
   5. E. HIGHEST()

8. Function for Capping Deductions

   In the MySQL solution, which function is used to cap the deduction from Paid Saint Quartz based on leftover Free Saint Quartz?

   1. A. MINIMUM()
   2. B. LEAST()
   3. C. TINIEST()
   4. D. LESS()
   5. E. LOWEST()

9. Variable Use in SQL

   Why is a temporary variable like @temp used in the SQL UPDATE statement for updating Saint Quartz stones?

   1. A. To store player ID
   2. B. To temporarily hold the subtraction result for accurate updates
   3. C. To count the number of players
   4. D. To enforce primary key constraints
   5. E. To reset the stone counts to zero

10. Condition for Allowing Summon

    What is the correct SQL WHERE clause condition to check before allowing a 10-time summon?

    1. A. free_sant_quartz u003E= 30
    2. B. paid_sant_quartz u003E= 30
    3. C. free_sant_quartz + paid_sant_quartz u003E= 30
    4. D. free_sant_quartz + paid_sant_quartz u003C= 30
    5. E. free_sant_quartz = paid_sant_quartz