TCS iON Interview Questions, Process, and Tips

Q1. SQL Array Oop
Add your answer
Q2. Array defintiion and uses
Ans. 
An array is a data structure that stores a collection of elements of the same data type.
• Arrays are used to store multiple values in a single variable.

• Elements in an array are accessed by their index, starting from 0.

• Example: String[] names = {"Alice", "Bob", "Charlie"};
Answered by AI
Add your answer
Q3. Data structures and its uses
Ans. 
Data structures are used to organize and store data efficiently in computer memory.
• Data structures help in efficient data retrieval, insertion, and deletion operations.

• Examples include arrays, linked lists, stacks, queues, trees, and graphs.

• Each data structure has its own advantages and use cases based on the requirements of the application.

• For example, arrays are used for random access to elements, while linked lists
Answered by AI
Add your answer

Q1. Jump game from leetcode
Add your answer
Q2. Rotation of matrix by 45 degress
Ans. 
To rotate a matrix by 45 degrees, transpose the matrix and then reverse the rows.
• Transpose the matrix

• Reverse the rows of the transposed matrix
Answered by AI
Add your answer

Q1. What is encapsulation in oops?
Ans. 
Encapsulation is the concept of bundling data and methods that operate on the data into a single unit.
• Encapsulation helps in hiding the internal state of an object and restricting access to it.

• It allows for data hiding, which prevents direct access to an object's attributes.

• Encapsulation also enables the concept of data abstraction, where only relevant details are exposed to the outside world.

• By using access modifiers ...read more
Answered by AI
Add your answer
Q2. How do you configure MySQL database ?
Ans. 
MySQL database can be configured using configuration files like my.cnf, command line options, and environment variables.
• Use my.cnf file to configure settings like port number, data directory, and buffer sizes

• Command line options can be used to override settings from my.cnf file

• Environment variables like MYSQL_ROOT_PASSWORD can be used to set passwords during installation
Answered by AI
Add your answer

Multiple-choice question.

Q1. As per interviewer
Add your answer
Q2. As per process
Add your answer

Q1. As per company policy
Add your answer
Q2. Same
Add your answer

TCS NQT consists of MCQ and coding

Q1. Internship expereinces
Add your answer
Q2. I explained my resume
Add your answer

Q1. Is it ok for Reallocation
Ans. 
Yes, reallocation is acceptable in certain situations to optimize resources.
• Reallocation can be acceptable if it helps optimize resources and improve efficiency.

• For example, reallocating server resources to handle increased traffic during peak hours.

• Reallocation should be carefully planned and executed to avoid negative impacts on system performance.

• Regular monitoring and evaluation of the reallocated resources is impo
Answered by AI
Add your answer
Q2. Yes
Add your answer

Q1. SQL window function
Add your answer
Q2. About joins and explain
Add your answer
Q3. Performance optimization
Add your answer
Q4. Normalisation and denormalization
Add your answer

Q1. Why you need job change
Ans. 
Seeking new challenges and growth opportunities in a more senior role.
• Looking for career advancement

• Seeking new challenges and projects

• Interested in expanding skill set and knowledge

• Want to take on more responsibilities and leadership roles
Answered by AI
Add your answer
Q2. Why tcs after a long gap
Ans. 
TCS offers a challenging work environment and opportunities for growth after a long gap.
• TCS is known for its diverse projects and cutting-edge technologies, providing a stimulating work environment.

• After a long gap, I am eager to re-enter the workforce and TCS offers a platform for me to showcase my skills and expertise.

• TCS has a strong reputation in the industry and I believe working here will help me enhance my caree
Answered by AI
Add your answer