Srei Equipment Finance 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. Hadoop basics on computing
Add your answer
Q2. Distribution basics for processing the data
Add your answer

Q1. Architecture of bigdata systems
Ans. 
Bigdata systems architecture involves distributed storage, processing, and analysis of large volumes of data.
• Utilize distributed file systems like HDFS for storage

• Use parallel processing frameworks like Apache Spark or Hadoop for data processing

• Implement data pipelines for ETL processes

• Leverage NoSQL databases like Cassandra or MongoDB for real-time data querying

• Consider data partitioning and replication for fault tole
Answered by AI
Add your answer
Q2. How will the bigdata system distribution for storage andcompute happen
Ans. 
Big data system distribution for storage and compute involves partitioning data across multiple nodes for efficient processing.
• Data is partitioned across multiple nodes to distribute storage and processing load.

• Hadoop Distributed File System (HDFS) is commonly used for storage distribution.

• Apache Spark utilizes a cluster computing framework for distributed computing.

• Data locality is important to minimize data transfer ...read more
Answered by AI
Add your answer

Q1. Sorting of 1d array
Ans. 
Sorting a 1d array of strings
• Use a sorting algorithm like bubble sort, selection sort, or merge sort

• Consider using built-in sorting functions in programming languages like sort() in Python or Arrays.sort() in Java

• Ensure to compare strings correctly based on their ASCII values
Answered by AI
Add your answer
Q2. Basics of Camunda, Java and Spring boot.
Add your answer

Q1. What is dependency injection
Ans. 
Dependency injection is a design pattern in which components are given their dependencies rather than creating them internally.
• Dependency injection helps in achieving loose coupling between classes.

• It allows for easier testing by providing mock dependencies.

• There are three types of dependency injection: constructor injection, setter injection, and interface injection.
Answered by AI
Add your answer
Q2. What is state in react
Ans. 
State in React is a JavaScript object that stores data and determines how a component renders and behaves.
• State is mutable and can be updated using the setState() method

• State should be used for data that will change over time and affect the component's rendering

• State should not be modified directly, use setState() instead
Answered by AI
Add your answer

Q1. What is Webpack
Ans. 
Webpack is a module bundler for JavaScript applications.
• Webpack takes modules with dependencies and generates static assets representing those modules.

• It can handle various types of assets such as JavaScript, CSS, and images.

• Webpack allows for code splitting, lazy loading, and hot module replacement.

• It is commonly used in modern web development workflows to optimize and bundle code for production.
Answered by AI
Add your answer

Q1. Sort array and questions on project
Add your answer

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

Basic array and vectors DSA questions

Q1. Asked me about my past project and my contribution in it
Add your answer
Q2. Linux commands and c++ language control
Add your answer
Q3. Asked me to write last function i wrote and explain what it does
Add your answer

Q1. Asked me about my past projects and my contribution
Add your answer
Q2. Checked my work ethics
Add your answer

Q1. Basic hr questions
Add your answer
Q2. Salary negotiation
Add your answer