| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the steps you will take to improve performance of
a poor performing query? | HCL | 1 |
| when inserting to a table how many rows will be effected
using triggers
| | 1 |
| Rate yourself in .NET and SQL ? | Cognizent | 1 |
| Explain Active/Active and Active/Passive cluster
configurations | | 1 |
| explain different types of jions with examples briefly? | Zensar | 2 |
| syntax for deleting the database in T SQL | | 4 |
| Is it possible to have more then one foreign key in a
single table? if possible, is this the good way to design
the table? | | 2 |
| What is the system function to get the current user's user
id? | TCS | 3 |
| could u plz explain about joins and views? | | 2 |
| what is curser. | | 9 |
| How do you load large data to the SQL server database? | | 2 |
| Can we have more than one NULL in a column having unique
constraint? | 247Customer | 7 |
| What are the differences between stored procedure and
functions in SQL Server 2000? | TCS | 12 |
| Hello all,
I have data like :-
year amt
2004 10
2005 20
2006 30
Now i want output as:-
2004 2005 2006
10 30 60
but i have to use here group by on year.So, i need a single
query within that i can find.
| | 2 |
| what is bit data type? and what are the information that can
be stored inside a bit column? | | 2 |
| What are the new features in SQL Server 2005? | Emphasis | 2 |
| Can a stored procedure call another stored procedure. If yes
what level and can it be controlled? | | 2 |
| Explain the basic concepts of SQL server architecture? | | 2 |
| 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 |
| Which is the subset of SQL commands used to manipulate
Oracle Database structures, including tables? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
