| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 1.What is the deferece between DBMS & RDBMS?
2.How can you trouble shoot? If u will get error while
installing sql server?
3.How can u trouble shoot slow running query?
4.how can u trouble log shipping errors?
5.why do we use merge replication instead of T.log
replication? | Microsoft | 4 |
| What do you mean by COLLATION? | | 4 |
| How to find the date and time of last updated table? | | 1 |
| how to write the query to select the rows are in the order
of either 1,3,5,7... or 2,4,6,8,... | ADP | 1 |
| what is normalization?
what is denormalization?
| Satyam | 4 |
| What value could be assigned to Varchar Type? | | 2 |
| Is it possible to create a stored procedure that runs a
query and outputs the results to a text file and allows me
to add extra delimeters and static field info. If so How? | | 1 |
| How to Execute an Operating System Command From Within SQL
Server ? | | 2 |
| What are the types of indexes available with SQL Server? | | 2 |
| The Difference between 'Count' and 'Count(*)' | | 8 |
| What are the OS services that the SQL Server installation adds? | | 1 |
| Can Somebody tell me the difference between Clustered & Non-
Clustered Index?? | Progressive | 3 |
| Which TCP/IP port does SQL Server run on? | | 2 |
| how to find nth highest salary | | 19 |
| what is the difference between sql query and google query? | TCS | 2 |
| PC(code, model, speed, ram, hd, cd, price)
Find the hard drive sizes that are equal among two or more
PCs.
| APX | 1 |
| how to find out the repeated value from table using groupby
function? | | 3 |
| one table has four field id,name,design,salary. i have to
find maximum salary . | | 6 |
| What is the use of DBCC commands? | | 1 |
| How do SQL server 2000 and XML linked? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |