Connect with fellow learners in the PlacePrep Discord communityㆍ Join now →

R's PlacePrep

Popular drives

TCSNQT (National Qualifier Test)InfosysIRT (InfyTQ Recruitment Test)AccentureCognitive & Technical Assessment

Also hiring

WiproNLTH (National Level Talent Hunt)CognizantGenC Assessment CapgeminiGame-Based Assessment

Browse all 14 companies TCS NQT 2026

Real placement papers from the drives you are actually sitting for

14 companies · 48 papersStart practising

Select your branch

Computer Science & EngineeringBEU previous year papers and solutions Mechanical EngineeringBEU previous year papers and solutions Electrical & Electronics EngineeringBEU previous year papers and solutions

More branches

Civil EngineeringBEU previous year papers and solutions Aeronautical EngineeringBEU previous year papers and solutions

All branches Computer Science

Previous year questions

University papers, sorted by subject and year with worked solutions

BEU Solved PapersOpen the archive

Core CS

Data Structures & AlgorithmsComplexity analysis up to graphs and DP.Operating SystemsProcesses, scheduling, memory and concurrency.Database Management SystemsRelational modelling, transactions and indexing.Computer NetworksFrom wires and radio waves up to the web.

Learn & scale

AI Inference EngineeringQuantization, batching and KV caching in production.System DesignScalable systems from first principles.Context EngineeringDesigning the context that LLMs actually reason over.Docker & KubernetesContainers and orchestration, explained.

All 15 courses Authors

Structured courses that start at zero and end somewhere useful

15 courses · free foreverBrowse courses

Companies PYQ Learn

Database Management Systems

Foundations of DBMS6

Relational Model, Algebra & Calculus6

Integrity Constraints & Normal Forms6

File Organization & Indexing7

Transactions & Concurrency Control9

Query Processing, Optimization & Distributed DBs5

Query processing and join algorithms
Query optimization and execution plans
Distributed databases: fragmentation and replication
Two-phase commit and distributed transactions
The CAP theorem and distributed consistency trade-offs

Lessons

Contribute, invite only

Database Management Systems

Foundations of DBMS6

Relational Model, Algebra & Calculus6

Integrity Constraints & Normal Forms6

File Organization & Indexing7

Transactions & Concurrency Control9

Query Processing, Optimization & Distributed DBs5

Query processing and join algorithms
Query optimization and execution plans
Distributed databases: fragmentation and replication
Two-phase commit and distributed transactions
The CAP theorem and distributed consistency trade-offs

Learn Database Management Systems Query Processing, Optimization & Distributed DBs

Contribute, invite only

Query optimization and execution plans

Heuristic (rule-based) optimization, cost-based optimization using statistics and selectivity, and how to actually read an EXPLAIN plan.

9 min readUpdated 2026-09-04dbmsquery-optimizationexplain