| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to display n-1 columns from n number of columns, from a
single table in MS SQL server 2005? | | 1 |
| How will u find the query which is running in some other
machine | IBM | 2 |
| what is trigger | NIIT | 1 |
| What are the type of joins? When do we use Outer and Self joins? | | 3 |
| Questions on identity? | Infosys | 1 |
| What types of integrity are enforced by a foreign-key
constraint
| | 1 |
| What's the difference between a primary key and a unique
key? | | 4 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | HCL | 2 |
| What is the role that is required for killing a process
What is the role that is required for creating a linked
server
| IBM | 1 |
| How do you find the number of rows in a table? | | 5 |
| How to delete duplicate records from a table?(for suppose in
a table we have 1000 Records in that we have 200 duplicate
Records , so ,how to findout that duplicate Records , how to
delete those Records and arranged into sequence order? one
more thing that there is no primary key at all) | McAfee | 4 |
| What is the difference between views and stored procedures?
Can we have input parameters for views? | | 3 |
| What is blocking and how would you troubleshoot it? | | 1 |
| if we have a column (Key) in a table.
and values of that column is
Key
1
1
1
2
2
3
3
4
4
5
5
5
and we want to show the data after query..like..
1(3)
2(3)
3(2)
4(2)
5(3)
how many times a single term comes..
| Rolta | 5 |
| Explain the architecture of SQL Server? | | 2 |
| What is referential integrity? What are the advantages of it? | Digital-Domain | 3 |
| How m-m relationships are implemented? | | 1 |
| How can you get @@error and @@rowcount at the same time? | | 5 |
| Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed) | | 5 |
| Wht is Stuff in sql ser | | 1 |
| |
| For more SQL Server Interview Questions Click Here |