| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to write stored procedure to update the data in 10
tables | | 3 |
| What is normalization? | | 5 |
| How to count the number of duplicate items in a table? | | 1 |
| Explain Active/Active and Active/Passive cluster
configurations | | 1 |
| What is a Join in SQL Server? | | 1 |
| what is curser. | | 7 |
| could u plz explain about joins and views? | | 2 |
| What is a Stored Procedure? | | 5 |
| Can a stored procedure call itself(recursive). If yes what
level and can it be controlled.? | | 2 |
| can we call functions from stored procedure in SQL Server
2005 ? How? | | 2 |
| What are Sql Reporting Services and analysis services? Can
u Explain | | 1 |
| Wht is SQL Injection Attack ? | | 1 |
| any one can explain
Self mapping
Delegation
Remote Credentials | | 1 |
| difference between sql server2000 and sql server2005
| | 1 |
| Is trigger fired implicitely? | | 2 |
| What is the difference between distinct clause and group by
clause? | Value-Labs | 1 |
| I need a query that retrieves info from an Oracle table and
a query that retrieves info from a SQL Server table. The
info has to be joined together according to Record ID
numbers. I have very limited access to the Oracle database
but full control of the SQL Server database.How do I join
two different queries from two different databases?
| | 1 |
| explain different types of jions with examples briefly? | Zensar | 2 |
| How will u get 5 years back record? | | 3 |
| How to Get the last identity value used | | 3 |
| |
| For more SQL Server Interview Questions Click Here |