SQL

0%
Coding
Theory

  • Differentiate between RDBMS and DBMS.

    Junior

  • Explain the ACID properties in the context of database transactions.

    Junior

  • Explain the difference between SQL and NoSQL databases.

    Junior

  • What are tables and fields in SQL?

    Junior

  • What are the different types of SQL commands?

    Junior

  • What is a database?

    Junior

  • What is a foreign key?

    Junior

  • What is a JOIN in SQL, and what are its types?

    Junior

  • What is a primary key in SQL?

    Junior

  • What is a unique key in SQL?

    Junior

  • What is SQL?

    Junior

  • What is the difference between SQL and MySQL?

    Junior

  • Differentiate between commit, checkpoint, and rollback.

    Mid

  • Explain database sharding and its benefits in managing large-scale databases.

    Mid

  • Explain ORDER BY in SQL.

    Mid

  • Explain SQL deadlock and provide strategies for preventing and resolving deadlocks in database systems.

    Mid

  • Explain SQL normalization and denormalization.

    Mid

  • Explain the difference between clustered and non-clustered indexes.

    Mid

  • Explain the difference between the GROUP BY and HAVING clauses in SQL.

    Mid

  • Explain the difference between the SQL commands DELETE and TRUNCATE.

    Mid

  • Explain the MERGE statement.

    Mid

  • Explain the SQL concept of NULL.

    Mid

  • How do you implement error handling in SQL?

    Mid

  • What are aggregate functions in SQL? Can you name a few?

    Mid

  • What are Common Table Expressions (CTEs)?

    Mid

  • What are constraints in SQL, and name a few?

    Mid

  • What are transactions in SQL?

    Mid

  • What is a cursor, and when would you use it?

    Mid

  • What is a pivot table in SQL?

    Mid

  • What is a stored procedure in SQL?

    Mid

  • What is a subquery in SQL?

    Mid

  • What is a trigger in SQL?

    Mid

  • What is a view in SQL?

    Mid

  • What is an index in SQL, and why is it used?

    Mid

  • What is SQL injection, and how can you prevent it?

    Mid

  • What is the difference between BETWEEN and IN operators in SQL?

    Mid

  • What is the difference between DELETE and TRUNCATE commands?

    Mid

  • What is the difference between WHERE and HAVING clauses?

    Mid

  • What is the purpose of the SQL LIKE operator, and how can wildcards be used with it?

    Mid

  • Explain database replication, its use cases, and its types.

    Senior

  • Explain SQL materialized views.

    Senior

  • Explain SQL partitioning.

    Senior

  • Explain SQL transaction isolation levels.

    Senior

  • Explain the difference between a database index and a database view.

    Senior

  • How do you handle transactions in distributed databases?

    Senior

  • How do you optimize SQL queries?

    Senior

  • Name some strategies for database backup and recovery.

    Senior

  • What are the best practices for securing a SQL database?

    Senior

  • What are windowing functions, and how are they different from aggregate functions?

    Senior

  • What do you understand by multi-version concurrency control?

    Senior

  • What is SQL concurrency control?

    Senior

  • What is SQL query caching and how does it improve database performance?

    Senior

  • What is the difference between OLTP and OLAP systems?

    Senior

  • What is Write-Ahead Logging (WAL)?

    Senior