LTIMindtree System Specialist Interview Questions and Answers

There are two main sections: foundation and advanced. The foundation section consists of three subsections: quantitative, reasoning, and verbal. If you pass the foundation section but do not clear the advanced section, you will be considered for either the ninja role or the digital role during the interview process. The advanced section includes advanced aptitude questions and two coding questions.

Q1. Can you provide an introduction about yourself?
Add your answer
Q2. 3 to 4 questions based on database
Add your answer
Q3. 2 easy coding questions
Add your answer
Q4. Questions based on technology that I knew
Add your answer
Q5. Situation based questions
Add your answer

There were a total of seven sections: verbal ability, logical reasoning, arithmetic problems, verbal reasoning, puzzles, pseudocodes, and essay writing, with each section having its own cutoff scores.

Q1. What is the SQL query to retrieve the person with the highest salary?
Add your answer
Q2. Can you describe the projects you have worked on?
Add your answer
Q3. Write a query to merge 2 tables?
Add your answer
Q4. Tell me about the internship that you have done?
Add your answer
Q5. Behavioural questions
Add your answer

I joined Cognizant as a Programmer Analyst Trainee in 2020. The initial aptitude test included sections on numerical reasoning, logical reasoning, mathematics, and paragraph comprehension. It was divided into multiple sections, preventing us from returning to questions from previous ones. There were numerous paragraph comprehensions, written in complex English, which consumed a significant amount of my time.

Q1. What is an IP address?
Add your answer
Q2. What is the recent movie you watched, can you explain the story?
Add your answer
Q3. Asked questions from my resume on my paper presentation - What is the presentation, can you explain what the paper is about?
Add your answer
Q4. Can you Introduce yourself?
Add your answer

Q1. Why do you want to join cognizant?
Add your answer
Q2. What do you know about cognizant?
Add your answer
Q3. Are you able to work in night shifts?
Add your answer
Q4. Would you be able to relocate to a different city and why do you want to relocate?
Add your answer

Q1. Roles and responsibilities for system administrator
Add your answer
Q2. How to configure network printer?
Add your answer
Q3. What purpose of device manager?
Add your answer
Q4. How to create disk partition?
Add your answer

Q1. Salary descision
Add your answer

There was basic coding question.

Corporate models. Work from office,Work from home, Hybrid model

Q1. Explain all the projects.
Ans. 
I have worked on various projects including developing a new CRM system, implementing a network security solution, and optimizing database performance.
• Developed a new CRM system to streamline customer interactions

• Implemented a network security solution to protect sensitive data

• Optimized database performance to improve system efficiency
Answered by AI
Add your answer

Q1. Explain about patch management in Linux
Add your answer
Q2. After patching what are the issues you faced. How did you troubleshoot those issues.
Add your answer

Q1. What is DNS and DNS records
Ans. 
DNS stands for Domain Name System, which translates domain names to IP addresses.
• DNS is like the phone book of the internet, translating human-readable domain names (like google.com) to IP addresses (like 172.217.3.206).

• DNS records are used to store information about a domain, such as the IP address of the server hosting the domain, mail server information, etc.

• Common types of DNS records include A records (for IPv4 ad...read more
Answered by AI
Add your answer
Q2. How to patch esxi
Ans. 
ESXi can be patched using VMware Update Manager, command line interface, or by manually downloading and applying patches.
• Use VMware Update Manager to automate patching process

• Use command line interface to manually apply patches

• Download patches from VMware website and apply manually if needed
Answered by AI
Add your answer

Q1. Why you are leaving your current job
Ans. 
Seeking new challenges and opportunities for growth
• Looking for a new challenge to further develop my skills and knowledge

• Interested in exploring new technologies and projects

• Seeking opportunities for career advancement and growth

• Desire for a change in work environment or company culture
Answered by AI
Add your answer

Its moderate and nit that much difficult to attempt

Coding also moderate its not that much deep

Assignment is based on verbal communication

Q1. What is the 1st priority job or family?
Ans. 
Family should be the 1st priority as they provide emotional support and love.
• Family provides emotional support during tough times

• Family offers unconditional love and care

• Job can always be replaced, but family is irreplaceable
Answered by AI
Add your answer
Q2. What is the java?
Ans. 
Java is a high-level programming language known for its portability, security, and versatility.
• Java is an object-oriented language

• It is platform-independent, meaning code can run on any device with a Java Virtual Machine (JVM)

• Java is used for developing web applications, mobile apps, desktop applications, and more
Answered by AI
Add your answer
Q3. Tell me your personal details
Ans. 
I am a dedicated and experienced System Analyst with a strong background in IT and problem-solving skills.
• Experienced in analyzing and designing software systems

• Proficient in programming languages such as Java, C++, and SQL

• Strong communication and teamwork skills

• Detail-oriented and able to prioritize tasks effectively
Answered by AI
Add your answer
Q4. Regarding coding
Add your answer
Q5. Regarding gk questions
Add your answer