What is SQL?Junior
What is a database?Junior
Differentiate between RDBMS and DBMS.Junior
What are tables and fields in SQL?Junior
What is a primary key in SQL?Junior
What is a foreign key?Junior
What is a unique key in SQL?Junior
Explain the ACID properties in the context of database transactions.Junior
What are the different types of SQL commands?Junior
What is the difference between SQL and MySQL?Junior
Explain the difference between SQL and NoSQL databases.Junior
What is a JOIN in SQL, and what are its types?Junior
What is a view in SQL?Mid
What is an index in SQL, and why is it used?Mid
Explain the difference between clustered and non-clustered indexes.Mid
What is the difference between BETWEEN and IN operators in SQL?Mid
What is the difference between DELETE and TRUNCATE commands?Mid
What are constraints in SQL, and name a few?Mid
What are aggregate functions in SQL? Can you name a few?Mid
Explain SQL normalization and denormalization.Mid
What is a subquery in SQL?Mid
What is SQL injection, and how can you prevent it?Mid
Explain ORDER BY in SQL.Mid
Explain the difference between the GROUP BY and HAVING clauses in SQL.Mid
What is the difference between WHERE and HAVING clauses?Mid
Explain the MERGE statement.Mid
Explain the difference between the SQL commands DELETE and TRUNCATE.Mid
What is a stored procedure in SQL?Mid
What is a trigger in SQL?Mid
Explain database sharding and its benefits in managing large-scale databases.Mid
What is a cursor, and when would you use it?Mid
What are Common Table Expressions (CTEs)?Mid
Explain SQL deadlock and provide strategies for preventing and resolving deadlocks in database systems.Mid
What is the purpose of the SQL LIKE operator, and how can wildcards be used with it?Mid
What are transactions in SQL?Mid
Differentiate between commit, checkpoint, and rollback.Mid
What is a pivot table in SQL?Mid
How do you implement error handling in SQL?Mid
Explain the SQL concept of NULL.Mid
What is Write-Ahead Logging (WAL)?Senior
How do you optimize SQL queries?Senior
Explain database replication, its use cases, and its types.Senior
Explain the difference between a database index and a database view.Senior
What is SQL concurrency control?Senior
Explain SQL partitioning.Senior
Explain SQL materialized views.Senior
Explain SQL transaction isolation levels.Senior
What do you understand by multi-version concurrency control?Senior
What is SQL query caching and how does it improve database performance?Senior
What are windowing functions, and how are they different from aggregate functions?Senior
What are the best practices for securing a SQL database?Senior
Name some strategies for database backup and recovery.Senior
How do you handle transactions in distributed databases?Senior
What is the difference between OLTP and OLAP systems?Senior