| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
| HCL | 3 |
| In performance wise distinct is good or group by is good?
eg:select name from emp group by name;
select distinct name from emp; | Infosys | 4 |
| What is the Query of getting last 10 transaction Reports
(like insert, update, Delete Data from Tabele) ? | Wipro | 4 |
| I have student marks in a student table. I need second
highest mark .Then what will the query for this? | Wipro | 23 |
| what are batch in sql server?
| Satyam | 2 |
| Can you explain the types of Joins that we can have with Sql
Server? | | 2 |
| How to perfor If the table running time is taking 2hours
and table is having 10 rows in it? | | 1 |
| There is table like Events...in that name ,startdate
,enddate,location are the column names
write a stored Procedure for this table to get events by
Months "GetEventsByMonths" | | 1 |
| How are SQL Server databases physically stored under
Windows 2000? | | 1 |
| How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
| Oracle | 18 |
| to explain sql server 2000 architecture & authentication | | 1 |
| wt is mean by acid property? i know it is
atomocity,consistency,isolation and durabulaty but wt is
these mean and wt actions it's perform | Idea | 1 |
| How can we write or define DDL statements in Sql server and
DML statements? | | 2 |
| Can you explain the role of each service? | | 1 |
| Wht is the difference between stored procedure and trigger | TCS | 4 |
| Can some one please help with a query which will take only
max value of a column in a join. | | 2 |
| Please give me queries for the following
1. To get the count of duplicate records.
2. A query to delete the duplicate records. | 247Customer | 3 |
| What are the different types of backup avaible in SQL SErver | Emphasis | 5 |
| If there is failure during updation of certain rows, what
will be the state? | | 1 |
| how to retrive only second row from table in sql server
2000? | CTS | 7 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
