LTIMindtree Interview Questions, Process, and Tips

Conducted by CITI Karat. 2 SQL coding was there. Total interview was 1 hr. First 15 min was introduction. 25 min for 1st question and 20 min for 2nd question. The questions are little bit tricky.

Q1. Types of indexes and uses
Ans. 
Indexes in databases help improve query performance by allowing faster data retrieval.
• Types of indexes include clustered, non-clustered, unique, and composite indexes.

• Clustered indexes physically reorder the data in the table based on the index key.

• Non-clustered indexes create a separate structure that includes the indexed columns and a pointer to the actual data.

• Unique indexes ensure that no two rows have the same val...read more
Answered by AI
Add your answer
Q2. Query optimization and performance tuning
Add your answer
Q3. Ddl, dml, TCL, scl, dql
Add your answer
Q4. Views, function, sp, trigger
Add your answer

Q1. Suppose a bug appear in production environment after providing sign off how will you handle it what approach will you follow.
Ans. 
I would immediately investigate the bug, identify the root cause, prioritize a fix, and communicate with stakeholders.
• Investigate the bug to understand the root cause

• Prioritize the fix based on impact and severity

• Communicate with stakeholders about the issue and proposed solution

• Implement the fix and deploy it to production

• Conduct post-implementation testing to ensure the bug is resolved
Answered by AI
Add your answer

Quant, apti, communication, coding, technical

Q1. Tell me about your projects
Ans. 
I have worked on various projects including developing a mobile app for tracking fitness goals and a web-based inventory management system.
• Developed a mobile app using React Native to track fitness goals and provide workout plans

• Created a web-based inventory management system using Django and PostgreSQL

• Implemented data visualization tools using D3.js for analyzing user activity in the fitness app
Answered by AI
Add your answer
Q2. Agile methodology
Add your answer

Q1. What is cloud computing
Ans. 
Cloud computing is the delivery of computing services over the internet, including storage, databases, networking, software, and more.
• Cloud computing allows users to access and use resources on-demand without the need for physical infrastructure.

• Examples of cloud computing services include Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform.

• Cloud computing offers scalability, flexibility, cost-effecti...read more
Answered by AI
Add your answer
Q2. Explain cloud service
Ans. 
Cloud service refers to the delivery of computing services, including servers, storage, databases, networking, software, analytics, and intelligence, over the internet.
• Cloud services are typically provided by third-party providers who own and operate the infrastructure.

• Users can access these services on-demand and pay for only what they use, making it a cost-effective solution.

• Examples of cloud services include Amazon ...read more
Answered by AI
Add your answer

Q1. Java 8 improvements
Ans. 
Java 8 introduced several improvements including lambda expressions, functional interfaces, streams, and default methods.
• Lambda expressions allow for more concise code and easier parallel programming.

• Functional interfaces enable the use of lambda expressions.

• Streams provide a way to work with sequences of elements efficiently.

• Default methods allow interfaces to have concrete methods.

• Optional class helps to handle null
Answered by AI
Add your answer
Q2. Stream based coding
Add your answer