SQL Rapid Fire Quiz Presentation

Introduction

Welcome to the SQL rapid fire quiz presentation. This session includes 20 SQL-related questions designed to test your knowledge. The answers to these questions will vary in complexity, affecting the time allocated for each. Participants are encouraged to keep track of their scores and share them in the comments section at the end.

Questions and Answers

1. Which language deals with the structure/schema of a table?

   • Answer: DDL (Data Definition Language)

2. Which of the following is incorrect about DELETE?

   • Answer: DELETE is a DML command that doesn't remove the table from memory.

3. How many columns are created in the given SQL DDL command?

   • Answer: 4 (ID, name, department name, salary)

4. What would be the query to get a specific output from the employee table?

   • Answer: SELECT COUNT(ID), city FROM employee GROUP BY city

5. How many rows would be in the output given certain salary conditions?

   • Answer: 2 (salaries between 40,000 and 50,000)

6. Appropriate data type for date of birth in a schema?

   • Answer: None of the above (correct type is DATE)

7. Which command deletes all rows but retains memory allocation?

   • Answer: TRUNCATE

8. Command for purging all table rows while retaining structure?

   • Answer: TRUNCATE

9. SQL statement for returning only different values?

   • Answer: DISTINCT

10. SQL constraint for ensuring city value is one of four options?

    • Answer: CHECK

11. Which constraint satisfies both unique and not null?

    • Answer: Primary Key

12. Appropriate SQL constraint for defaults in discounts?

    • Answer: DEFAULT

13. Appropriate default constraint in an attribute list?

    • Answer: City in a local school

14. Is using UNIQUE over PRIMARY KEY for student ID correct?

    • Answer: Incorrect

15. Identify the foreign key in the table scenario?

    • Answer: Department Code

16. How many rows in the output for a count query?

    • Answer: 4

17. Correct query for granting update privileges?

    • Answer: UPDATE student SET ID = 100 WHERE name = 'P Sony'

18. Salary value for the first row when sorting in descending order?

    • Answer: 68,000

19. Output row count for cities ending with 'I'?

    • Answer: 4

20. How many rows remain excluding certain cities?

    • Answer: 5

Conclusion

Thank you for participating in the SQL rapid fire quiz. Please share how many answers you got correct in the comments section. We hope this session was informative and look forward to seeing you in the next presentation.