Morningstar Senior Consultant Interview Questions and Answers

It’s very easy and simple maths

Tell about family and hobbies and ambitions

Some basic aptitube and reasoning problems were asked. Easily solvable.

They asked multiple choice questions on oracle sql and pl/sql emphasizing more on reading a code block ask output questions. These were of medium hardness.

Q1. They asked what you do on daily basis in your work. What is most complex thing you have implemented and some complex questions on multilevel plsql collection module. It lasted for 1.5 hrs
Add your answer

Q1. Questions regarding Oracle architecture and its component
Add your answer
Q2. Question on live implementation of multilevel collection, bulk collect and record limiting and bulk exception handleing.
Add your answer
Q3. Dml error logging functionality
Ans. 
DML error logging functionality allows for capturing errors during data manipulation language operations.
• DML error logging can be enabled at the table level using the LOG ERRORS clause in DML statements.

• It helps in identifying and resolving data issues without causing the entire transaction to fail.

• Errors are logged in a separate error table, allowing the main operation to continue processing.

• Example: INSERT INTO table...read more
Answered by AI
Add your answer
Q4. Query and join optimization
Add your answer

Q1. Related to salary and what benefits they provide.
Add your answer

Not required depends on the project

Q1. Depends on the process and qualifications
Add your answer

Q1. What is GP catch up
Add your answer
Q2. General entry for accruals
Add your answer
Q3. Why do you want to join Apex
Add your answer
Q4. Are you ready for relocation
Add your answer
Q5. Are you flexible for shift rotation
Add your answer

Q1. What is GP catch up
Add your answer

Q1. Journal entry question CA
Add your answer

Q1. Accounting entries, matching concepts,
Add your answer
Q2. Basics of accounting
Add your answer