| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How do you use DBCC statements to monitor various aspects of
a SQL server installation? | | 1 |
| How do you implement one-to-one, one-to-many and many-to-
many relationships while designing tables? | TCS | 3 |
| What does it mean to have quoted_identifier on? What are the
implications of having it off? | | 2 |
| what is IDE,DMV in sql server? | Value-Labs | 1 |
| can you any body tell me which service pack is installed in
the sql server? | | 3 |
| Please give me queries for the following
1. To get the count of duplicate records.
2. A query to delete the duplicate records. | 247Customer | 3 |
| How to Generate a Series of Random Integers With T-SQL? | | 1 |
| How do you know which index a table is using? | | 4 |
| can any one please send sql quries most used in applications. | | 1 |
| Which stored procedure will you be running to add a linked
server? | | 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?
| HCL | 1 |
| What is the basic difference between clustered and a
non-clustered index? | | 3 |
| what is meant by sql injection with example and one more
question how to catch the errors in sqlserver | | 1 |
| When you first load SQL SERVER you will startup with what
all databases? | CompuSol | 3 |
| Can I know,how to Execute Funcion and Trigger through
command(Manualy Execution) in MS SQL/SERVER 2005,give me
answer with Example. | | 1 |
| Wht is Stuff in sql ser | | 1 |
| What is the difference between distinct clause and group by
clause? | Value-Labs | 1 |
| How do SQL server 2000 and XML linked? | | 2 |
| How would you Update the rows which are divisible by 10,
given a set of numbers in column? | | 1 |
| How to display n-1 columns from n number of columns, from a
single table in MS SQL server 2005? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |