TCS SQL Developer Interview Questions, Process, and Tips

Q1. Write sql queries for certain questions where analytical functions were involved, CTE based questions, scenario based questions, project-related questions.
Add your answer
Q2. Behavioral questions
Add your answer
Q3. Why do you want to join?
Add your answer

Q1. Details about oneself
Add your answer

Q1. BAsed on sql logics
Add your answer
Q2. Dbms concepts like ACID
Add your answer

Q1. What is SQL server
Ans. 
SQL Server is a relational database management system developed by Microsoft.
• Developed by Microsoft

• Used for managing relational databases

• Supports T-SQL (Transact-SQL) language

• Provides tools for data storage, retrieval, and manipulation
Answered by AI
Add your answer
Q2. What is the join
Ans. 
Join is a SQL operation used to combine rows from two or more tables based on a related column between them.
• Joins are used to retrieve data from multiple tables based on a related column

• Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column
Answered by AI
Add your answer

Q1. Sql server,ssis,ssrs, Power bi,adf
Add your answer

Q1. Introduction person details
Add your answer

Q1. Different joins
Ans. 
Different types of joins in SQL include inner join, left join, right join, and full outer join.
• Inner join: Returns rows when there is a 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 all rows when there is a match in either table
Answered by AI
Add your answer
Q2. Basic to advance queries
Add your answer

I attended off campus recruitment .wrote exam at tcs ion center

I attended for off campus recruitment and wrote the test

Q1. What is a primary key
Ans. 
A primary key is a unique identifier for a record in a database table.
• A primary key must be unique and not null.

• It ensures the uniqueness and integrity of data in a table.

• Primary keys are used to establish relationships between tables.

• Examples of primary keys include social security numbers, email addresses, or auto-incremented IDs.
Answered by AI
View 1 more answer
Q2. How do you delete the records in a table
Ans. 
To delete records in a table, use the DELETE statement with the WHERE clause to specify the condition for deletion.
• Use the DELETE statement followed by the table name

• Add the WHERE clause to specify the condition for deletion

• Execute the query to delete the records
Answered by AI
View 2 more answers
Q3. Write fibanocci series code
Ans. 
Code to generate Fibonacci series
• Start with 0 and 1 as the first two numbers

• Add the previous two numbers to get the next number in the series

• Repeat until desired number of terms is reached
Answered by AI
Add your answer
Q4. Explain about your project
Add your answer
Q5. What is a unique key
Ans. 
A unique key is a column or a set of columns in a database table that uniquely identifies each row.
• A unique key ensures that no two rows in a table have the same values for the specified column(s).

• It is used to enforce data integrity and prevent duplicate entries.

• A table can have multiple unique keys, but each unique key can only have one row with a specific set of values.

• Unique keys can be used as a reference for rela
Answered by AI
View 1 more answer