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. 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.
Add your answer

Hackathon kind of technical test

Q1. General salesforce questions for Salesforce team lead position
Add your answer
Q2. Apex related questions
Add your answer

Q1. Difference between Intercompany and intracompany?
Ans. 
Intercompany refers to transactions between two or more companies within the same group, while intracompany refers to transactions within the same company.
• Intercompany transactions involve entities that are part of the same corporate group.

• Intracompany transactions occur within a single company.

• Intercompany transactions are typically eliminated during consolidation to avoid double counting.

• Intracompany transactions are...read more
Answered by AI
Add your answer