TCS Technology Analyst Interview Questions and Answers

Q1. In SQL, Union will have sorted records or not
Add your answer
Q2. Queries related highest salary emplyee
Add your answer

It was a multiple questions test, 90 minutes test 43 questions technical question based on the position i have applied. It is intermediate level of test. I have cleared the test.

Q1. After completed my Assessment test , I got a call from HR for technical round through WebEx. Yesterday interview done in that call panel asked about my role of my current company and asked about my project...read more
Add your answer
Q2. Put vs patch in restful
Ans. 
In RESTful APIs, 'put' is used to update an entire resource, while 'patch' is used to update only specific fields of a resource.
• PUT is used to update the entire resource, while PATCH is used to update specific fields

• PUT requires the client to send the entire updated resource, while PATCH only requires the client to send the specific fields to be updated

• PUT is idempotent, meaning multiple identical requests will have th...read more
Answered by AI
View 1 more answer
Q3. Different between restful and webclient
Ans. 
Restful is an architectural style for designing networked applications, while WebClient is a class in Java used for making HTTP requests.
• RESTful is an architectural style that uses HTTP methods like GET, POST, PUT, DELETE to perform operations on resources.

• WebClient is a class in Java that provides a higher-level API for making HTTP requests and handling responses.

• RESTful APIs are stateless and use standard HTTP status...read more
Answered by AI
Add your answer
Q4. Serialization and deserialization in java
Ans. 
Serialization is the process of converting an object into a byte stream, while deserialization is the process of converting a byte stream back into an object in Java.
• Serialization is achieved by implementing the Serializable interface in Java.

• Deserialization is done by reading the byte stream and reconstructing the object using the readObject() method.

• Example: ObjectOutputStream for serialization and ObjectInputStream
Answered by AI
View 1 more answer
Q5. What are functional interface in java8
Ans. 
Functional interfaces in Java 8 are interfaces with a single abstract method, used for lambda expressions and method references.
• Functional interfaces have only one abstract method, but can have multiple default or static methods.

• They can be used with lambda expressions and method references.

• Examples include java.lang.Runnable, java.util.Comparator, and java.util.function.Predicate.
Answered by AI
View 1 more answer

Basic technical questions

Q1. Exepected salary?
Add your answer

Case study on HRMS platform

Q1. Personality ques
Add your answer
Q2. Culture fit ques
Add your answer

Q1. Substring, collection, sql from creating table to all queries will ask to write
Add your answer
Q2. They ask to one notepad write prime example and example it.
Add your answer

Q1. Write substring, sql quire and prime no explain it
Ans. 
Substring is a part of a string, SQL query is used to retrieve data from a database, and prime numbers are numbers divisible only by 1 and themselves.
• Substring: a portion of a string, specified by its starting and ending indices

• SQL query: a statement used to retrieve data from a database, using SELECT, FROM, WHERE, and other clauses

• Prime numbers: numbers that are only divisible by 1 and themselves, such as 2, 3, 5, 7,
Answered by AI
Add your answer