TCS Back Office Assistant Interview Questions and Answers

I chose Flask over Django and FastAPI due to its simplicity, flexibility, and ease of use for smaller projects.

• Flask is lightweight and minimalistic, making it easier to set up and use for smaller projects.

• Flask allows for more flexibility in terms of project structure and customization compared to Django.

• Flask is well-suited for rapid prototyping and smaller applications where simplicity is key.

• Django, on the other ha...read more

Flask request and response block code snippet

• Use Flask's request object to access incoming request data

• Use Flask's jsonify function to create a JSON response

• Handle different HTTP methods like GET, POST, etc. in the route function

ORM stands for Object-Relational Mapping, a programming technique for converting data between incompatible type systems in object-oriented programming languages.

• ORM is used to map objects from an application to tables in a relational database.

• It simplifies data manipulation by allowing developers to work with objects instead of SQL queries.

• Popular ORM tools include Hibernate for Java, Entity Framework for .NET, and Seq

Use ORM code to select item from a table in database.

• Use ORM query methods like find(), findOne(), or where() to select items from a table.

• Specify the table name and any conditions for the selection.

• Example: User.find({ where: { id: 1 } }) will select a user with id 1 from the User table.

Use MySQL query with ORDER BY and LIMIT to find employee with 2nd highest salary.

• Use ORDER BY salary DESC to sort salaries in descending order

• Use LIMIT 1,1 to skip the highest salary and get the second highest salary

A branch in git is a separate line of development that allows you to work on features or fixes without affecting the main codebase.

• Branches allow for parallel development

• They can be created, switched between, merged, and deleted

• Common branches include master, develop, feature branches, and release branches

Software development lifestyle involves continuous learning, problem-solving, collaboration, and adapting to new technologies.

• Continuous learning is essential to stay updated with new technologies and best practices.

• Problem-solving skills are crucial for debugging and finding efficient solutions to complex problems.

• Collaboration with team members helps in sharing knowledge, brainstorming ideas, and improving code quali...read more

Class inheritance allows a subclass to inherit properties and methods from a superclass.

• Subclass can access all public and protected members of superclass.

• Subclass can override methods of superclass.

• Example: Animal class can be superclass, with Dog and Cat classes as subclasses inheriting properties and methods.

Find pairs from list whose sum is equal to target

• Iterate through the list and for each element, check if the target minus the element exists in a hashmap

• If it exists, add the pair to the result list

• If it doesn't exist, add the current element to the hashmap

My strengths include attention to detail, strong organizational skills, and ability to work efficiently under pressure.

• Attention to detail: I have a keen eye for spotting errors and ensuring accuracy in my work.

• Strong organizational skills: I am able to prioritize tasks, manage my time effectively, and keep track of multiple projects simultaneously.

• Ability to work efficiently under pressure: I can remain calm and focus...read more

One of my weaknesses is that I can be overly critical of my own work, which can sometimes lead to perfectionism.

• I tend to be a perfectionist and spend too much time on tasks to ensure they are flawless

• I struggle with delegating tasks to others because I want to make sure they are done correctly

• I can be overly self-critical and dwell on mistakes instead of moving forward