| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how to implement locking in sql server | Satyam | 1 |
| Why we need a group by clause? | | 3 |
| Write a query to delete duplicate records in SQL SERVER | Infosys | 19 |
| What is a view? | | 4 |
| A table contains list of customers and his city with other
details. Each customer has a unique number and the table
consists millions of data. Query is: I want to retrieve 10
customers from each city, no script, only from single query? | Infosys | 3 |
| what is trigger | NIIT | 1 |
| What is WITH CHECK OPTION | Karur-Vysya-Bank-KVB | 2 |
| Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement | | 2 |
| What are three SQL keywords used to change or set someone?s
permissions? | | 3 |
| What is a materialized view? | | 2 |
| What is difference between Triggers and store procedure? | | 2 |
| What is blocking and how would you troubleshoot it? | | 1 |
| What are the four main query statements? | | 3 |
| What is the difference between a Local temporary table and a
Global temporary table? How is each one used? | | 1 |
| What is a NOLOCK? | | 3 |
| we have emp table like Ename,EDOJ,EDOB with Column
structure.but we want to know the employee Age.How? Any
Body Plz | | 6 |
| What is the difference between a Application Server and a
Database | Oracle | 2 |
| what are the problems in logshipping? | | 2 |
| How to tune a stored procedure? | | 5 |
| What is a join and their types? | Challenger-Financial | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
