BEML L2 Engineer Interview Questions and Answers

Q1. Can you explain the difference between a stack and a queue and provide a real-world example where each would be used.
Ans. 
A stack is a Last In First Out (LIFO) data structure, while a queue is a First In First Out (FIFO) data structure.
• Stack: LIFO - Last In First Out. Example: browser history where the last page visited is the first to be accessed.

• Queue: FIFO - First In First Out. Example: a line at a grocery store where the first person in line is the first to be served.
Answered by AI
Add your answer
Q2. Given an array of integers, write a function to find the two numbers that add up to a specific target. How would you optimize this solution?
Ans. 
Function to find two numbers in array that add up to target. Optimize solution.
• Use a hash map to store each number and its index as you iterate through the array.

• For each number, check if the difference between the target and the number exists in the hash map.

• Return the indices of the two numbers that add up to the target.
Answered by AI
Add your answer

Q1. It was an algorithm question which I had to code in 30 minutes
Add your answer
Q2. Java/Spring related questions were asked
Add your answer

They asked me about my current project and asked me to design a system similar to that

Aptitute with cs fundamental questions (MCQ)

Q1. Explanation of project
Ans. 
Developed a web application for tracking inventory in a warehouse
• Used React.js for front-end development

• Implemented RESTful APIs using Node.js for back-end

• Utilized PostgreSQL database for storing inventory data
Answered by AI
Add your answer
Q2. Sql query to fetch specific column
Ans. 
Use SELECT statement in SQL to fetch specific column from a table.
• Use SELECT column_name FROM table_name;

• Replace column_name with the name of the column you want to fetch.

• Replace table_name with the name of the table where the column is located.
Answered by AI
Add your answer

Logic quants apti core

Problem solving using programming language

Q1. Explain about project
Ans. 
The project is a web-based application for managing inventory and sales for a retail store.
• Developed using Java Spring framework

• Utilized MySQL database for storing data

• Implemented RESTful APIs for communication between frontend and backend

• Included features such as user authentication, product management, and sales tracking
Answered by AI
Add your answer
Q2. What all technologies you know
Ans. 
I am proficient in technologies such as Java, Selenium, JUnit, TestNG, SQL, Git, Jenkins, and Agile methodologies.
• Java

• Selenium

• JUnit

• TestNG

• SQL

• Git

• Jenkins

• Agile methodologies
Answered by AI
Add your answer

Q1. Normalization in SQL, What is Cursor in SQL
Ans. 
Normalization in SQL is the process of organizing data in a database to reduce redundancy and improve data integrity. A cursor in SQL is a database object used to retrieve and manipulate data row by row.
• Normalization in SQL involves breaking down a large table into smaller tables and defining relationships between them to reduce redundancy.

• Cursors in SQL are used to fetch and process individual rows returned by a query...read more
Answered by AI
View 1 more answer
Q2. .Net Core and API based questions
Add your answer
Q3. Abstract and interface difference
Ans. 
Abstract classes can have both abstract and non-abstract methods, while interfaces can only have abstract methods.
• Abstract classes can have constructors, fields, and non-abstract methods along with abstract methods

• Interfaces can only have abstract methods and constants

• A class can implement multiple interfaces but can only inherit from one abstract class
Answered by AI
View 1 more answer
Q4. Const and read only difference in C#
Ans. 
Const keyword is used to declare constants at compile time, while read-only keyword is used to create immutable fields that can only be assigned a value at runtime.
• Const values are determined at compile time and cannot be changed, while read-only values can only be assigned a value once at runtime.

• Const fields are implicitly static, while read-only fields are not.

• Example: const int x = 5; read-only int y = 10;
Answered by AI
Add your answer
Q5. Azure basic fundamental questions
Add your answer
Q6. Sample query to join tables using SQL
Ans. 
Sample query to join tables using SQL
• Use the JOIN keyword to combine rows from two or more tables based on a related column between them

• Specify the columns to be selected from each table

• Use the ON keyword to specify the join condition
Answered by AI
Add your answer

Q1. What is polymorphism in OOPS
Ans. 
Polymorphism in OOPS refers to the ability of a single function or method to operate on different types of data.
• Polymorphism allows objects of different classes to be treated as objects of a common superclass.

• There are two types of polymorphism: compile-time (method overloading) and runtime (method overriding).

• Example: Inheritance allows a child class to override a method of its parent class, providing different implem
Answered by AI
Add your answer
Q2. How SQL Performance Can Be Optimized
Ans. 
SQL performance can be optimized by using indexes, optimizing queries, minimizing network round trips, and using proper data types.
• Use indexes on columns frequently used in WHERE clauses to speed up data retrieval.

• Optimize queries by avoiding unnecessary joins, using WHERE clauses effectively, and limiting the number of rows returned.

• Minimize network round trips by batching multiple queries into a single request.

• Use pr...read more
Answered by AI
Add your answer

Q1. Salary Expectation as per Your Role
Ans. 
My salary expectation as a Senior Software Engineer is based on industry standards, my experience, and the responsibilities of the role.
• Research industry standards for Senior Software Engineer salaries

• Consider my years of experience and expertise in software development

• Factor in the specific responsibilities and requirements of the role

• Negotiate based on the company's budget and benefits package

• Be open to discussing sa
Answered by AI
Add your answer
Q2. How will manage If you see the application is crashed
Ans. 
I will investigate the root cause, analyze logs, and work on fixing the issue to prevent future crashes.
• Investigate the crash logs to identify the root cause

• Analyze the code to understand the issue

• Implement a fix for the crash

• Test the fix thoroughly before deploying it

• Implement monitoring and alerting to catch similar issues in the future
Answered by AI
Add your answer

MCQ of programming languages - c/c++/Python , basic DS and OS questions

Q1. DS and programming language questions
Add your answer

Q1. Project level discussion and questions
Add your answer