i
LTIMindtree
Filter interviews by
I applied via Naukri.com and was interviewed in Jul 2024. There were 3 interview rounds.
I applied via campus placement at Haldia Institute of Technology (HIT) and was interviewed in Nov 2024. There were 2 interview rounds.
Medium level of question
I applied via Job Portal
My name is rani am completed my degree,and get a good job , job is very important in my life and my father was farmer my mother also a farmer
Degree completed BSC mpcs that's my qualifications
I applied via Referral and was interviewed before May 2023. There were 3 interview rounds.
Around 30 MCQ questions to answer
Operators in SQL are symbols used to perform operations on data in a database.
Arithmetic operators (+, -, *, /)
Comparison operators (=, <>, >, <, >=, <=)
Logical operators (AND, OR, NOT)
Concatenation operator (||)
Assignment operator (=)
Delete removes all rows from a table, while truncate removes all rows and resets auto-increment values.
Delete is a DML command and can be rolled back, while truncate is a DDL command and cannot be rolled back.
Delete triggers delete triggers and delete constraints, while truncate does not trigger any triggers or constraints.
Delete is slower as it logs individual row deletions, while truncate is faster as it logs the dea...
Joins are used to combine rows from two or more tables based on a related column between them.
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN returns rows when there is at least one match in both tables.
LEFT JOIN returns all rows from the left table and the matched rows from the right table.
RIGHT JOIN returns all rows from the right table and the matched rows from the left table.
FULL ...
Views are virtual tables that display a subset of data from one or more tables in a database.
Views are used to simplify complex queries by storing them as a virtual table.
They can also restrict access to certain columns or rows of data.
Views do not store data themselves, but instead display data from the underlying tables.
Example: Creating a view that displays only the names and emails of customers from a database tabl
I applied via LinkedIn and was interviewed in Apr 2022. There was 1 interview round.
I applied via Approached by Company and was interviewed before Jul 2021. There were 3 interview rounds.
based on 3 interviews
Interview experience
based on 10 reviews
Rating in categories
Senior Software Engineer
21.3k
salaries
| ₹5.1 L/yr - ₹18.7 L/yr |
Software Engineer
16.2k
salaries
| ₹2 L/yr - ₹10 L/yr |
Module Lead
6.7k
salaries
| ₹7 L/yr - ₹25 L/yr |
Technical Lead
6.4k
salaries
| ₹9.4 L/yr - ₹36 L/yr |
Senior Engineer
4.4k
salaries
| ₹4.2 L/yr - ₹16.5 L/yr |
Cognizant
Capgemini
Accenture
TCS