| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a Stored Procedure? | | 7 |
| What are explicit and implicit transactions? | | 2 |
| How to find out name of all employees who has salary less
than 200 Rs.? | | 7 |
| What is a function? Give some example? | | 2 |
| What is normalization and its forms? | Challenger-Financial | 3 |
| What is de-normalization and when do you do it? | | 3 |
| Can we use Truncate command on a table which is referenced
by FOREIGN KEY? | | 2 |
| Which command using Query Analyzer will give you the version
of SQL server and operating system? | | 3 |
| any one can explain
Self mapping
Delegation
Remote Credentials | | 1 |
| what is for foreign key ?? | Sabic | 3 |
| can you any body tell me the how to decrease the logfile | | 4 |
| What is the difference between having and where clause? | | 4 |
| Please tell me some knowledge about Clustering and how to
add clustering? | | 1 |
| Is trigger fired implicitely? | | 2 |
| What are the different ways of moving data/databases
between servers and databases in SQL Server? | | 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 |
| event classes in sql server | Accenture | 1 |
| How to delete an attribute from the emp table | | 3 |
| can we call functions from stored procedure in SQL Server
2005 ? How? | | 2 |
| What is the difference between windows authentication and
sql server authentication | HCL | 4 |
| |
| For more SQL Server Interview Questions Click Here |