| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| wt is mean by acid property? i know it is
atomocity,consistency,isolation and durabulaty but wt is
these mean and wt actions it's perform | Idea | 1 |
| How do you fine the performance tunning? | Accenture | 2 |
| how many types of store procedre in sqlserver 2000? | ATI | 2 |
| Where do you think the users names and passwords will be
stored in sql server? | | 2 |
| how to delete duplicate rows from table in sql server | hcl | 1 |
| What is normalization in Database ? | | 3 |
| explain different types of jions with examples briefly? | Zensar | 2 |
| Can you give an example of Stored Procedure? | | 2 |
| What is the use of CASCADE CONSTRAINTS? | | 2 |
| Can you link only other SQL Servers or any database servers
such as Oracle? | | 1 |
| There is a trigger defined for INSERT operations on a
table, in an OLTP system. The trigger is written to
instantiate a COM object and pass the newly insterted rows
to it for some custom processing. What do you think of this
implementation? Can this be implemented better? | | 1 |
| How do you find the number of rows in a table? | | 5 |
| How do you know which index a table is using? | | 4 |
| Questions regarding Raiseerror? | | 1 |
| How will u get 5 years back record? | | 3 |
| what is the out put of below queries?
a. select * from Emp where null = null;
b. select * from Emp where 1=1; | Patni | 6 |
| how to give input dynamically to a insert statement in
sqlserver | HCL | 1 |
| what command is used to create a table by copying the
structure of another table? | | 4 |
| what is mean by crystal repoart? ahere we will mainly use
that? | | 1 |
| What is the difference between temp table and table variable? | Microsoft | 3 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
