| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Can you explain the types of Joins that we can have with Sql
Server? | | 2 |
| what is index seek and index scan? | | 2 |
| How to give a user the option of importing Excel and a
delimited text file into a SQL Server Database without
manually using SQL DTS?
| GE | 1 |
| what is the query and condition to delete datas in sql
server. | | 2 |
| Explain different isolation levels? | | 3 |
| what is the maximum size of a row in sql server 2000 and 2005 | | 2 |
| write down the code for "how we delete a table without
using of Drop command " ? | Sonata | 2 |
| What is the datatype returned by count(*) | Asian-CERC | 18 |
| What is lock escalation? | | 1 |
| How can you see what type of locks used? | | 1 |
| What is a cursor in SQL Server 2000 and their types? | | 4 |
| How do we rollback the table data in SQL Server | | 3 |
| How can we write or define DDL statements in Sql server and
DML statements? | | 2 |
| can primery key be a non clustered index? | | 8 |
| when we use function instead of procedure? plz tell me the
situation with ex? | | 1 |
| WHAT OPERATOR PERFORMS PATTERN MATCHING? | CTS | 2 |
| what is Data Transformation Services (DTS) ?can u explain
me in detail? | TCS | 5 |
| Questions on identity? | Infosys | 1 |
| Lets say due to N/W or Security issues client is not able to
connect to server or vice versa. How do you troubleshoot? | | 1 |
| what is Archive old data? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |