LTIMindtree Team Leader (Technical) Interview Questions and Answers

Have confidence. Don't try to interrupt. Be clear and precise. Disagree in a polite way. Even if you don't know anything about the topic listen to what others speak and try gather points from it. You have to involve and make your voice get noticed. Silence won't work in GD.

So, aptitude test depends on the organisation's criteria. Think in a broad way and answer. Nothing is new is the key to score in aptitude test.

Q1. Why you think you should be selected? Never lie. This is the place where most of us get caught. First understand your job Nature. Then you will automatically get answer for this question. Don't be one side...read more
Add your answer
Q2. What will be your contribution? Think on what objectives you can work even more broadly. This will help you to stand out.
Add your answer

Q1. Tec discussion and issue handeling
Add your answer

Q1. Tec discussion and issue resolution
Add your answer

Q1. Basic .net questions
Add your answer
Q2. All basic only, you can clear it
Add your answer

Q1. Disadvantages of high degree of normalization
Ans. 
High degree of normalization can lead to increased complexity, decreased performance, and difficulty in querying data.
• Increased complexity in joins and queries

• Decreased performance due to multiple joins

• Difficulty in querying data across multiple tables

• Increased storage space required for normalized tables

• Potential for data redundancy if not properly managed
Answered by AI
Add your answer
Q2. Difference between table scan and Index scan
Ans. 
Table scan reads all rows in a table, while Index scan reads only specific rows using an index.
• Table scan is slower as it reads all rows sequentially.

• Index scan is faster as it reads only specific rows based on the index key.

• Table scan is used when a large portion of the table needs to be accessed.

• Index scan is used when only a small subset of rows need to be retrieved.

• Example: Table scan for SELECT * FROM table_name; ...read more
Answered by AI
Add your answer
Q3. Some complex queries using correlation and outer joins.
Ans. 
Understanding complex SQL queries with correlation and outer joins is crucial for data retrieval and analysis.
• Correlation in SQL allows subqueries to reference columns from the outer query, enhancing data filtering.

• Example: SELECT a.name FROM employees a WHERE a.salary > (SELECT AVG(b.salary) FROM employees b WHERE a.department_id = b.department_id);

• Outer joins (LEFT, RIGHT, FULL) retrieve unmatched rows from one or...read more
Answered by AI
Add your answer

Hackathon kind of technical test

Q1. C and Autosar, Bit operations on C and Architecture view of Autosar layers
Add your answer