| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| can you any body tell me why are go for the rebuild the
master database.what is the reason? | | 1 |
| I have a table EMP in which the values will be like this
EmpId Ename Sal DeptId
11 Ram 10000 10
11 Ram 10000 10
22 Raj 20000 20
22 Raj 20000 20
33 Anil 15000 30
33 Anil 15000 30
I want to delete only duplicate Rows. After Delete I want
the output like this
EmpId Ename Sal DeptId
11 Ram 10000 10
22 Raj 20000 20
33 Anil 15000 30
| DELL | 10 |
| write down the sql query?
Table Name : emp1
empid empname
1 bala
2 guna
Table Name : emp2
empid empname
1 <Null>
2 <Null>
Solution : emp1 names are updated in emp2, write a query?
| | 7 |
| What is the STUFF function and how does it differ from the
REPLACE function? | | 2 |
| How to work on DTS?what is the main requirement? | ivan | 1 |
| How can i give the restrictions for the data entry, if i
wish to enter only I ,II, III, IV in the grade actegory of
student table? | | 3 |
| Explain DBMS, RDBMS? | | 4 |
| What about UPDATESTATISTICS ? | Intelligroup | 2 |
| what is web server?
| Satyam | 3 |
| What is normalization? | | 6 |
| Explain different isolation levels? | | 3 |
| How m-m relationships are implemented? | | 1 |
| In which year relase the 7.0& 2000 & 2005? | | 1 |
| Explain some DBCC commands? | | 4 |
| create procedure proc1 (@a int)
as
begin
if @a=1
create table #temp(a1 int)
else
create table #temp(a1 int)
end
while executeing the above code it shows error
like '#temp already exist' .why it shows an error? | IBM | 5 |
| What are the types of backup and tell me the difference
between full and differential backup? | TCS | 3 |
| Difference between writing SQL query and stored procedure ? | Cognizent | 8 |
| What are defaults? Is there a column to which a default
can't be bound? | | 2 |
| How do we get month name in SQL Server 2000, Oracle, MS Access? | | 9 |
| wat is the main diff between sql server 2000and sql server 2005 | Jade-Software | 6 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
