[go: up one dir, main page]
Scribd
Upload
112 views2 pages

TCS SQL Question

The document lists 43 questions related to databases and SQL. Some of the questions ask about normal forms, relationships between tables, transactions, backups, joins, indexes, stored procedures, triggers and performance tuning. Other questions ask about data modeling, differences between SQL queries and stored procedures, and how to write queries to find highest salaries or duplicate data.

Uploaded by

uttkarsh singh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
112 views2 pages

TCS SQL Question

The document lists 43 questions related to databases and SQL. Some of the questions ask about normal forms, relationships between tables, transactions, backups, joins, indexes, stored procedures, triggers and performance tuning. Other questions ask about data modeling, differences between SQL queries and stored procedures, and how to write queries to find highest salaries or duplicate data.

Uploaded by

uttkarsh singh
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 2

TCS Database Interview Question

1. Is it possible to delete duplicate rows in a table without using a temporary table?


2. What is better - 2nd Normal form or 3rd normal form? Why?
3. Which virtual table does a trigger use?
4. Which command displays the SQL command in the SQL buffer, and then executes it?
5. Difference between writing SQL query and stored procedure?
6. How do you implement one-to-one, one-to-many and many-to- many relationships while
designing tables?
7. What are defaults? Is there a column to which a default can't be bound?
8. What is a transaction and what are ACID properties?
9. What is the system function to get the current user's user id?
10. What are the differences between stored procedure and functions in SQL Server 2000?
11. Can anybody explain me cold backup and hot backup?
12. What is Data Transformation Services (DTS) ?can u explain me in detail?
13. What is normalization? Can u explain me in detail?
14. What are the all different types of Joins in SQL Server 2000, Anybody can explain each
join with definition. Thanks in advance....
15. write the query for find the top 2 highest salary in sql server
16. HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE
17. What are questions asked in TCS for database tester (sqlserver) for 2-3 exp?
18. MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE
19. UPDATE statement can on a single table or on the multiple table?
20. Advantages and Disadvantages of Cursor?
21. What is the difference between sql query and google query?
22. How can u convert the Date to String?
23. What is deadlock and how to avoid the deadlocks?
24. What are the types of model in sql server and explain
25. What is the difference between stored procedure and trigger
26. What are the types of backup and tell me the difference between full and differential
backup?
27. What is the difference between login and a user?
TCS Database Interview Question

28. What meant by Performance Tuning, how can we do the performance tuning on stored
procedures and tell some steps to do the performance tuning
29. How to write a script for upate the data in prod , I have 50000 row are there
30. Can foreign key take role of primary key?
31. What is Data model and how to prepare a data model.?
32. What is the difference between MVC and Teir Architecher? Plz explain with Layyered
Programming example...?
33. How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1
a:2 s:1 k:1 r:1 please give any idea on that
34. Select the 3rd maximum salary from sql server database if 4 (just an example In
practically I may not know the exact situation) of the highest salaries are equal.
35. Which database is best to use in oracle and sql server? explain reasons?
36. Why we use cursor?
37. If we have a column (Key) in a table. and values of that column is Key 1 1 1 2 2 3 3 4 4 5
5 5 and we want to show the data after query..like.. 1(3) 2(3) 3(2) 4(2) 5(3) how many
times a single term comes..
38. What is execution Plan in sql server
39. What is Index Segmentation ?
40. If we shrink the Databse and Files, how much size is decreased?
41. In which situation you use Self joins?
42. What is mean by trigger?.......normally wat use......when trigger used in sql........... plz
clearly say with example.......
43. In join, which clause in not used?

You might also like