| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Define candidate key, alternate key, composite key. | | 3 |
| What is the basic difference between clustered and a
non-clustered index? | | 2 |
| What is the difference between Userdefined function and
stored procedure? Explain and give the example also | | 2 |
| how to give input dynamically to a insert statement in
sqlserver | HCL | 1 |
| 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 |
| What is deadlock and how to avoid the deadlocks. | Wipro | 2 |
| What are defaults? Is there a column to which a default
can't be bound? | | 2 |
| Say if we have a table that contains only a single column ,
say OrderID, which has IDENTITY attribute defined on it. So
how can we insert data in this table.
I am reframing my question, that how can we make the table
to increment the column "OrderID" value several times??? | | 3 |
| What is de-normalization and when do you do it? | | 1 |
| IN Vs OR operator which is best to use sql server. | | 3 |
| Hi..here i would like to know the Backup and Restore models? | HCL | 1 |
| any one can explain
Self mapping
Delegation
Remote Credentials | | 1 |
| How to Execute an Operating System Command From Within SQL
Server ? | | 2 |
| What are the pros and cons of creating extended stored
procedures? | | 1 |
| What is the basic functions for master, msdb, tempdb databases? | CSC | 2 |
| please can anyone answer this query
Table 1 has 2 columns: EmployeeId,Age
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region who has the oldest person | | 3 |
| How to Get the last identity value used | | 3 |
| What is a transaction and what are ACID properties? | | 2 |
| Would it be a good idea to create an index on a table that
always contains 10 records? Why or why not? | | 2 |
| how to implement locking in sql server | Satyam | 1 |
| |
| For more SQL Server Interview Questions Click Here |