TCS Assistant System Engineer Interview Questions, Process, and Tips

Various aptitude questions Statistics, time and work, etc.

Q1. Technical interview based on the basic concepts of coding
Add your answer
Q2. What is a foreign key in SQL?
Ans. 
A foreign key is a column or set of columns in a table that refers to the primary key of another table.
• It establishes a link between two tables.

• It ensures referential integrity.

• It can be used to join tables.

• Example: CustomerID in Orders table refers to CustomerID in Customers table.
Answered by AI
Add your answer
Q3. Can you explain how a do-while loop work?
Ans. 
A do-while loop executes the code block at least once and then repeatedly executes it while the specified condition is true.
• The code block is executed once before the condition is checked

• If the condition is true, the code block is executed again and again until the condition becomes false

• Syntax: do { code block } while (condition);

• Example: do { x++; } while (x < 5);
Answered by AI
Add your answer

General ability logical reasoning

2 coding questions for 1 hr and few mcqs

Q1. Few basic programs no java
Add your answer

Q1. Few basic questions on personal abilities
Add your answer

They asked logical reasoning , Arithmetic , English , Some mental ability .

Execute 2 codes . 1 will be moderate another little tough I felt . Execute one of the code perfectly as per requirement is fine .

Q1. Technical Questions related to Java , Method overloading, functions, Data types etc..
Add your answer
Q2. Some managerial questions like why TCS etc .
Add your answer

TCS NQT was there for aptitude exam, it was offline at centre

Same exam had some coding questions

Q1. A face to face interview was scheduled to check my knowledge
Add your answer
Q2. What is pointers and what is tree and a program to print pattern
Ans. 
Pointers are variables that store memory addresses. Trees are data structures consisting of nodes connected by edges. A program to print pattern can vary depending on the desired pattern.
• Pointers are used to manipulate memory and create dynamic data structures.

• They can be used to pass values by reference instead of by value.

• Example: int *ptr; ptr = # *ptr = 10; //num now equals 10

• Trees are used to represent hierarc...read more
Answered by AI
Add your answer

Prepare on logical related questions.

Q1. Basics of oops and process knowledge.
Add your answer
Q2. Current process used in business.
Ans. 
The current process used in business involves analyzing data, identifying areas for improvement, implementing changes, and monitoring results.
• Data analysis to identify trends and patterns

• Continuous improvement through feedback and monitoring

• Implementation of changes based on analysis

• Regular monitoring of results to track progress
Answered by AI
Add your answer

Gave Coding test in TCS NQT

Q1. Asked about my college projects, and since I used flutter in my college projects and internships, Interviewer googled some flutter questions and asked, which I answered easily.
Add your answer
Q2. Explain about your recent project
Ans. 
Developed a web-based inventory management system for a retail company
• Used PHP and MySQL for backend development

• Implemented responsive design using HTML, CSS, and JavaScript

• Integrated barcode scanning functionality for efficient inventory tracking
Answered by AI
Add your answer
Q3. How is flutter different from other mobile technologies
Ans. 
Flutter is a cross-platform mobile development framework created by Google, allowing developers to build native-like apps for both iOS and Android using a single codebase.
• Flutter uses a single codebase for both iOS and Android, reducing development time and effort.

• Flutter has a hot reload feature, allowing developers to see changes instantly without restarting the app.

• Flutter provides a rich set of customizable widgets...read more
Answered by AI
Add your answer
Q4. What are statefull and stateless widgets in flutter
Ans. 
Stateful widgets maintain state that might change during the lifetime of the widget, while stateless widgets do not.
• Stateful widgets have a State object that can hold dynamic information and can be updated over time.

• Stateless widgets are immutable and their properties cannot change once they are initialized.

• Examples of stateful widgets include TextField, Checkbox, and Slider.

• Examples of stateless widgets include Text,
Answered by AI
Add your answer