Cognizant Programmmer analyst interview questions

### SQL: 1. **Basic Queries:** - How do you write a SQL query to retrieve all records from a table? - How do you use the WHERE clause in SQL? - What is the difference between INNER JOIN and LEFT JOIN? 2. **Intermediate Queries:** - How do you find the second highest salary in a table? - How do you write a query to count the number of employees in each department? 3. **Advanced Queries:** - Explain the difference between GROUP BY and HAVING clauses. - How would you optimize a slow-running query? ### Python: 1. **Basic Concepts:** - What are the key features of Python? - Explain the concept of lists, tuples, and dictionaries with examples. 2. **Intermediate Concepts:** - How do you handle exceptions in Python? - What is a lambda function and how is it used? 3. **Advanced Concepts:** - Explain the concept of decorators in Python. - How do you manage memory in Python? ### DBMS: 1. **Fundamentals:** - What are the different types of database management systems? - Explain ACID properties in a database. 2. **Design and Normalization:** - What is normalization? Explain different normal forms. - What is a foreign key? How is it different from a primary key? 3. **Transactions and Concurrency:** - What are transactions? How do you implement them in SQL? - What is the difference between pessimistic and optimistic locking? ### Projects: 1. **Project Explanation:** - Can you describe a project you have worked on recently? What was your role? - What technologies did you use in your project and why? 2. **Challenges and Solutions:** - What challenges did you face during your project, and how did you overcome them? - How did you ensure the quality and reliability of your project? ### Aptitude: 1. **Logical Reasoning:** - If two trains are moving towards each other at different speeds, how do you calculate the point at which they will meet? 2. **Mathematical Problems:** - Solve this problem: If a person can do a job in 10 days and another can do the same job in 15 days, how long will it take for them to complete the job together?

Can you explain about tuples?