LearnFrenzy
Sign in Take a free test

Technical interview

Database Management Interview Questions

DBMS and SQL interview questions for freshers: keys, normalisation, ACID, joins, indexes and common SQL queries with answers.

  • 9 question sets
  • 0 completed
  • Code + follow-ups

DBMS Interview Questions

  1. 01 DBMS and SQL BasicsDBMS and SQL interview questions: DBMS vs RDBMS, keys, normalisation, ACID, joins, DELETE vs TRUNCATE vs DROP,… Done

SQL and Database Internals

  1. 02 SQL Queries Asked in InterviewsSQL query interview questions with answers: Nth highest salary, duplicates, self joins, GROUP BY and HAVING, window… Done
  2. 03 Transactions, ACID and Isolation LevelsDBMS transaction interview questions: ACID, commit and rollback, dirty reads, non-repeatable reads, phantoms,… Done
  3. 04 Indexing and Query OptimisationSQL indexing interview questions: B-tree and clustered indexes, composite and covering indexes, EXPLAIN plans,… Done
  4. 05 NoSQL and MongoDBNoSQL and MongoDB interview questions: SQL vs NoSQL, CAP theorem, schema design, aggregation pipeline, indexes,… Done

DBMS Concepts and Design

  1. 06 Normalisation and ER ModellingNormalisation and ER modelling interview questions: ER diagrams, cardinality, functional dependencies, 1NF to… Done
  2. 07 Views, Stored Procedures, Triggers and SQL SecurityDBMS interview questions on views and materialised views, stored procedures vs functions, triggers, cursors, SQL… Done

SQL Coding and Tricky Practice

  1. 08 Advanced SQL Coding QuestionsAdvanced SQL coding questions with solutions: consecutive days, month-over-month growth, median, recursive org… Done
  2. 09 SQL Tricky and Output-Based QuestionsTricky SQL output questions explained: NULL comparisons, COUNT(*) vs COUNT(col), NOT IN with NULL, LEFT JOIN filters,… Done

More tracks

Other technical subjects

Search LearnFrenzy

Esc

Quick links