TCS Assistant System Engineer Trainee Interview Questions and Answers

General arithmetics and algebra

MCQ and coding question

Q1. What is Pointers in C
Ans. 
Pointers in C are variables that store memory addresses of other variables. They are used to access and manipulate data indirectly.
• Pointers are declared using the * symbol.

• They can be used to pass variables by reference to functions.

• Pointers can be used to dynamically allocate memory using functions like malloc().
Answered by AI
Add your answer
Q2. Give examples of each data types in C
Ans. 
Examples of data types in C include int, float, char, and double.
• int: used for storing integer values (e.g. age = 25)

• float: used for storing floating-point numbers (e.g. height = 5.8)

• char: used for storing single characters (e.g. grade = 'A')

• double: used for storing double-precision floating-point numbers (e.g. salary = 50000.50)
Answered by AI
Add your answer

Always be prepared by mastering the fundamental basics.

Q1. What is an amplifier?
Add your answer

Q1. What is pointer
Ans. 
A pointer is a variable that stores the memory address of another variable.
• Pointers are used to indirectly access and manipulate data in memory.

• They are often used in programming languages like C and C++.

• Example: int *ptr; // declaring a pointer to an integer variable
Answered by AI
Add your answer
Q2. Tell me about yourself
Ans. 
I am a recent graduate with a degree in Computer Science, passionate about technology and eager to learn and grow in the field of system engineering.
• Recent graduate with a degree in Computer Science

• Passionate about technology and eager to learn and grow

• Interested in pursuing a career in system engineering
Answered by AI
Add your answer

Q1. Tell me about SQL commands (DML and DDL)
Ans. 
SQL commands are categorized into DML for data manipulation and DDL for database structure definition.
• DML (Data Manipulation Language): Used for managing data within schema objects. Examples include SELECT, INSERT, UPDATE, DELETE.

• SELECT: Retrieves data from one or more tables. Example: SELECT * FROM employees;

• INSERT: Adds new records to a table. Example: INSERT INTO employees (name, age) VALUES ('John Doe', 30);

• UPDATE:...read more
Answered by AI
Add your answer
Q2. What will you do if you delete production database table by mistake?
Ans. 
Accidentally deleting a production database table requires immediate action to restore data and prevent further issues.
• Assess the situation: Determine the extent of the deletion and its impact on the application.

• Check backups: Look for the most recent backup of the database to restore the deleted table.

• Use transaction logs: If available, utilize transaction logs to recover the deleted data.

• Notify stakeholders: Inform r...read more
Answered by AI
Add your answer
Q3. What will you do if you encounter any problem?
Ans. 
When encountering a problem, I analyze the issue, seek solutions, and learn from the experience to improve future responses.
• Identify the Problem: I first clarify the issue by gathering all relevant information. For example, if a system is down, I check logs and error messages.

• Research Solutions: I look for documentation, online resources, or consult with colleagues to find potential solutions. For instance, I might ref...read more
Answered by AI
Add your answer
Q4. What will you do if you got selected in TCS and what if not?
Add your answer

Easy questions aptitude

Medium Difficulty process

Q1. Tell about sdlc lifecycle
Ans. 
SDLC (Software Development Life Cycle) is a process used by software development teams to design, develop, and test high-quality software.
• SDLC consists of several phases including planning, analysis, design, implementation, testing, and maintenance.

• Each phase has its own set of activities and deliverables to ensure the successful completion of the project.

• Examples of SDLC models include Waterfall, Agile, and DevOps.

• SDL...read more
Answered by AI
Add your answer

Q1. Negative feedback handling
Ans. 
Handling negative feedback involves active listening, reflection, and constructive response to improve performance and relationships.
• Listen actively to understand the feedback without interrupting.

• Reflect on the feedback to identify areas for improvement.

• Respond constructively, thanking the person for their input.

• Implement changes based on the feedback to show growth.

• Follow up with the person to discuss improvements an...read more
Answered by AI
Add your answer

Basic Analytics questions (Similar to CAT) followed by few Algorithmic questions

Q1. Why you want to join TCS
Ans. 
I want to join TCS for its innovative projects, growth opportunities, and commitment to employee development and community impact.
• TCS is a leader in technology and innovation, providing exposure to cutting-edge projects.

• The company's strong emphasis on employee training and development aligns with my career goals.

• TCS has a diverse work culture that promotes collaboration and learning from experienced professionals.

• The ...read more
Answered by AI
Add your answer
Q2. Location Preference
Add your answer