| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Explain the architecture of SQL Server? | | 2 |
| What is the difference between OLEDB and ODBC | CFCI | 2 |
| how to delete duplicate rows from table | CSC | 2 |
| How can you see what type of locks used? | | 1 |
| What is a join and their types? | Challenger-Financial | 2 |
| Hi..here i would like to know the Backup and Restore models? | HCL | 2 |
| What is the purpose of UPDATE STATISTICS? | | 1 |
| wat is the main diff between sql server 2000and sql server 2005 | Jade-Software | 4 |
| How can i change the column name. | HCL | 6 |
| Can you explain the role of each service? | | 1 |
| When do you use SQL Profiler? | | 2 |
| Questions regarding Raiseerror? | | 1 |
| could u plz explain about joins and views? | | 2 |
| What is the use of DBCC commands? | | 1 |
| What is a function? Give some example? | | 1 |
| how do we find every fifth record in a table | | 6 |
| I need a query that retrieves info from an Oracle table and
a query that retrieves info from a SQL Server table. The
info has to be joined together according to Record ID
numbers. I have very limited access to the Oracle database
but full control of the SQL Server database.How do I join
two different queries from two different databases?
| | 1 |
| What is the use of CASCADE CONSTRAINTS? | | 2 |
| what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1; | Patni | 6 |
| What are the magic tables in SQL Server 2000? | Infogain | 5 |
| |
| For more SQL Server Interview Questions Click Here |