LTIMindtree Implementation Consultant Interview Questions and Answers

Q1. There are three round one is with HR for collecting basic details after that second round with technical round and there are technical domain questions and afterwards client round.
Add your answer
Q2. BGP scenario base questions
Add your answer
Q3. OSP base questions
Add your answer

Q1. Interview ask Routing and switching base questions and day to day task.
Add your answer

Q1. What is your self
Ans. 
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
Answered Anonymously
View 1 more answer
Q2. What was the qualification
Ans. 
Degree completed BSC mpcs that's my qualifications
Answered Anonymously
View 1 more answer
Q3. Tell me about company details
Add your answer
Q4. You are good qualification
Add your answer

Around 30 MCQ questions to answer

Q1. What are operators in sql and their types.
Ans. 
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 (=)
Answered by AI
Add your answer
Q2. Delete vs Truncate.
Ans. 
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...read more
Answered by AI
Add your answer
Q3. Joins and their types
Ans. 
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 ...read more
Answered by AI
Add your answer
Q4. What are views, give example
Ans. 
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
Answered by AI
Add your answer

Q1. What are your expectations
Add your answer

Q1. Sql , payment related questions
Add your answer
Q2. Unix, ist switch, clearing
Add your answer

Q1. Servicnow developer related questions.
Add your answer

Q1. General questions like previous experiences and why do you want to join etc.
Add your answer