| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| i want only duplicates rows from coloumn
ex. emp_id(colomn name)1,1,2,3,3,4,5,5.
so i want only duplicates no.
| iFlex | 2 |
| When do you create cluster and noncluster index? | Satyam | 4 |
| Name three version of sql server 2000 and also their
differences? | | 1 |
| What is an extended stored procedure? Can you instantiate a
COM object by using T-SQL? | | 1 |
| How to write query to Delete the records in child table
and corresponding records in parent table | Semantic-Space | 7 |
| how to get the automatic backup of the database in the sql
server | | 3 |
| write the query for taking database backup in sql | Logica-CMG | 3 |
| Can I remove the default constraint columns in SQL SERVER? | Value-Labs | 2 |
| What is the difference between Userdefined function and
stored procedure? Explain and give the example also | | 2 |
| What is a transaction and what are ACID properties? | IBM | 2 |
| What is the difference between constraints and triggers? | Wipro | 5 |
| What all db objects can be found in MSDB database of a SQL
Server instance? | Accenture | 1 |
| How to Check Whether a Global Temporary Exists in a SQL
Database or not? | | 2 |
| How to find the date and time of last updated table? | | 3 |
| plz tell me the new features of
sqlserver2000,sqlserver2002,sqlserver2005 | | 1 |
| what is Constraint? How many types of constraints in SQL ? | NIIT | 4 |
| What is the use of DBCC commands? | | 1 |
| Is trigger fired implicitely? | | 2 |
| What are sub-queries? Give example? In which case
sub-queries are not feasible? | Infosys | 1 |
| Explain the architecture of SQL Server? | | 2 |
| |
| For more SQL Server Interview Questions Click Here |