TCS Consultant Interview Questions and Answers

Q1. Grilled my CV and coding knowledge
Add your answer
Q2. Asked me about DBMS
Add your answer

Q1. Asked about Business logic
Add your answer
Q2. Tested my logical thinking
Add your answer

Q1. What is Plugins ?
Add your answer
Q2. What is the difference between business rule and business process in MS Dynamics
Ans. 
Business rules define the logic and constraints for data validation and automation, while business processes define the sequence of tasks to be performed to achieve a specific outcome in MS Dynamics.
• Business rules are used to enforce data quality and consistency, such as requiring a certain field to be filled out or limiting the values that can be entered.

• Business processes are used to automate and streamline workflows...read more
Answered by AI
Add your answer

Normal aptitude questions

Easy questions on array and string

Q1. Questions about projects
Ans. 
Discussing project experiences highlights skills, challenges faced, and outcomes achieved in consulting roles.
• Describe a project where you improved client processes, e.g., streamlining operations for a manufacturing client.

• Highlight a challenging project, such as managing stakeholder expectations during a merger.

• Discuss a successful outcome, like increasing revenue by 20% through strategic recommendations.
Answered by AI
Add your answer
Q2. How to alter atble
Ans. 
To alter a table, you can use SQL commands like ALTER TABLE to add, modify, or delete columns.
• Use ALTER TABLE to add a new column: ALTER TABLE table_name ADD column_name datatype;

• Use ALTER TABLE to modify a column: ALTER TABLE table_name MODIFY column_name new_datatype;

• Use ALTER TABLE to delete a column: ALTER TABLE table_name DROP COLUMN column_name;
Answered by AI
Add your answer

Q1. Why do you want to tcs
Ans. 
I want to work at TCS because of its reputation for innovation, global presence, and opportunities for growth.
• TCS is known for its innovative solutions and cutting-edge technology.

• TCS has a strong global presence with clients in various industries around the world.

• TCS offers opportunities for career growth and development through training programs and mentorship.

• I admire TCS's commitment to diversity and inclusion in t...read more
Answered by AI
Add your answer
Q2. Behavioural questions
Add your answer

Q1. Basic of SAP MM
Add your answer
Q2. Different processes in SAP MM
Ans. 
SAP MM involves various processes like procurement, inventory management, and invoice verification.
• Procurement process involves creating purchase requisitions, sending RFQs to vendors, creating purchase orders, goods receipt, and invoice verification.

• Inventory management includes goods receipt, goods issue, transfer postings, and physical inventory.

• Invoice verification involves verifying invoices against purchase order...read more
Answered by AI
Add your answer

Q1. Spark optimisation techniques
Ans. 
Spark optimisation techniques involve various strategies to improve performance and efficiency of Spark applications.
• Use partitioning to distribute data evenly across nodes

• Cache intermediate results to avoid recomputation

• Optimize shuffle operations by reducing data shuffling

• Use broadcast variables for small lookup tables

• Tune memory and CPU settings based on workload
Answered by AI
Add your answer
Q2. Sql highest salary
Add your answer

Q1. What is beanspcos
Add your answer
Q2. How to handle the exceptions in springboot
Ans. 
Spring Boot provides robust exception handling mechanisms to manage errors and improve application reliability and user experience.
• Global Exception Handling: Use @ControllerAdvice to handle exceptions globally across all controllers. Example: @ExceptionHandler(NullPointerException.class) to handle null pointer exceptions.

• Custom Exception Classes: Create custom exceptions by extending RuntimeException. Example: public c...read more
Answered by AI
Add your answer