Top 2
Prep plan
Updated weekly · Last refresh Sep 24Morgan Stanley Consultant Interview Questions
The questions to prepare for a Morgan Stanley Consultant interview. Questions from real interview reports rank first. Updated daily.
2questions
~1htotal time
Track your progressSign up free to work through all 2 questions and resume where you left off.
Start practicing free →1
SQL & Data ManipulationStart here. 1 question + 3 drills · ~38 min
SQL Window Functions and DedupingHard
Assesses SQL window function knowledge and ability to produce correct rankings.
Data Analysissql queries
Morgan Stanley
Morgan StanleySQL IndexingHard
Practice
Recently asked
Practice drillUse a representative PostgreSQL query to evaluate indexing choices for active accounts and recent trade orders.
database optimizationlarge datasetsindexesMorgan Stanley
Morgan StanleyImmutable Class and CollectionsEasy
Practice
Recently asked
Practice drillUse SQL joins and aggregation to return Java immutability rules alongside LinkedList and ArrayList differences.
database managementdata managementsqlMorgan Stanley
Morgan StanleyTop Clients by Region SQLMedium
Practice
Practice drillFind the top three spending clients in each region during the previous calendar quarter.
Window FunctionsDate Functionsfinancial dataMorgan Stanley
Morgan Stanley2
Behavioral & Leadership1 question · ~8 min
Tell Me About YourselfEasy
Recently asked
Tests concise self-positioning, relevant achievement selection, communication, and ownership of career direction.
achievementbackgroundpersonal backgroundMorgan Stanley
Morgan StanleySign up to see every question
Create a free account to unlock this list and practice real interview questions.
The finish line: interview-readyComplete all 2 questions plus 3 hands-on drills to finish this plan.