| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a Stored Procedure? | | 7 |
| Wht is SQL Injection Attack ? | | 1 |
| What is the role that is required for killing a process
What is the role that is required for creating a linked
server
| IBM | 1 |
| what is meant by deafult in sql server?
| | 2 |
| if we have a column (Key) in a table.
and values of that column is
Key
1
1
1
2
2
3
3
4
4
5
5
5
and we want to show the data after query..like..
1(3)
2(3)
3(2)
4(2)
5(3)
how many times a single term comes..
| Rolta | 5 |
| What do you mean by COLLATION? | | 4 |
| Is it possible to delete duplicate rows in a table without
using a temporary table ? | | 6 |
| How can your resolve deadlocks? | IBM | 3 |
| What is an execution plan? When would you use it? How would
you view the execution plan? | | 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 |
| 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 |
| What are sub-queries? Give example? In which case
sub-queries are not feasible? | Infosys | 3 |
| What is the appropriate number of test cases that you can
write on a database? | Microsoft | 1 |
| What is the basic functions for master, msdb, tempdb databases? | CSC | 2 |
| explain different types of jions with examples briefly? | Zensar | 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 |
| Difference between Cluster and Non-cluster index? | Oracle | 9 |
| What are SQL Jobs, please mention the use of it and how to
create them. | 247Customer | 1 |
| PC(code, model, speed, ram, hd, cd, price)
Find the hard drive sizes that are equal among two or more
PCs.
| APX | 2 |
| What command do we use to rename a db? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |