| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How do you measure the performance of a stored procedure? | Infosys | 1 |
| How do I list the available tables in a database I'm
querying? | | 3 |
| What is Query Execution Plan? How does it help optimize or
tune a database driven application? | Accenture | 1 |
| How m-m relationships are implemented? | | 1 |
| What is the difference between OLEDB and ODBC | CFCI | 2 |
| we have emp table like Ename,EDOJ,EDOB with Column
structure.but we want to know the employee Age.How? Any
Body Plz | | 6 |
| What are sub-queries? Give example? In which case
sub-queries are not feasible? | Infosys | 1 |
| what are batch in sql server?
| Satyam | 2 |
| What is a cursor in SQL Server 2000 and their types? | | 2 |
| what is the importence of the trigger in sqlserver2000? | ATI | 1 |
| what are file groups? | Evalueserve | 3 |
| what is extended StoreProcedure ?
| Satyam | 3 |
| Difference between Triggers and Stored Procedure | Protech | 7 |
| could you please reply for these question:
1.About Use Apply?
2.Avoid cursors - When we have a situation that we can not
avoid the use of cursor than what is the alternate solution?
is there anything we can use instead of cursor to perform
the desired task? which optiomize the peroformance too.
3.What is computed columns?
Thanks in advance.
Regards,
Rupesh
| | 3 |
| What is the difference between 2-Tier architecture and
3-Tier architecture | Oracle | 5 |
| What are cursors? | | 7 |
| write the query for taking database restore in sql? | | 1 |
| Can I remove the default constraint columns in SQL SERVER? | Value-Labs | 2 |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | HCL | 2 |
| How to tune a stored procedure? | | 4 |
| |
| For more SQL Server Interview Questions Click Here |