| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the difference between DTS and SSIS? | Allianz | 3 |
| select the 3rd maximum salary from sql server database if 4
(just an example In practically I may not know the exact
situation) of the highest salaries are equal. | | 7 |
| Can we have more than one NULL in a column having unique
constraint? | 247Customer | 7 |
| What is a Stored Procedure? | | 7 |
| Is it possible to create tables in stored procedures using
a variable for the table name? | | 2 |
| How do you simulate a deadlock for testing purposes | | 1 |
| what is meant by sql injection with example and one more
question how to catch the errors in sqlserver | | 1 |
| Please give me queries for the following
1. To get the count of duplicate records.
2. A query to delete the duplicate records. | 247Customer | 3 |
| what are three different authentications to connect linked
servers? | CitiGroup | 1 |
| What is ACID Property of Transaction? | | 4 |
| What is Deadlock? | Satyam | 3 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | | 1 |
| is there more the two primary key in a single table? | Systematix | 22 |
| What is normalization in Database ? | | 4 |
| Which system table contains information on constraints on
all the tables created? | | 2 |
| How do you find the error, how can you know the number of
rows effected by last SQL statement? | | 1 |
| What is the datatype returned by count(*) | Asian-CERC | 18 |
| UPDATE statement can on a single table or on the multiple
table? | iGate | 5 |
| How to Run a Query on a Remote SQL Server? | | 2 |
| When do we use the UPDATE_STATISTICS command? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |