PL/SQL & T-SQL (Oracle and SQL Server)
PL/SQL & T-SQL (Oracle and SQL Server) interview questions
Interview questions, module by module: what each bank covers, how many questions it holds and the experience levels they are asked at.
-
Module 1
Start here: two engines, versions and a verified lab
8 questions: 3 warm-ups and 5 with model answers · Levels: Fresher to staff
-
Module 2
T-SQL foundations: batches, variables and routines
12 questions: 4 warm-ups and 8 with model answers · Levels: Fresher to staff
-
Module 3
T-SQL errors and transactions
9 questions: 3 warm-ups and 6 with model answers · Levels: Fresher to staff
-
Module 4
Working with sets: temporary tables, MERGE and cursors
12 questions: 4 warm-ups and 8 with model answers · Levels: Fresher to senior
-
Module 5
Window functions in T-SQL
7 questions: 3 warm-ups and 4 with model answers · Levels: Fresher to staff
-
Module 6
Dynamic SQL and triggers in T-SQL
8 questions: 3 warm-ups and 5 with model answers · Levels: Fresher to staff
-
Module 7
Execution plans and performance in SQL Server
8 questions: 3 warm-ups and 5 with model answers · Levels: Fresher to staff
-
Module 8
Production T-SQL: concurrency, security, new features and tests
18 questions: 3 warm-ups and 15 with model answers · Levels: Fresher to staff
-
Module 9
PL/SQL foundations: blocks, types, SQL and exceptions
16 questions: 5 warm-ups and 11 with model answers · Levels: Fresher to staff
-
Module 10
Cursors, collections and bulk processing
16 questions: 5 warm-ups and 11 with model answers · Levels: Fresher to staff
-
Module 11
Subprograms, packages and robust error logging
16 questions: 5 warm-ups and 11 with model answers · Levels: Fresher to staff
-
Module 12
Triggers in Oracle
8 questions: 3 warm-ups and 5 with model answers · Levels: Fresher to staff
-
Module 13
Dynamic SQL and security in PL/SQL
7 questions: 2 warm-ups and 5 with model answers · Levels: Fresher to staff
-
Module 14
Performance: plans, PL/SQL called from SQL and table functions
11 questions: 3 warm-ups and 8 with model answers · Levels: Fresher to staff
-
Module 15
Production PL/SQL: staging, concurrency, JSON and tests
19 questions: 5 warm-ups and 14 with model answers · Levels: Fresher to staff
-
Module 16
Across both engines: porting and concurrency
8 questions: 3 warm-ups and 5 with model answers · Levels: Fresher to staff