TCS IT Analyst C2 Interview Questions, Process, and Tips

Answering questions on SCD type 2 mapping and SQL queries for deletion of duplicates, 5th highest salary, and employee department-wise salary comparison.

• SCD type 2 mapping involves tracking changes to a dimension table over time.

• Deletion of duplicate rows can be done using the DISTINCT keyword or GROUP BY clause.

• To find the 5th highest salary, use the LIMIT keyword with an OFFSET of 4.

• To list employees department-wise ...read more

Different data structures in Python include lists, tuples, sets, and dictionaries.

• Lists: Ordered, mutable, allows duplicate elements. Example: [1, 2, 3]

• Tuples: Ordered, immutable, allows duplicate elements. Example: (1, 2, 3)

• Sets: Unordered, mutable, does not allow duplicate elements. Example: {1, 2, 3}

• Dictionaries: Unordered, mutable, key-value pairs. Example: {'key': 'value'}

Decorators are a design pattern in Python that allows you to add new functionality to an existing object without modifying its structure.

• Decorators are functions that take another function as an argument and extend its behavior.

• They are commonly used to modify or extend the behavior of functions or methods.

• Decorators are denoted by the @ symbol followed by the decorator name.

• They are often used for logging, authenticat