| 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 |
| Wht is Stuff in sql ser | | 1 |
| What is blocking and how would you troubleshoot it? | HCL | 1 |
| What are the advantages of using sql server over ms access
or why should one use sql instead of ms access | Impetus | 1 |
| which query u can write to sql server doesn't work
inbetween 7.00PM to nextday 9.00AM | Wipro | 4 |
| Different Types of Functions ?
| Satyam | 2 |
| What is Trigger? | Misys | 2 |
| Where do you think the users names and passwords will be
stored in sql server? | | 2 |
| What are statistics, under what circumstances they go out
of date, how do you update them? | HCL | 2 |
| 1.Describe way(s) to tune the SQL table in order to
optimize performance.
2. Explain SQL Injection and how can you prevent them? | Techno-Solutions | 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 referential integrity? What are the advantages of it? | Digital-Domain | 2 |
| what is differece between union and union all | | 3 |
| What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance.... | Siemens | 6 |
| When do you use SQL Profiler? | | 2 |
| how to implement locking in sql server | Satyam | 1 |
| UPDATE statement can on a single table or on the multiple
table? | iGate | 3 |
| how can do you the system monitoring? | | 1 |
| select empid empname from employee
What is the result for the about query? | | 3 |
| Let us say master db itself has no backup. Now you have to
rebuild the db so what kind of action do you take? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |