| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a Join in SQL Server? | | 1 |
| How to write query to Delete the records in child table
and corresponding records in parent table | Semantic-Space | 7 |
| 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 the difference between a Application Server and a
Database | Oracle | 1 |
| what are three different authentications to connect linked
servers? | CitiGroup | 1 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL?
| HCL | 3 |
| how can i view structure of table in sql server? tell me
that query. | | 2 |
| What is mean by "fill factor" ? and what is mean
by "Index "in sql? | Logica-CMG | 1 |
| Wht is Stuff in sql ser | | 1 |
| Name three version of sql server 2000 and also their
differences? | | 1 |
| SYNTAX FOR VIEWS WITH EXAMPLE
HOW TO LINK TWO TABLES | Microsoft | 1 |
| 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 is The Use Of TIMESTAMP DataType in SQL Server 2005?
| | 2 |
| What is a stored procedure? | | 3 |
| could u plz explain about joins and views? | | 2 |
| How to Debug a Stored Procedure? | Allianz | 3 |
| what are the problems in logshipping? | | 2 |
| Write a query to delete duplicate records in SQL SERVER | Infosys | 16 |
| Assume,there are three tables in a database, Can i have
both primary key and foreign key for each table in the same
database? | | 4 |
| What is the difference between OLEDB and ODBC | CFCI | 2 |
| |
| For more SQL Server Interview Questions Click Here |