TCS Consultant Interview Questions, Process, and Tips

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 ?
Ans. 
Plugins are software components that add specific features or functionalities to an existing program or application.
• Plugins enhance the capabilities of a software by adding new features or functionalities.

• They can be easily installed and uninstalled without affecting the core functionality of the software.

• Examples of plugins include browser extensions, video editing effects, and social media sharing buttons.
Answered by AI
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
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
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 your name
Ans. 
My name is John Smith.
• Full name is John Smith

• Common first and last name

• Easy to remember and pronounce
Answered by AI
Add your answer
Q2. Why you want to join us
Ans. 
I am passionate about helping organizations improve their efficiency and effectiveness through strategic consulting.
• I have a strong background in business strategy and analysis

• I enjoy working with diverse teams to solve complex problems

• I am excited about the opportunity to make a meaningful impact in your organization
Answered by AI
Add your answer

Q1. What is mean by join
Ans. 
Join is a SQL operation used to combine rows from two or more tables based on a related column between them.
• Join is used to retrieve data from multiple tables based on a related column

• Types of joins include inner join, outer join, left join, and right join

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer
Q2. Explain ddic ABAP sap
Ans. 
ddic ABAP SAP is a data dictionary in SAP ABAP used for defining and managing database objects.
• ddic stands for Data Dictionary in SAP ABAP

• It is used for defining and managing database objects like tables, views, data elements, domains, etc.

• ddic helps in maintaining data integrity and consistency in SAP systems
Answered by AI
Add your answer