| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| can anyone explain me the concept of Serialization in Detail
and Clear? plz its urgent i have interview on friday (15th feb) | | 1 |
| what is the importence of the trigger in sqlserver2000? | ATI | 1 |
| What are the main control-of-flow T-SQL constructs?
| | 1 |
| How do you troubleshoot SQL Server if its running very slow? | | 2 |
| 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 |
| Can we create clustered index on non primary key column | CTS | 11 |
| SYNTAX FOR VIEWS WITH EXAMPLE
HOW TO LINK TWO TABLES | Microsoft | 1 |
| Difference between server.transfer and server.execute method? | | 1 |
| What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table | HP | 12 |
| 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 are the types of backup and tell me the difference
between full and differential backup? | TCS | 3 |
| What are the advantages of using sql server over ms access
or why should one use sql instead of ms access | Impetus | 1 |
| How to determine the service pack currently installed on
SQL Server? | HCL | 2 |
| How do we get month name in SQL Server 2000, Oracle, MS Access? | | 4 |
| Differnce between sel server 2000 and 2005 | | 3 |
| how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server. | IBM | 3 |
| What is the STUFF function and how does it differ from the
REPLACE function? | | 1 |
| syntax for deleting the database in T SQL | | 3 |
| What are the steps you will take to improve performance of
a poor performing query? | HCL | 1 |
| How do we get current date in SQL Server 2000, Oracle, MS
Access? | | 10 |
| |
| For more SQL Server Interview Questions Click Here |