| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what are file groups? | Evalueserve | 3 |
| What are mdf,ndf,ldf files and how to see the data in those
files? | Accenture | 5 |
| What are primary keys and foreign keys? | | 3 |
| Can we call SP inside a query? | Wipro | 4 |
| what is a cursor and what is its use? | | 1 |
| How are SQL Server databases physically stored under
Windows 2000? | | 1 |
| can we call stored Procedure in Function in Sql Server 2000
and vice versa. | eSoft | 2 |
| Can Having clause be used without Group by clause? | CTS | 4 |
| 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 |
| 1.What is the deferece between DBMS & RDBMS?
2.How can you trouble shoot? If u will get error while
installing sql server?
3.How can u trouble shoot slow running query?
4.how can u trouble log shipping errors?
5.why do we use merge replication instead of T.log
replication? | Microsoft | 4 |
| How can i change the column name. | HCL | 7 |
| Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not? | | 3 |
| Can anybody explain me cold backup and hot backup?
| TCS | 3 |
| Well sometimes sp_reanmedb may not work you know because if
some one is using the db it will not accept this command so
what do you think you can do in such cases? | | 2 |
| how many joins we can write if at all we have n no of
tables | Tanla-Solutions | 4 |
| Can we have more than one NULL in a column having unique
constraint? | 247Customer | 7 |
| can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com | Symphony | 21 |
| How can your resolve deadlocks? | IBM | 3 |
| what is the order of execution of where,having,group by in
select stement | Tanla-Solutions | 5 |
| plz tell me the new features of
sqlserver2000,sqlserver2002,sqlserver2005 | | 3 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
