| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Explain some DBCC commands? | | 4 |
| how can we use a composite key for two tables and how can
we represent it | BoA | 1 |
| Can I remove the default constraint columns in SQL SERVER? | Value-Labs | 3 |
| 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 | 5 |
| The Difference between 'Count' and 'Count(*)' | | 12 |
| What is the difference between OLEDB and ODBC | CFCI | 3 |
| how to copy sysdatabase file from c: Drive to D: Drive in
SQL Server. | IBM | 4 |
| what is a cursor and what is its use? | | 1 |
| How to find the date and time of last updated table?
| | 2 |
| can you any body tell me why are go for the rebuild the
master database.what is the reason? | | 1 |
| plz tell me the new features of
sqlserver2000,sqlserver2002,sqlserver2005 | | 3 |
| how to connect sybase to sql server 2005?. | ABC | 1 |
| What are the different types of replication? How are they used? | | 3 |
| What are the advantages of using views. Why do we need
views when we have SPs? | 247Customer | 3 |
| What is data integrity? Explain constraints? | Thinksoft | 1 |
| how to rest identity columns in sql server | Matrix | 3 |
| how can i view structure of table in sql server? tell me
that query. | | 4 |
| What is the difference between Stored Procedure , Function
and Package,
1. how many blocks in Package and what are they. | IBM | 5 |
| How to create logins using windows Authentication mode? | | 2 |
| How can you see what type of locks used? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |