TCS IT Analyst Interview Questions, Process, and Tips

Simple Aptitude Questions

Q1. SDLC and DSA questions are asked
Add your answer

Q1. What are the advantages of spring boot?
Ans. 
Spring Boot offers advantages such as rapid development, easy configuration, and built-in features.
• Rapid development due to auto-configuration and starter dependencies

• Easy configuration with minimal XML configuration and annotations

• Built-in features like embedded servers, metrics, and health checks

• Support for microservices architecture and cloud deployment

• Integration with popular frameworks like Spring Cloud, Hibernate
Answered by AI
Add your answer
Q2. What are the constraints in sql?
Ans. 
Constraints in SQL are rules and restrictions that are applied to columns in a table to ensure data integrity and consistency.
• Constraints ensure data accuracy and consistency in a database

• Common constraints include NOT NULL, UNIQUE, PRIMARY KEY, FOREIGN KEY, CHECK, and DEFAULT

• NOT NULL constraint ensures a column cannot have a NULL value

• UNIQUE constraint ensures all values in a column are unique

• PRIMARY KEY constraint un...read more
Answered by AI
Add your answer

Q1. Asked about xpath, bdd
Add your answer

Q1. Solid principles, oops
Add your answer

Q1. Azure devops, Jenkins, ARM templates, terraform
Add your answer

Q1. Different join query example
Ans. 
Different join query examples in SQL
• INNER JOIN: Returns rows when there is at least one match in both tables

• LEFT JOIN: Returns all rows from the left table and the matched rows from the right table

• RIGHT JOIN: Returns all rows from the right table and the matched rows from the left table

• FULL OUTER JOIN: Returns rows when there is a match in one of the tables
Answered by AI
Add your answer