Filter interviews by
Clear (1)
I applied via Naukri.com and was interviewed in Jun 2020. There were 4 interview rounds.
Java OOPs concepts include inheritance, polymorphism, encapsulation, and abstraction.
Inheritance allows a class to inherit properties and methods from another class.
Polymorphism allows objects to take on multiple forms and behave differently based on the context.
Encapsulation hides the implementation details of a class and only exposes necessary information.
Abstraction focuses on the essential features of an object and...
SQL aggregation functions perform calculations on multiple rows of a single column of a table.
Aggregation functions include COUNT, SUM, AVG, MAX, and MIN.
They are used with the SELECT statement to retrieve data from a table.
Examples: SELECT COUNT(*) FROM customers; SELECT AVG(price) FROM products;
Aggregate functions can also be used with the GROUP BY clause to group data by one or more columns.
Join is a SQL operation that combines rows from two or more tables based on a related column between them.
Join is used to retrieve data from multiple tables in a single query.
Types of join include inner join, left join, right join, and full outer join.
Inner join returns only the matching rows from both tables.
Left join returns all the rows from the left table and matching rows from the right table.
Right join returns al...
Join queries are used to combine data from two or more tables based on a related column.
Use the JOIN keyword followed by the name of the table you want to join.
Specify the columns you want to select from each table.
Use the ON keyword to specify the column(s) that the tables should be joined on.
There are different types of joins: INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL OUTER JOIN.
Example: SELECT customers.name, orde...
SQL is a programming language used to manage and manipulate relational databases.
SQL stands for Structured Query Language
It is used to create, modify, and query databases
Common commands include SELECT, INSERT, UPDATE, and DELETE
Example: SELECT * FROM customers WHERE age > 18;
A constructor is a special method used to initialize objects in a class.
Constructors have the same name as the class they belong to.
They are called automatically when an object is created.
Constructors can take parameters to set initial values.
They can be overloaded to provide multiple ways of initializing objects.
Class and object are fundamental concepts in object-oriented programming. Method overloading and method overriding are two ways to achieve polymorphism.
A class is a blueprint or template for creating objects that encapsulate data and behavior.
An object is an instance of a class that has its own state and behavior.
Method overloading is when multiple methods in a class have the same name but different parameters.
Method o...
Exception handling is the process of handling errors and unexpected events in a program.
It involves identifying and anticipating potential errors
It provides a mechanism to handle these errors gracefully
It helps prevent program crashes and improves user experience
Examples include try-catch blocks, throw statements, and finally blocks
Multithreading is the ability of a CPU to execute multiple threads concurrently. Wait method is used to pause a thread.
Multithreading allows for better utilization of CPU resources
Wait method is used to pause a thread until a certain condition is met
Other methods like notify and notifyAll can be used to wake up waiting threads
Multithreading can improve performance in applications that require parallel processing
Java pr...
JSP and Servlet are Java technologies used for creating dynamic web pages and handling HTTP requests and responses.
JSP stands for JavaServer Pages and is used for creating dynamic web pages that can interact with server-side data and logic.
Servlet is a Java program that runs on a web server and handles HTTP requests and responses.
JSP and Servlet work together to create dynamic web applications that can generate HTML, p...
SQL subquery is a query within another query used to retrieve data from one or more tables.
Subqueries are enclosed in parentheses and placed within the WHERE or HAVING clause of the outer query.
They can be used to filter, sort, or aggregate data based on the results of the subquery.
Subqueries can also be used in the SELECT statement to retrieve a single value or set of values.
Example: SELECT * FROM employees WHERE depa...
A complex query is a query that involves multiple tables, conditions, and/or functions.
Start by identifying the tables involved in the query
Determine the conditions that need to be met using WHERE clause
Use JOIN to combine tables if necessary
Use aggregate functions like COUNT, SUM, AVG, etc. to perform calculations
Use subqueries to break down complex queries into smaller parts
Test the query and refine as necessary
Top trending discussions
posted on 2 Feb 2024
I applied via Naukri.com
posted on 22 Aug 2021
I applied via Campus Placement and was interviewed in Jul 2021. There were 3 interview rounds.
A CNC machine is a computer-controlled machine tool used for precision machining of various materials.
CNC stands for Computer Numerical Control.
It uses pre-programmed instructions to control the movement of the machine.
CNC machines can perform a wide range of operations such as cutting, drilling, milling, and turning.
They are commonly used in manufacturing industries for mass production of parts.
CNC machines offer high...
posted on 8 Oct 2020
posted on 5 May 2022
I applied via Referral and was interviewed in Apr 2022. There were 2 interview rounds.
General awareness about strategic thinking. Business Strategy. Organization strategy
Very good discussions
posted on 8 Jun 2022
I applied via Campus Placement and was interviewed in May 2022. There were 2 interview rounds.
Machining processing time refers to the time taken to complete a machining operation.
Machining processing time is influenced by factors such as the complexity of the part, the type of material being machined, and the efficiency of the machine.
It is important to optimize machining processing time to improve productivity and reduce costs.
Techniques such as high-speed machining, multi-axis machining, and automation can he...
posted on 23 Sep 2017
I was interviewed in Aug 2017.
posted on 23 Sep 2017
I was interviewed in Aug 2017.
posted on 12 Oct 2020
posted on 19 Sep 2022
I applied via Campus Placement and was interviewed before Sep 2021. There were 3 interview rounds.
Maily depend on the GATE exam
Current ongoing topics on technology and the industry
Some of the top questions asked at the Sigma Electric Manufacturing Corporation Graduate Engineer Trainee (Get) interview -
based on 5 reviews
Rating in categories
Diploma Trainee Engineer
409
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Engineer
352
salaries
| ₹0 L/yr - ₹0 L/yr |
Quality Engineer
112
salaries
| ₹0 L/yr - ₹0 L/yr |
Production Engineer
89
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Engineer
86
salaries
| ₹0 L/yr - ₹0 L/yr |
Precision Camshafts
Bharat Forge
TVS Sundram Fasteners
Samvardhana Motherson Group