MSCI is formerly known as Morgan Stanley Capital International.
MSCI online coding questions test was conducted on the Hackerrank platform.
It’s 100 minutes online test which includes 21 questions. You have two hours to complete this test.
As I remember out of those 21 questions, there were three coding questions and one SQL database query to write. The rest of the questions are MCQs.
Time is sufficient for this test but the questions in this test are quite confusing. There can be multiple correct options in MCQ test.
Here are some of the multiple-choice questions asked in the test as I remember.
Table of Contents
Questions from Web Development and Computer Network
Questions from JavaScript
== and === operators in JavaScript?There were couple of more questions on JavaScript that I don’t remember right now.
Questions from HTML and CSS
# or .?..Questions from Data Structure and Algorithm
O(1).
Answer: 7 1 3 4 5 6 (Refer Binary Tree Traversal Algorithms.)
As I have applied for the Python full stack developer job profile, there were questions from Python programming.
print statement or function in Python 3?print is the statement. Whereas in Python 3, print is the function.
data = [2, 4, 4, {}, None, ()]
print(len(data))
Answer: Even though we have a NoneType object, an empty dictionary, and an empty list in the data list, the length of the list is 6.
If you are looking for a job as a Python developer, check out the Python interview questions guide. It includes interview questions asked in product-based companies explained in detail.
There was one question on the SQL query where you have to perform SQL join operation.
Given tables:
EMPLOYEE (id, name, address) EMPLOYEE_UIN (id, uin)
You have to print the name of all employee with their UIN number. If the employee don’t have UIN number, display UIN number as ‘None’.
Note: employee id is the primary key in the EMPLOYEE table and the foreign key in EMPLOYEE_UIN which can be used to perform join operation.
Hint: This is the simple SQL query. You should be knowing basic MySQL commands and join operations.
You have to pass all the given testcases for at least two coding questions.
To crack these coding questions, make habit of solving competitive coding questions.
This is all about MSCI online coding questions. If you have any doubt, let us know in the comment. All the best!
Editors’ Note: This Morgan Stanley interview experience is shared by the candidate Nishab Kumar. We wish him all the best!
This interview questions and experience are shared by one of the readers like you. You can share your interview experience as well. If you want to help new job aspirants to get their dream job, kindly share your experience on CSEstack Portal, by filling this <a href="https://www.csestack.org/share-your-experience/">simple form</a>. It will be published on our portal. Thank You!
Great article! The tips and explanations provided in this coding test guide from Morgan Stanley were really helpful and easy to understand – definitely worth checking out for any aspiring programmers.