| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| how to rest identity columns in sql server | Matrix | 3 |
| what is the signification difference of this bit data type
between sql 6.5 and later version sql server? | | 1 |
| How do I compare two values when one value(data type) is
char and the other is an integer? | | 3 |
| Anyone please explain me the concept of Serialization? | | 3 |
| Is it possible to allow NULL values in foreign key?
I s it possible to use different constraints for the same
column in the table
(i.e) (id int NOT NULL,UNIQUEUE) | | 1 |
| create index a on employee(dno)
In this,which index was created? | | 2 |
| What is the system function to get the current user's user
id? | TCS | 3 |
| what is a cursor and what is its use? | | 1 |
| event classes in sql server | Accenture | 1 |
| How to list all tables having unique constraints in any of
the columns in a database. | | 1 |
| How to write a script for upate the data in prod , i have
50000 row are there | TCS | 2 |
| how to find out the repeated value from table using groupby
function? | | 3 |
| how to know description of a table in sqlserver 2000
| | 7 |
| Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed) | | 5 |
| Hi..here i would like to know the Backup and Restore models? | HCL | 2 |
| Explain DBMS, RDBMS? | | 4 |
| PC(code, model, speed, ram, hd, cd, price)
Find the hard drive sizes that are equal among two or more
PCs.
| APX | 2 |
| how to rename the table | | 3 |
| What is lock escalation? | | 1 |
| How can you see what type of locks used? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
