| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| WRITE A FUNCTION TO DISPLAY THE OUTPUT OF AN EXISTING TABLE
RANGE LIKE COMMAM SEPERATED VALUES LIKE RANGE1,RANGE2,... | TVS | 2 |
| Which virtual table does a trigger use? | TCS | 6 |
| Can Somebody tell me the difference between Clustered & Non-
Clustered Index?? | Progressive | 3 |
| About Indexed Views? with example?
plz reply... | | 2 |
| sql server has its default date format in da form "yy-mm-dd"
its possible to convert da current date format of sql
server to desired format. Now my question is dat how to get
da previous and comin days date in my desired format?? | | 1 |
| What meant by Performance Tuning,how can we do the
performance tuning on stored procedures and tell some steps
to do the performance tuning | TCS | 2 |
| Write a query to delete duplicate records in SQL SERVER | Infosys | 19 |
| What are the steps you will take, if you are tasked with
securing an SQL Server?
| HCL | 1 |
| How to determine the service pack currently installed on
SQL Server? | HCL | 4 |
| how to know Who Is Blocking Your SQL Server? | | 3 |
| I have to display ten columns values from diffrent ten
tables.
how many joins are require? | HCL | 8 |
| What is RAID and what are different types of RAID
configurations? | Wipro | 5 |
| i have table students with fields classname,studname
select * from students
classname studname
1 xxxxx
1 yyyy
1 zzzz
2 qqqq
2 tttt
3 dsds
3 www
i want the output should be
No of students in class 1 : 3
No of students in class 2 : 2
No of students in class 3 : 2
| HCL | 2 |
| What's the difference between a primary key and a unique key? | Wipro | 8 |
| What is a join and their types? | Challenger-Financial | 2 |
| explain different types of jions with examples briefly? | Zensar | 1 |
| Differnce between sel server 2000 and 2005 | | 3 |
| What are the differences between stored procedure and
functions in SQL Server 2000? | TCS | 12 |
| what is difference between primary key and Unique | | 8 |
| How to work on DTS?what is the main requirement? | ivan | 1 |
| |
| For more SQL Server Interview Questions Click Here |