TCS Associate Consultant Interview Questions, Process, and Tips

Q1. General SQL query
Add your answer
Q2. Specific join functionalities question
Add your answer

Q1. Read data from excel
Add your answer

Q1. What is STP , Vlan and VTP
Ans. 
STP stands for Spanning Tree Protocol, VLAN stands for Virtual Local Area Network, and VTP stands for VLAN Trunking Protocol.
• STP is a network protocol that ensures a loop-free topology in Ethernet networks.

• VLAN is a method of segmenting a physical network into multiple virtual networks for better traffic management and security.

• VTP is a Cisco proprietary protocol that manages the addition, deletion, and renaming of VLA...read more
Answered by AI
Add your answer
Q2. What is eigrp metrip
Ans. 
EIGRP metric is a formula used by EIGRP routing protocol to calculate the best path to a destination network.
• EIGRP metric is based on bandwidth and delay of the path to the destination.

• The formula for EIGRP metric is: metric = [K1 * bandwidth + (K2 * bandwidth) / (256 - load) + K3 * delay] * [K5 / (reliability + K4)]

• The default values for K1-K5 are 1, 0, 1, 0, and 0 respectively.
Answered by AI
Add your answer

Q1. How ospf works and how it chooses best path
Ans. 
OSPF is a routing protocol that uses link-state algorithm to determine the best path based on cost.
• OSPF routers exchange link-state advertisements (LSAs) to build a topological database of the network.

• Each router calculates the shortest path tree to all destinations using Dijkstra's algorithm.

• The best path is chosen based on the lowest cost, which is determined by the bandwidth of the link.

• OSPF supports multiple paths ...read more
Answered by AI
Add your answer

Q1. What is bgp and it's attributes
Ans. 
BGP (Border Gateway Protocol) is a routing protocol used to exchange routing information between different autonomous systems on the internet.
• BGP is used to make routing decisions based on network policies, rules, and attributes.

• BGP attributes include AS_PATH, NEXT_HOP, LOCAL_PREF, and MED.

• AS_PATH attribute shows the path the route has taken through different autonomous systems.

• NEXT_HOP attribute specifies the next rou...read more
Answered by AI
Add your answer

Q1. What is your salary expectation
Add your answer

Q1. Challenges faced in automation project
Ans. 
Challenges in automation projects include tool selection, script maintenance, and handling dynamic elements.
• Choosing the right automation tool for the project requirements

• Ensuring scripts are maintained and updated regularly to keep up with application changes

• Dealing with dynamic elements that may change in the application interface
Answered by AI
Add your answer
Q2. How to handle merge conflicts
Ans. 
Merge conflicts can be handled by resolving conflicts manually or using tools like Git merge or rebase.
• Communicate with team members to understand changes made by each party

• Use version control tools like Git merge or rebase to resolve conflicts

• Manually resolve conflicts by editing the conflicting files

• Test the merged code to ensure functionality is not affected
Answered by AI
Add your answer

Q1. Explain the automation framework
Ans. 
Automation framework is a set of guidelines, best practices, and tools used for automated testing of software applications.
• Automation framework provides structure and organization to automated tests

• It includes components like test scripts, libraries, and test data

• Frameworks can be data-driven, keyword-driven, or hybrid

• Examples of automation frameworks include Selenium, TestNG, and Robot Framework
Answered by AI
Add your answer

Q1. IOS Basic Questions
Add your answer
Q2. Real time case based questions
Add your answer

Spring-based microservice question.