| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is a transaction and what are ACID properties? | | 2 |
| what is the query and condition to delete datas in sql
server. | | 2 |
| Difference between Function and Stored Procedure? | C1-India | 4 |
| WHICH INDEX IS FAST CLUSTER AND NON CLUSTER INDEX | L&T | 2 |
| what is the Enterprise manager(2000) and management studio
(2005)? | | 2 |
| How to write a script for upate the data in prod , i have
50000 row are there | TCS | 2 |
| Can you explain the types of Joins that we can have with Sql
Server? | | 2 |
| How do you fine the performance tunning? | Accenture | 2 |
| What is the default value of CHAR type? | Bosch | 8 |
| How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
| Oracle | 18 |
| how to get the maximum among two tables,for example table 1
(dep1) have (emp_id,emp_name,salary) columns and table 2
(dept2) have (emp_id,emp_name,salary) columns,i want which
employee have the maximum salary among two tables? | Lason | 2 |
| What are sub-queries? Give example? In which case
sub-queries are not feasible? | Infosys | 3 |
| Display a roll having miminum marks in two subjects? | Patni | 7 |
| what command is used to create a table by copying the
structure of another table? | | 5 |
| in emptable i want to retrive the name of employee whose
name in 'J'char.exp: arjun,jagadesh,niranjan,anju,aaaj etc. | | 7 |
| What is deadlock and how to avoid the deadlocks. | Wipro | 3 |
| How can u convert the Date to String? | TCS | 4 |
| how to generate XML out of QUERY? | McAfee | 1 |
| How do we return a record set from a Stored Procedure in SQl
server 2000? | | 2 |
| can you any body tell me which service pack is installed in
the sql server? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |
To Refer this Site to Your Friends 
Site Map
