| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement | | 2 |
| What is ACID Property of Transaction? | | 4 |
| What is a materialized view? | | 2 |
| Advantages and Disadvantages of Cursor? | Zenith | 10 |
| I have a table in which phno is one of the columns.i do have
some values in tht phno column.i need to update phno column
values with 0(zero) as prefix.give me a correct solution plz... | Value-Labs | 5 |
| What is data integrity? Explain constraints? | Thinksoft | 1 |
| How can I know what query is executing by by a particural
user? (using sp id or any othe way.) | | 2 |
| Which data type can be used only on OUTPUT parameters of the
stored proceduer? | | 2 |
| i want to join two queries....and i want to run them as one
after another that is want output of first query then
second , then again output of first query then second and
so on... | | 2 |
| What is a Join in SQL Server? | | 2 |
| What are Sql Reporting Services and analysis services? Can
u Explain | | 1 |
| how do we find every fifth record in a table | | 11 |
| can you any body tell me why are go for the rebuild the
master database.what is the reason? | | 1 |
| What are SQL Jobs, please mention the use of it and how to
create them. | 247Customer | 1 |
| What are the types of indexes available with SQL Server? | | 2 |
| Accidentally i deleted my table. How can i get that table? | | 4 |
| Rate yourself in .NET and SQL ? | Cognizent | 1 |
| How do you read transaction logs | | 1 |
| how to give input dynamically to a insert statement in
sqlserver | HCL | 2 |
| MULTICAST DELEGATES IN C#.NET WITH REAL TIME EXAMPLE | IBM | 1 |
| |
| For more SQL Server Interview Questions Click Here |