| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is the output for this query
select * from employee where 1=1; | | 4 |
| what are the joins,primary key,foriegn key, candidate key,
super key and expain them? | Polaris | 2 |
| how to select a field with firstletter as capital and
remaining are small letters | | 8 |
| What is a trigger? | | 3 |
| I have a table in which phno is one of the columns.i do have
some values in tht phno column.i need to update phno column
values with 0(zero) as prefix.give me a correct solution plz... | Value-Labs | 5 |
| create index a on employee(dno)
In this,which index was created? | | 2 |
| What is the difference between temp table and table variable? | Microsoft | 4 |
| Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not? | | 3 |
| How to create logins using windows Authentication mode? | | 2 |
| What do you mean by COLLATION? | | 4 |
| Write a query to delete duplicate records in SQL SERVER | Infosys | 19 |
| how to implement locking in sql server | Satyam | 1 |
| How to link up the text file to a Database table? | Allianz | 1 |
| WHAT IS TRIGGERS IN SQL? AND WHAT IS THE BENIFIT? | | 5 |
| what is normalization?
what is denormalization?
| Satyam | 5 |
| Explain Different types of Projects? | | 1 |
| how to generate XML out of QUERY? | McAfee | 1 |
| What is a NOLOCK? | | 3 |
| what is mean by crystal repoart? ahere we will mainly use
that? | | 1 |
| How do we return a record set from a Stored Procedure in SQl
server 2000? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
