| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| from the table display the 2nd highest salary?
and also the least 2nd salay?
| | 3 |
| Explian different types of BACKUPs avaialabe in SQL Server?
Given a particular scenario, how would you go about
choosing a backup plan?
| HCL | 2 |
| what is the purpose of creating view is sql server 2000 | Wipro | 7 |
| What is RAID and what are different types of RAID
configurations? | Wipro | 5 |
| Which is the subset of SQL commands used to manipulate
Oracle Database structures, including tables? | | 2 |
| how many type of subquery? | | 2 |
| What is a join and their types? | Challenger-Financial | 2 |
| what are batch in sql server?
| Satyam | 2 |
| can anybody tell us, how to select 2nd max salary from
table.
my id is ashish.akk@gmail.com | Symphony | 21 |
| select empid empname from employee
What is the result for the about query? | | 3 |
| IN Vs OR operator which is best to use sql server. | | 3 |
| What is the difference between IN and EXISTS operators in
SQL Server? | Intelligroup | 3 |
| can we call functions from stored procedure in SQL Server
2005 ? How? | | 2 |
| 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 do we rollback the table data in SQL Server | | 3 |
| write query for fourth maximum salary from employee table | Mind-Tree | 5 |
| i want to join two queries....and i want to run them as one
after another that is want output of first query then
second , then again output of first query then second and
so on... | | 2 |
| What's the difference between a primary key and a unique
key? | | 4 |
| What are constraints? Explain different types of
constraints? | | 5 |
| Using query analyzer, name 3 ways you can get an accurate
count of the number of records in a table? | eFunds | 4 |
| |
| For more SQL Server Interview Questions Click Here |