1. Which SQL keyword is used to retrieve data from a database?

2. Which clause is used to filter records in a SQL query?

3. Which SQL command is used to remove an existing table from a database?

4. Which SQL function returns the number of rows in a table?

5. In the context of transactions, what does ACID stand for?

6. Which normal form is achieved when a table has no repeating groups?

7. Partial dependency is eliminated in which normal form?

8. Transitive dependency is removed in which normal form?

9. What is a primary key in a relational database?

10. What is a foreign key?

11. Which SQL command is used to modify existing records in a table?

12. Which SQL command is used to insert new records into a table?

13. Which operator is used in SQL to combine two conditions?

14. What is the purpose of the GROUP BY clause in SQL?

15. Which clause is used to filter aggregated results in SQL?

16. What is a view in SQL?

17. Which type of join returns all records when there is a match in either the left or right table?

18. Which join returns only the rows with matching values in both tables?

19. What does the SQL keyword DISTINCT do?

20. In DBMS, what is a transaction?

21. Which transaction property ensures that the transaction is treated as a single unit, so that if one part fails the entire transaction is rolled back?

22. Which property of transactions ensures that concurrent transactions do not interfere with each other?

23. Which SQL command is used to create a new table in a database?

24. Which SQL command is used to modify the structure of an existing table?

25. Which type of index is most commonly used in DBMS?

26. What does SQL injection refer to?

27. What is the primary purpose of normalization in databases?

28. Which SQL keyword is used to combine the results of two SELECT statements?

29. Which clause is used to sort the result set in SQL?

30. What is denormalization in the context of databases?