| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Where do you think the users names and passwords will be
stored in sql server? | | 3 |
| How can u convert the Date to String? | TCS | 4 |
| What are the advantages of using stored procedures? Please
don't simply say compilation time will be saved as they are
already complied. Please specify some other advantages. | 247Customer | 3 |
| How to display n-1 columns from n number of columns, from a
single table in MS SQL server 2005? | | 1 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | | 2 |
| What is a view? is View updatable? | IBM | 11 |
| How do you troubleshoot SQL Server if its running very slow? | | 2 |
| Questions regarding Raiseerror? | | 1 |
| What are the main control-of-flow T-SQL constructs?
| | 1 |
| What is the difference between constraints and triggers? | Wipro | 6 |
| What is the system function to get the current user's user
id? | TCS | 3 |
| what is the importence of the trigger in sqlserver2000? | ATI | 1 |
| How To Make password Protected SQL Server 2005 Database
i.e when i open SQL Server database then ask for password.
| | 1 |
| What is the use of placing primary key and foreign key
constrains on columns. | Value-Labs | 2 |
| what is normalization?
what is denormalization?
| Satyam | 5 |
| plz send every query in sql server2000 | Infosys | 1 |
| please tell me the query to get details of the employee
having the second largest salary | 247Customer | 8 |
| write the query for taking database restore in sql? | | 2 |
| How to find the last update record in SQL Server? | | 3 |
| what is index seek and index scan? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |