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

SQL DDL: creating tables and choosing data types
SQL DML: INSERT, UPDATE, and DELETE
SELECT, filtering, and sorting in depth
Aggregation and grouping
SQL joins in practice
Subqueries and set operations
Window functions and common table expressions
Views, constraints, and triggers

Integrity Constraints & Normal Forms6

File Organization & Indexing7

Transactions & Concurrency Control9

Query Processing, Optimization & Distributed DBs5

Lessons

Contribute, invite only

Database Management Systems

Foundations of DBMS6

Relational Model, Algebra & Calculus6

SQL DDL: creating tables and choosing data types
SQL DML: INSERT, UPDATE, and DELETE
SELECT, filtering, and sorting in depth
Aggregation and grouping
SQL joins in practice
Subqueries and set operations
Window functions and common table expressions
Views, constraints, and triggers

Integrity Constraints & Normal Forms6

File Organization & Indexing7

Transactions & Concurrency Control9

Query Processing, Optimization & Distributed DBs5

Learn Database Management Systems SQL Deep Dive

Contribute, invite only

Aggregation and grouping

COUNT, SUM, AVG, MIN, MAX, GROUP BY, and the crucial difference between filtering rows with WHERE and filtering groups with HAVING.

8 min readUpdated 2026-09-03dbmssqlaggregationgroup-by