| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What does it mean to have quoted_identifier on? What are the
implications of having it off? | | 2 |
| Can we have more than one NULL in a column having unique
constraint? | 247Customer | 7 |
| What is the appropriate number of test cases that you can
write on a database? | Microsoft | 1 |
| how many types of store procedre in sqlserver 2000? | ATI | 2 |
| What is the difference between HAVING clause and the WHERE
clause? | | 4 |
| what is the Surrogate key?and wt is the diff between Primary
key and Surrogate Key? | | 2 |
| what is the output for this query
select * from employee where 1=1; | | 4 |
| if we have a column (Key) in a table.
and values of that column is
Key
1
1
1
2
2
3
3
4
4
5
5
5
and we want to show the data after query..like..
1(3)
2(3)
3(2)
4(2)
5(3)
how many times a single term comes..
| Rolta | 5 |
| How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table? | Leo-Technologies | 12 |
| What is the STUFF function and how does it differ from the
REPLACE function? | | 2 |
| what is the difference between Delete and Truncate | Geo-Research-Centre | 3 |
| How do SQL server 2000 and XML linked? | | 2 |
| Table student containing 2 columns,Join date,Employee name.
Under join date 4 rows r ter =1-jan-2008,2-feb-2008,3-mar-
2008,4-feb-2008.Under Employee name 4 difeerent names
jaison,robin,binoy,rahul
Result set is,
Table containing 4-column name=jan,feb,mar,april,,beneath
these months count is given as 1,2,1,0 means these counts
representing number of emplooyees joined in a month(january
1employee,february 2 employee,march 1 employee,april 0
employee)
Can you give me the required sql query | Wipro | 3 |
| Can you explain the role of each service? | | 1 |
| 1.what is stored procedure?Its significance with example?
2.Explain about index with syntax and example?
plz do reply......... | | 1 |
| what is the difference between sql query and google query? | TCS | 7 |
| Explain fundamentals of Data ware housing & OLAP? | | 1 |
| Explain some DBCC commands? | | 4 |
| Is it possible to delete duplicate rows in a table without
using a temporary table ? | | 6 |
| Which virtual table does a trigger use? | TCS | 6 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
