1. What is a database?
2. Define DBMS (Database Management System).
3. What are the primary functions of a DBMS?
4. Explain the difference between a database and a DBMS.
5. What are the different types of DBMS?
6. Describe the hierarchical database model.
7. What is the relational database model?
8. Explain the concept of a flat-file database.
9. What is normalization in databases?
10. What are primary keys in a database?
11. Define foreign keys.
12. What is a composite key?
13. Explain the concept of a relationship in databases.
14. What are the different types of relationships in a database?
15. What is a one-to-one relationship?
16. Define one-to-many relationships.
17. Explain many-to-many relationships.
18. What is a database schema?
19. Describe the purpose of an entity-relationship diagram (ERD).
20. What is SQL (Structured Query Language)?
21. What are DDL (Data Definition Language) commands?
22. What are DML (Data Manipulation Language) commands?
23. Explain the purpose of DCL (Data Control Language).
24. What is the difference between DELETE and TRUNCATE in SQL?
25. What are indexes in a database?
26. Why are indexes important in databases?
27. Explain the concept of a stored procedure.
28. What is a trigger in a database?
29. What is data integrity?
30. Describe the types of data integrity.
31. What is referential integrity?
32. What are constraints in a database?
33. Explain the purpose of the UNIQUE constraint.
34. What is the NOT NULL constraint?
35. What is the CHECK constraint?
36. What is a view in a database?
37. Explain the difference between a view and a table.
38. What is the purpose of a materialized view?
39. What is data redundancy?
40. Why is data normalization important?