| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| what is maximum size of temp db? | iSoft | 4 |
| How to find the date and time of last updated table?
| Teledata | 4 |
| what is the main difference between after trigger and
instead trigger. | | 1 |
| what is the order of execution of where,having,group by in
select stement | Tanla-Solutions | 5 |
| explain different types of jions with examples briefly? | Zensar | 3 |
| Explain Trigger with an example?
| | 1 |
| I have a table EMP in which the values will be like this
EmpId Ename Sal DeptId
11 Ram 10000 10
11 Ram 10000 10
22 Raj 20000 20
22 Raj 20000 20
33 Anil 15000 30
33 Anil 15000 30
I want to delete only duplicate Rows. After Delete I want
the output like this
EmpId Ename Sal DeptId
11 Ram 10000 10
22 Raj 20000 20
33 Anil 15000 30
| DELL | 10 |
| Rate yourself in .NET and SQL ? | Cognizent | 1 |
| can you any body tell me the how to decrease the logfile | | 4 |
| 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 |
| What r sql reporting services and analysis services? how
can we use it. | Microsoft | 2 |
| what is IDE,DMV in sql server? | Value-Labs | 1 |
| What is the difference between distinct clause and group by
clause? | Value-Labs | 1 |
| you are provided with the single table having say 4 col ie
fname lname age city , now the all records with displying of
only fname and lname is required but in this format say my
name is abhay khanna it will come like this
abhay-khanna
rahul-roy
gaurav-singh
the above format is required | | 2 |
| Which virtual table does a trigger use? | | 3 |
| What is difference beteen Migration and Upgrdation? | Satyam | 4 |
| How will u find the query which is running in some other
machine | IBM | 2 |
| How to Run a Query on a Remote SQL Server? | | 2 |
| how can i view structure of table in sql server? tell me
that query. | | 4 |
| If there is failure during updation of certain rows, what
will be the state? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map
