| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the advantages of using stored procedures? Please
don't simply say compilation time will be saved as they are
already complied. Please specify some other advantages. | 247Customer | 3 |
| What is a cursor in SQL Server 2000 and their types? | | 4 |
| what is the Surrogate key?and wt is the diff between Primary
key and Surrogate Key? | | 2 |
| What is an extended Stored Procedure? | | 1 |
| you are provided with the single table having say 4 col ie
fname lname age city , now the all records with displying of
only fname and lname is required but in this format say my
name is abhay khanna it will come like this
abhay-khanna
rahul-roy
gaurav-singh
the above format is required | | 2 |
| What is the system function to get the current user's user
id? | HCL | 1 |
| What r sql reporting services and analysis services? how
can we use it. | Microsoft | 2 |
| how to count datewise data in sqlserver | IndusInd-Bank | 3 |
| In which year relase the 7.0& 2000 & 2005? | | 1 |
| hi i gone though satyam interview.
what is Acid Properties?
| Satyam | 2 |
| how to select 5 to 7 rows from a table, which contains 10 rows? | IBM | 14 |
| Explain different isolation levels? | | 3 |
| write the query for taking database restore in sql? | | 2 |
| what is the cursor life span? | Evalueserve | 5 |
| As a part of your job, what are the DBCC commands that you
commonly use for database maintenance? | HCL | 1 |
| what is the maximum size of a row in sql server 2000 and 2005 | | 2 |
| What is a sub-query? When would you use one? | | 3 |
| what is hash table | Teledata | 2 |
| What do u mean by orphan users, how will u list them in the
DB | IBM | 2 |
| 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 |
| |
| For more SQL Server Interview Questions Click Here |