For all the software developers interested in working on SQL server, we bring you a set of interview questions asked by one of the top IT giants – Tech Mahindra. These questions have been posted by techies – who are presently working with Tech Mahindra, or have previously worked with the IT giant.
1. What is the framework?
2. Differentiate between response.write() and server.transfer() in asp.net?
3. Where are connection strings stored?
4. What is a transaction ? Give me one example.
5. How to replace double quotes by single quotes in SQL server.
6. What are the advantages of using SQL server over MS access or why should one use SQL instead of MS access?
7. What is the difference between Triggers and Stored Procedure?
8. How does -818 SQL error occur? Why does it happen and what can be done to overcome this error code?
9. Write SQL query for retrieving employee names from employee table who are having a salary greater than 5000 10. without using where clause?
11. What are the new enhancements in SQL server 2005?
12. Where does Profiler store its temporary data in SQL Server 2005?
13. What is the use of SQL Profiler?
14. How to avoid using cursors? What to use instead of cursor and in what cases to do so?
15. What is the basic structure of PL/SQL?
