Emkay Global Financial Services Research Associate Interview Questions and Answers

Write a program to print hello

Q1. Get all permutations of [1,2,3]
Ans. 
Generate all permutations of [1,2,3] as array of strings
• Use recursion to generate all possible permutations

• Swap elements to create different permutations

• Base case: when only one element is left, add to result array
Answered by AI
Add your answer
Q2. What is the purpose of the slice function in Redux Toolkit?
Ans. 
The slice function in Redux Toolkit is used to create a copy of a portion of an array state.
• Allows for immutably updating arrays in Redux state by creating a new array with a subset of elements.

• Can be used to remove elements from an array without mutating the original state.

• Example: const newState = state.slice(0, 2) will create a new array with the first 2 elements of the original state.
Answered by AI
Add your answer

Q1. How would you find object is Array without using Array.isArray() function?
Ans. 
Check if an object is an array without using Array.isArray() function
• Check if the object has a length property

• Check if the object has a slice method

• Check if the object has an index of 0
Answered by AI
Add your answer

Q1. General questions about current job role
Add your answer

Q1. Discussion about job related topics
Add your answer

Q1. One on one discussion regarding job role and aptitude
Add your answer

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. Tell me about yourself
Add your answer

Q1. The interview was really smooth, every aspect was discussed clearly from expectations, learning, to growth
Add your answer