| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| where do you use Isolations?give me some exmpale? | | 1 |
| Explain Different types of Projects? | | 1 |
| What is transcation?Plz give One example? | | 2 |
| how to change column into row in sql | ESS | 2 |
| when inserting to a table how many rows will be effected
using triggers
| | 1 |
| Is trigger fired implicitely? | | 2 |
| what is the maximum size of a row in sql server 2000 and 2005 | | 2 |
| What is the disadvantage of using subquery exact after a
select statement?ex.
select (select * from sometable) | | 1 |
| UPDATE statement can on a single table or on the multiple
table? | iGate | 6 |
| How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
| Oracle | 18 |
| What is the difference Between Sql-server 2000 & 2005 | Value-Labs | 2 |
| can foreign key take role of primary key?
| TCS | 4 |
| 1.what is the difference between view and cursor?
2.If we do any change in view will it affect the
database,similarly when we do changes in cursor will it
affect the databse?with certain example?Thanks
| | 3 |
| Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement | | 2 |
| What is de-normalization and when do you do it? | | 3 |
| How to retrieve duplicate rows in a table?
How to delete the duplicate entries in a table? | Leo-Technologies | 12 |
| We create an index to fast the search. How it fast the
query? Do we write any special keyword with query? | | 3 |
| Explain the new features of SQL server 2000? | | 1 |
| What are statistics, under what circumstances they go out
of date, how do you update them? | HCL | 2 |
| What is referential integrity? What are the advantages of it? | Digital-Domain | 3 |
| |
| For more SQL Server Interview Questions Click Here |
along with your userid / name. ThanQ
Site Map
