| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| can you anybody tell me the how can you restore the master
database. while migraion(one server to onther server)? | | 1 |
| what is differece between union and union all | | 4 |
| Explain sp_configure commands, set commands? | | 3 |
| Is it possible to delete duplicate rows in a table without
using a temporary table ? | | 6 |
| What is the differecne between equi-join and inner-join and
natural join..Is there any difference or all are same? | Microsoft | 2 |
| Questions on identity? | Infosys | 1 |
| Explain the new features of SQL server 2000? | | 1 |
| how to retrive only second row from table in sql server
2000? | CTS | 7 |
| Difference between Function and Procedure-in general? | | 3 |
| write query for fourth maximum salary from employee table | Mind-Tree | 5 |
| What are the steps you will take, if you are tasked with
securing an SQL Server?
| HCL | 1 |
| please tell me the query to get details of the employee
having the second largest salary | 247Customer | 8 |
| What is the difference between DTS and SSIS? | Allianz | 3 |
| What should we do to copy the tables, schema and views from
one SQL Server to another? | | 3 |
| what is index seek and index scan? | | 2 |
| there is a table having two columns no and name
and the data is
1 A
2 B
3 C
write a query that will result a horizontal output
A,B,C
| vsworx | 7 |
| If you are working on a SQL database and if suddenly a
developer changes the code and your queries results start
giving errors,how will you check using a T-SQL query (on
system tables) that what has changed in the database. | Microsoft | 2 |
| There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better? | | 1 |
| What is the use of placing primary key and foreign key
constrains on columns. | Value-Labs | 2 |
| Define candidate key, alternate key, composite key. | | 9 |
| |
| For more SQL Server Interview Questions Click Here |
Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff 
Site Map
