| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is data integrity? Explain constraints? | Thinksoft | 1 |
| Please give me the SP for the below scenario. I have two
tables named Table1 and Table2...I need to fetch record by
record from Table1 and insert the record in to table2 where
the value in the sno column of the table1 is even number. | Value-Labs | 4 |
| What is the system function to get the current user's user
id? | HCL | 1 |
| What is the difference between a local and a global variable? | | 3 |
| what is the output for this query
select * from employee where 1=1; | | 4 |
| What is a Stored Procedure? | | 7 |
| What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they. | IBM | 5 |
| Can we create clustered index on non primary key column | CTS | 14 |
| What are the different types of backup avaible in SQL SErver | Emphasis | 5 |
| Explain Active/Active and Active/Passive cluster
configurations | | 1 |
| As a part of your job, what are the DBCC commands that you
commonly use for database maintenance? | HCL | 1 |
| How do I compare two values when one value(data type) is
char and the other is an integer? | | 3 |
| what is bit data type? and what are the information that can
be stored inside a bit column? | | 2 |
| select the 3rd maximum salary from sql server database if 4
(just an example In practically I may not know the exact
situation) of the highest salaries are equal. | | 7 |
| What is ACID Property of Transaction? | | 4 |
| How do you load large data to the SQL server database? | | 2 |
| What is difference beteen Migration and Upgrdation? | Satyam | 4 |
| hi, may i know what is the command to get abstract the
current month, current year and current day from a given
date.i want these three in a isolated way..seperatedly is
that any way in sql server 2000 | | 3 |
| in tabase table having a column in it empname field is
there which having 5 duplicate values is there i want
deleted all the duplicates i want showing only one name
only. | | 7 |
| What is the STUFF function and how does it differ from the
REPLACE function? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
