DBMS
32 articles in this topic
SQL Queries for Placement Interviews: Second Highest Salary, Joins and GROUP BY Step by Step
SQL queries for placement interviews built step by step on one schema: second highest salary three approaches, joins with results shown, GROUP BY and HAVING.
DBMS Interview Questions for Freshers: Top 50 with Answers That Survive Follow-Ups
50 DBMS interview questions for freshers, grouped the way interviews actually run: keys, the normalization-to-BCNF-to-denormalization chain, SQL joins, transactions and isolation levels, and indexing, answered as chains so rote definitions become explanations.
IBPS SO IT Officer DBMS: the professional knowledge topics that matter
The DBMS core of the IBPS SO IT Officer Mains Professional Knowledge paper: the ER model, keys, normalization with a worked example, SQL essentials and transactions, and how each is tested.
B+ Trees and Database Indexing: why indexes are fast, with a worked insert
B+ trees and database indexing explained: dense vs sparse, primary clustering and secondary indexes, B-tree vs B+ tree, with a worked B+ tree insert example.
SQL Queries and Joins in DBMS: sublanguages, joins, and GROUP BY worked out
SQL queries and joins in DBMS: DDL DML DCL TCL sublanguages, SELECT and WHERE, inner and outer joins, GROUP BY with HAVING, plus a worked join example.
Transactions and concurrency control in DBMS: ACID, schedules, serializability
Transactions in DBMS explained: ACID properties, schedules, conflict serializability with a worked precedence graph, two-phase locking, and the exam angle.
Normalization in DBMS: 1NF to BCNF, with the exam angle
Normalization in DBMS explained: functional dependencies, the exact 1NF, 2NF, 3NF and BCNF rules, a worked decomposition of one relation, and 3NF vs BCNF.
DBMS Normalization Explained Simply (With the Questions That Test It)
Normalization confuses almost everyone the first time. Here is a plain-English walk from functional dependencies to BCNF, and the exact question patterns that test it.