1. What is a Database? Beginner 2. What is a Database Management System (DBMS)? Beginner 3. What are the main advantages of using a DBMS? Beginner 4. Why do we need DBMS? Beginner 5. What is the difference between DBMS and file system? Intermediate 6. What are the different types of DBMS? Beginner 7. What is a database instance? Intermediate 8. What is a data dictionary? Intermediate 9. What is Database Admin & its Functions? Beginner 10. What is the role of a Database Administrator (DBA)? Beginner 11. What is RDBMS? Beginner 12. What is the difference between DBMS and RDBMS? Intermediate 13. How is RDBMS stored in memory? Advanced 14. What is the meaning of 'Relational' in RDBMS? Beginner 15. What are the different types of relationships in databases? Beginner 16. What is Degree of Relation (1:1, 1:M, M:M)? Beginner 17. What is Database Tier-2/Tier-3 Architecture? Intermediate 18. What is Data abstraction in DBMS? Intermediate 19. What are the three levels of data abstraction? Intermediate 20. What is the difference between logical and physical database design? Intermediate 21. What is Instance, Schema, and Sub-Schema? Intermediate 22. What are Database Languages (DDL, DML, DCL, TCL)? Beginner 23. What is SQL and why is it important? Beginner 24. What are the different types of SQL commands? Beginner 25. What is the difference between SQL and MySQL? Beginner 26. What is a Primary Key? Beginner 27. What is a Foreign Key? Beginner 28. What is a candidate key? Intermediate 29. What is an Alternate key? Intermediate 30. What is a Super Key? Intermediate 31. What is a Composite key? Intermediate 32. What is a Secondary Key? Intermediate 33. What is the difference between primary key and unique key? Intermediate 34. What is a UNIQUE Key? Beginner 35. What is the difference between Primary Key and UNIQUE Key? Intermediate 36. What are constraints in DBMS? Beginner 37. What is referential integrity? Intermediate 38. What is Referential Integrity Rule in RDBMS? Intermediate 39. What is NOT NULL constraint? Beginner 40. What is Default Constraint? Beginner 41. What are aggregate constraints? Advanced 42. What is a foreign key constraint action? Intermediate 43. What is a database schema? Beginner 44. What is Database Schema (Physical vs Logical)? Intermediate 45. What are Schema Diagrams? Beginner 46. What is an Entity-Relationship (ER) diagram? Beginner 47. What is the difference between entity and attribute? Beginner 48. What is a weak entity set? Intermediate 49. What is ER to Relational Model conversion? Intermediate 50. What are the best practices for database design? Intermediate 51. What is normalization and why is it important? Intermediate 52. What is the purpose of Normalization? Beginner 53. What are 3 anomalies resolved by normalization? Intermediate 54. What is First Normal Form (1NF)? Beginner 55. What is Second Normal Form (2NF)? Intermediate 56. What is Third Normal Form (3NF)? Intermediate 57. What is Boyce-Codd Normal Form (BCNF)? Advanced 58. What is denormalization and when is it used? Intermediate 59. What is Denormalization? Intermediate 60. What is database normalization and its objectives? Beginner 61. What is functional dependency? Intermediate 62. What is Functional Dependency and its types? Intermediate 63. What is Trivial Functional Dependency? Intermediate 64. What is Non-Trivial Functional Dependency? Intermediate 65. What is Fully-Functional Dependency? Intermediate 66. What is Partial Functional Dependency? Intermediate 67. What is Transitive Dependency? Intermediate 68. What is an index and how does it work? Intermediate 69. What is Index in DBMS & its types? Intermediate 70. What is Indexing in SQL? Beginner 71. What is the difference between clustered and non-clustered index? Intermediate 72. What is a Clustered Index? Intermediate 73. What is a Non-Clustered Index? Intermediate 74. What is the difference between Clustered and Non-Clustered Index? Intermediate 75. What is a B-tree index? Advanced 76. What is the difference between B-tree and B+ tree? Advanced 77. What is a bitmap index? Advanced 78. What is a composite index? Intermediate 79. What is a covering index? Advanced 80. What is hashing in DBMS? Advanced 81. What is Index Fragmentation? Advanced 82. What are Joins in SQL? Beginner 83. What are the different types of joins in SQL? Beginner 84. What is INNER JOIN? Beginner 85. What is LEFT JOIN? Beginner 86. What is RIGHT JOIN? Beginner 87. What is FULL JOIN? Intermediate 88. What is Self Join? Intermediate 89. What is Cross Join? Intermediate 90. What is the difference between INNER JOIN and OUTER JOIN? Intermediate 91. What is the difference between WHERE and HAVING clause? Intermediate 92. What is the HAVING clause and when is it used? Intermediate 93. What is GROUP BY in SQL? Beginner 94. What is the difference between Group By and Order By? Beginner 95. What is the use of LIMIT in SQL? Beginner 96. What is UNION and UNION ALL? Intermediate 97. What is the difference between UNION and UNION ALL? Intermediate 98. What is the difference between IN and EXISTS? Advanced 99. What is the use of EXISTS in SQL? Intermediate 100. What is a subquery in SQL? Intermediate 101. What is Subquery? Beginner 102. What is Nested Query? Beginner 103. What is Correlated Subquery? Advanced 104. What is a correlated subquery? Advanced 105. What is a View in DBMS? Intermediate 106. What is View in SQL? Beginner 107. What is the difference between View and Table? Intermediate 108. What is a materialized view? Advanced 109. What is the difference between view and materialized view? Advanced 110. What is a stored procedure? Intermediate 111. What is Stored Procedure? Beginner 112. What is the difference between Function and Stored Procedure? Intermediate 113. What is the Difference Between Stored Procedure and Function in SQL? Intermediate 114. What is a stored function? Beginner 115. What is a trigger in DBMS? Intermediate 116. What is Trigger in SQL? Beginner 117. What is the difference between a trigger and stored procedure? Intermediate 118. What is a database trigger use case? Intermediate 119. What is a Cursor? Intermediate 120. What is a database cursor? Intermediate 121. What is a transaction in DBMS? Beginner 122. What is a Transaction? Beginner 123. What is a Transaction in SQL? Beginner 124. What are ACID properties in DBMS? Intermediate 125. What is the ACID Property in SQL? Intermediate 126. How to implement Atomicity in Transactions? Advanced 127. What is the function of the Atomicity property? Intermediate 128. What is the difference between COMMIT and ROLLBACK? Beginner 129. What is the difference between COMMIT and ROLLBACK in SQL? Beginner 130. What is Savepoint in SQL? Intermediate 131. What is a savepoint? Intermediate 132. What are the important terms in Transaction Management (Commit, Rollback, Savepoint)? Beginner 133. What is Concurrent Transaction? Intermediate 134. What is concurrency control in DBMS? Intermediate 135. What are the problems of Concurrent transactions? Advanced 136. What are the advantages of Concurrent transactions? Intermediate 137. What is Conflict Operation in Schedules? Advanced 138. What are the different types of Schedules (Serial, Complete, Recoverable, Cascadeless, Strict)? Advanced 139. What is 2-Phase Locking Protocol? Advanced 140. What are the different types of database locks? Intermediate 141. What is locking and its types? Intermediate 142. What is the difference between shared and exclusive locks? Intermediate 143. What is Shared Lock? Beginner 144. What is Exclusive Lock? Beginner 145. What is two-phase locking? Advanced 146. What is a deadlock in DBMS? Intermediate 147. How to Prevent Deadlock (Mutual Exclusion, Hold and Wait, No PreEmption, Circular wait)? Advanced 148. What are other Techniques to prevent Deadlock (Timestamp based)? Advanced 149. What is Wait-Die Scheme? Advanced 150. What is Wound-Wait Scheme? Advanced 151. What is Timeout Based Scheme? Intermediate 152. What is Starvation and its reason? Advanced 153. What is Deadlock Recovery? Advanced 154. How to Avoid Deadlocks in SQL? Intermediate 155. What is Storage System in DBMS? Intermediate 156. What is File Structure in DBMS? Intermediate 157. What is the difference between DELETE and TRUNCATE? Intermediate 158. What is the difference between DELETE, TRUNCATE, and DROP? Intermediate 159. What is the difference between Drop, Delete, and Truncate? Beginner 160. What is the disadvantage of the DROP TABLE command? Beginner 161. What is the difference between DROP and TRUNCATE? Intermediate 162. What is CTE (Common Table Expression)? Intermediate 163. What is a Common Table Expression (CTE)? Intermediate 164. What is Temporary Table in SQL? Intermediate 165. What are temporary tables? Beginner 166. What is the difference between Temporary Table and CTE? Advanced 167. What is Window Function in SQL? Advanced 168. What is a window function in SQL? Advanced 169. What is the difference between ROW_NUMBER(), RANK(), and DENSE_RANK()? Advanced 170. What is CASE Statement in SQL? Intermediate 171. What is the CASE statement in SQL? Beginner 172. What is COALESCE in SQL? Intermediate 173. What is NVL Function in SQL? Intermediate 174. What is query optimization? Advanced 175. What is Query Optimization? Advanced 176. How to Optimize SQL Queries? Advanced 177. What is Query Execution Plan? Advanced 178. How to Improve Query Performance? Intermediate 179. What is data warehousing? Intermediate 180. What is the difference between OLTP and OLAP? Intermediate 181. What is a data mart? Intermediate 182. What is data mining? Intermediate 183. What is ETL in data warehousing? Intermediate 184. What is database partitioning? Intermediate 185. What is Table Partitioning? Intermediate 186. What is database sharding? Advanced 187. What are the different types of backup strategies? Intermediate 188. What is database recovery and its types? Advanced 189. What is a checkpoint in DBMS? Advanced 190. What is a transaction log? Intermediate 191. What is SQL injection and how to prevent it? Intermediate 192. What are SQL Privileges? Beginner 193. What is data redundancy and how to reduce it? Beginner 194. What is data independence? Intermediate 195. What is database mirroring? Intermediate 196. What is database replication? Intermediate 197. What is database cache? Intermediate 198. What is a timestamp in DBMS? Intermediate 199. What is serializability? Advanced 200. What is SQL vs NoSQL? Intermediate 201. What is the difference between SQL and NoSQL? Intermediate 202. Which Modern Database Is Right for Your Use Case? Intermediate 203. What is CAP theorem? Advanced 204. What is the difference between ACID and BASE? Advanced 205. What is In-memory Database? Intermediate 206. What is Graph Database? Intermediate 207. What are Scaling Patterns? Advanced 208. What is Scaling RDBMS and NoSQL? Advanced 209. What is Master-Slave Architecture? Intermediate 210. What is Master-Slave vs Master-Master? Advanced