| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 1.what is stored procedure?Its significance with example?
2.Explain about index with syntax and example?
plz do reply......... | | 1 |
| Can Somebody tell me the difference between Clustered & Non-
Clustered Index?? | Progressive | 3 |
| How to link up the text file to a Database table? | Allianz | 1 |
| what are three different authentications to connect linked
servers? | CitiGroup | 1 |
| how can u select the Distinct values in the table, table
having 20 columns , i want all columns | | 1 |
| How to delete an attribute from the emp table | | 3 |
| What is the difference between a Local temporary table and a
Global temporary table? How is each one used? | | 1 |
| Can you explain the role of each service? | | 1 |
| Explain basic SQL queries with SELECT from where Order By,
Group By-Having? | Wipro | 2 |
| 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 |
| How do you check the performance of a query and how do you
optimize it? | | 1 |
| What are the differences between stored procedure and
functions in SQL Server 2000? | TCS | 12 |
| Which is best Subquery (or) joins in sql server? explain why | | 2 |
| Can you link only other SQL Servers or any database servers
such as Oracle? | | 1 |
| how to write the query to select the rows are in the order
of either 1,3,5,7... or 2,4,6,8,... | ADP | 5 |
| What is the difference between truncate and delete statement? | CTS | 4 |
| how to delete duplicate rows from table in sql server | HCL | 8 |
| What is the difference between 2-Tier architecture and
3-Tier architecture | Oracle | 10 |
| What is a function? Give some example? | | 2 |
| plz send every query in sql server2000 | Infosys | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
