| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | HCL | 2 |
| I have student marks in a student table. I need second
highest mark .Then what will the query for this? | Wipro | 21 |
| What is the difference between HAVING clause and the WHERE
clause? | | 4 |
| what is meant by deafult in sql server?
| | 2 |
| how to dispaly a particular row details from a given table | | 1 |
| What is a job? | | 3 |
| What is the appropriate number of test cases that you can
write on a database? | Microsoft | 1 |
| wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records | | 14 |
| how to get 25th row in any table in sqlserver can u tell me
syntax | | 4 |
| Assume,there are three tables in a database, Can i have
both primary key and foreign key for each table in the same
database? | | 4 |
| How do you fine the performance tunning? | Accenture | 2 |
| Can you link only other SQL Servers or any database servers
such as Oracle? | | 1 |
| Advantages and Disadvantages of Cursor? | Zenith | 4 |
| What are the different types of joins and what does each do? | | 2 |
| 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?
| | 3 |
| What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they. | IBM | 5 |
| what is the order of execution of where,having,group by in
select stement | Tanla-Solutions | 4 |
| what is physical sort data and logical sort data in index? | | 1 |
| What is ACID Property of Transaction? | | 3 |
| explain different types of jions with examples briefly? | Zensar | 2 |
| |
| For more SQL Server Interview Questions Click Here |