Tech Mahindra System Analyst Interview Questions and Answers

Q1. Tell me about sql query
Ans. 
SQL query is a command used to retrieve, insert, update, or delete data from a database.
• SQL query is written in Structured Query Language.

• It can be used to retrieve data using SELECT statement.

• It can also be used to insert data using INSERT statement.

• UPDATE statement is used to modify existing data.

• DELETE statement is used to remove data from a table.
Answered by AI
Add your answer
Q2. What is primary key
Ans. 
Primary key is a unique identifier for each record in a database table.
• Primary key ensures each record in a table is unique

• It can be a single column or a combination of columns

• Primary key values cannot be null

• Example: EmployeeID in an Employee table
Answered by AI
Add your answer

Easy aptitude questions were asked.

Two coding questions were asked.

Q1. Explain about a challenging situation you faced in previous role and how you managed it?
Add your answer
Q2. Why should we follow agile methodology to water fall methodology?
Ans. 
Agile methodology allows for more flexibility, adaptability, and collaboration compared to waterfall methodology.
• Agile methodology promotes iterative development and continuous feedback.

• Agile allows for changes to be made throughout the project, based on feedback and evolving requirements.

• Agile encourages collaboration between cross-functional teams, leading to better communication and faster problem-solving.

• Agile is b...read more
Answered by AI
Add your answer

Q1. Are you willing to relocate?
Add your answer
Q2. You can either say you are definitely willing to relocate. which shows that you’ll do whatever is necessary to be a part of the company and team.
Add your answer
Q3. What are you hobbies
Add your answer
Q4. My hobbies is drawing, news Paper reading.
Add your answer
Q5. What makes you unique?
Add your answer
Q6. I anticipate helping your company set and achieve goals that will surpass all of your previous records.
Add your answer
Q7. What are type working
Ans. 
Types of working refer to different ways in which individuals approach their tasks and responsibilities in a work setting.
• Different types of working include collaborative, independent, detail-oriented, creative, analytical, etc.

• Some individuals may excel in collaborative environments where teamwork is key, while others may prefer working independently.

• Detail-oriented workers focus on accuracy and precision, while creat...read more
Answered by AI
Add your answer
Q8. I'm not your company how to your company. please request you to your company I join you Wipro company work from home sir
Add your answer

Q1. What is reconciliation
Ans. 
Reconciliation is the process of comparing two sets of records to ensure they are in agreement.
• Reconciliation involves verifying and adjusting financial statements to match transactions

• It is commonly used in accounting to ensure accuracy of financial data

• Reconciliation can also refer to resolving differences between two conflicting parties or accounts
Answered by AI
Add your answer

Basics of computer technology like database os and programing MCQs

Q1. Many questions but easy one on topics like oops, sql, msdos, windows
Add your answer

Q1. Shift timing, salary negotition and offer realated things discussed
Add your answer

Q1. Tell me about yourself
Add your answer
Q2. Tell me your prefer language
Ans. 
My preferred language is Java.
• I have extensive experience in Java programming.

• I find Java to be a versatile and powerful language.

• Java has a large community and a vast ecosystem of libraries and frameworks.

• I have worked on various Java projects, including web development, desktop applications, and backend systems.
Answered by AI
View 1 more answer
Q3. How much year's you will be work in my company
Add your answer

Aptitude in 3 phase-
1. English round
2. Game based
3. Communication test

Q1. C and Java based questions
Add your answer

Q1. Why should join Capgemini
Add your answer
Q2. After 5 years what is looking for
Add your answer
Q3. Strength and weakness
Add your answer
Q4. Why should hire you ?
Add your answer