| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Name three version of sql server 2000 and also their
differences? | | 1 |
| i have 4 tables.. T1, T2, T3, T4..
these tables have the same structure and they store the
information entered in different years..
T1 stored 2002, T2 stored 2003, T3 stored 2004 and T4 stored
2005..
i want to copy contents in T1 to T2, T2 to T3, T3 to T4 and
T4 to T1..
how do i do that? Temp tables cannot be used.. | | 2 |
| How do you read transaction logs | | 1 |
| What is INTVAL( )and where we use
Plz any body help me | | 1 |
| Display a roll having miminum marks in two subjects? | Patni | 7 |
| hi i gone though satyam interview.
what is Acid Properties?
| Satyam | 2 |
| Explain Active/Active and Active/Passive cluster
configurations? | | 1 |
| How to count the number of duplicate items in a table? | | 1 |
| What is Deadlock? | Satyam | 3 |
| what is the main difference between after trigger and
instead trigger. | | 1 |
| 1.what is the difference between view and cursor?
2.If we do any change in view will it affect the
database,similarly when we do changes in cursor will it
affect the databse?with certain example?Thanks
| | 3 |
| What is the difference between login and a user? | TCS | 7 |
| What types of integrity are enforced by a foreign-key
constraint | | 1 |
| WHAT IS UNIQUE IDENTIFIER DATA TYPE? | Sparsh | 2 |
| What is normalization in Database ? | | 4 |
| how to find number of columns in a table in sql server 2000
and 2005 also | Virtusa | 7 |
| How can count the string ?
for ex: If i have string like 'bhaskar' then i need like
b:1
h:1
a:2
s:1
k:1
r:1
please give any idea on that
| TCS | 5 |
| What are the different types of joins and what does each do? | | 2 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| What are the main control-of-flow T-SQL constructs?
| | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
