| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| 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?
| HCL | 1 |
| WHAT OPERATOR PERFORMS PATTERN MATCHING? | CTS | 2 |
| What is a stored procedure? | | 3 |
| wht is normalization?can u explain me in detail? | TCS | 6 |
| How the data stores in a page? | | 1 |
| what are the joins,primary key,foriegn key, candidate key,
super key and expain them? | Polaris | 2 |
| what is the difference between sql query and google query? | TCS | 7 |
| Which virtual table does a trigger use? | | 3 |
| how to connect sybase to sql server 2005?. | ABC | 1 |
| plz tell me the new features of
sqlserver2000,sqlserver2002,sqlserver2005 | | 3 |
| plz send every query in sql server2000 | Infosys | 1 |
| In clustered and non clustered indexes which one is faster
while executing a query ? | | 1 |
| WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX | L&T | 2 |
| How to retrieve data from log files in SQL SERVER ????? | | 1 |
| How to Execute an Operating System Command From Within SQL
Server ? | | 2 |
| how to know description of a table in sqlserver 2000
| | 7 |
| what is difference between primary key and Unique | | 8 |
| What is the difference between a Application Server and a
Database | Oracle | 2 |
| What is the difference between a stored procedure and a user
defined function in sql server? | Millennium | 2 |
| How do you find the error, how can you know the number of
rows effected by last SQL statement? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |