MSCI Senior Engineer Interview Questions and Answers

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

Q1. 1. Tell me about Python OS module. 2. What is Anachron? 3. What is the difference between Dynamic and Static website? 4. How will you clone a particular branch? 5. How will you handle exceptions in Ansible...read more
Ans. 
Technical interview questions for Senior Engineer position
• Python OS module provides a way of interacting with the operating system

• Anachron is a tool for scheduling periodic jobs

• Dynamic websites generate content on the fly while static websites serve pre-built content

• To clone a particular branch, use the git clone command followed by the branch name

• Exceptions in Ansible can be handled via the 'ignore_errors' parameter i...read more
Answered by AI
Add your answer

Q1. What is the difference between normal and arrow functions
Ans. 
Arrow functions are more concise and have a lexical 'this' binding compared to normal functions.
• Arrow functions do not have their own 'this' keyword, they inherit it from the parent scope.

• Arrow functions do not have their own 'arguments' object.

• Arrow functions cannot be used as constructors with 'new'.

• Arrow functions are more concise and have implicit return when no curly braces are used.
Answered by AI
Add your answer
Q2. All basic JS Questions to cover Hoisting closure
Add your answer
Q3. They asked to show me an example using the API call
Add your answer
Q4. Difference between forEach and Map
Ans. 
forEach is used to iterate over an array and perform a function on each element, while map creates a new array by applying a function to each element.
• forEach does not return a new array, while map does

• forEach does not modify the original array, while map creates a new array

• forEach is used for side effects, while map is used for transformation

• Example: forEach - array.forEach(item => console.log(item)), map - const newAr
Answered by AI
Add your answer

Write code to return the maximum profit by buying and selling stocks using available money

Q1. What is HTML and CSS?
Ans. 
HTML and CSS are markup languages used for creating and styling web pages.
• HTML stands for HyperText Markup Language and is used for structuring content on web pages.

• CSS stands for Cascading Style Sheets and is used for styling the appearance of web pages.

• HTML uses tags to define elements like headings, paragraphs, images, and links.

• CSS allows for customization of colors, fonts, layout, and other visual aspects of a web...read more
Answered by AI
Add your answer
Q2. Operating Systems, DBMS, Python
Add your answer

Q1. Best practices of coding
Ans. 
Best practices of coding include writing clean and readable code, using meaningful variable names, following coding standards, and testing code thoroughly.
• Write clean and readable code

• Use meaningful variable names

• Follow coding standards

• Test code thoroughly
Answered by AI
Add your answer

Q1. String related questions
Add your answer

Q1. Tuple related questions
Add your answer

Low-level design interview
I need to design a Music player app using oops concept

Q1. Sort the stack in O(1) time complexity
Ans. 
Use an additional stack to store sorted elements and maintain the minimum element at the top of the original stack.
• Create a new stack to store sorted elements.

• Pop elements from the original stack and compare with the top element of the new stack.

• If the popped element is smaller, push it to the new stack. If larger, keep popping from the new stack and push to the original stack until the correct position is found.

• Repeat...read more
Answered by AI
View 1 more answer
Q2. Difference between process and thread
Ans. 
A process is an instance of a program running on a computer, while a thread is a smaller unit of execution within a process.
• A process has its own memory space, while threads within the same process share memory.

• Processes are independent of each other, while threads within the same process can communicate with each other.

• Processes are heavyweight, requiring separate memory and resources, while threads are lightweight an...read more
Answered by AI
Add your answer
Q3. Difference between abstract class and interface
Ans. 
Abstract class can have both abstract and non-abstract methods, while interface can only have abstract methods.
• Abstract class can have constructor, fields, and methods, while interface cannot have any of these.

• A class can implement multiple interfaces but can only inherit from one abstract class.

• Abstract class is used to provide a common base for multiple derived classes, while interface is used to define a contract fo...read more
Answered by AI
Add your answer
Q4. What is race condition?
Ans. 
A race condition is a situation in which the outcome of a program depends on the order of execution of its threads or processes.
• Occurs when multiple threads or processes access shared data or resources concurrently

• Can lead to unpredictable behavior or bugs in the program

• Prevented by using synchronization mechanisms like locks or semaphores

• Example: Two threads trying to increment a shared variable simultaneously
Answered by AI
Add your answer
Q5. What is normalization in dbms
Ans. 
Normalization in DBMS is the process of organizing data in a database to reduce redundancy and improve data integrity.
• Normalization involves breaking down a database into smaller, more manageable tables.

• It helps in reducing data redundancy by storing data in a structured way.

• There are different normal forms like 1NF, 2NF, 3NF, BCNF, etc.

• Example: In a database of students, instead of storing student details in multiple ...read more
Answered by AI
Add your answer

Q1. What is policy manager
Ans. 
Policy manager is a software tool used to centrally manage and enforce policies across an organization's systems and applications.
• Policy manager helps define, monitor, and enforce policies related to security, compliance, access control, and other governance aspects.

• It allows administrators to set rules and regulations that govern how data and resources are accessed and used within an organization.

• Policy manager can au...read more
Answered by AI
Add your answer