| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| How to restart SQL Server in single user mode? How to start
SQL Server in minimal configuration mode? | HCL | 2 |
| What are primary keys and foreign keys? | | 3 |
| What is a cursor in SQL Server 2000 and their types? | | 2 |
| Assume,there are three tables in a database, Can i have
both primary key and foreign key for each table in the same
database? | | 4 |
| What is a job? | | 3 |
| Questions regarding Raiseerror? | | 1 |
| What is a sub-query? When would you use one? | | 2 |
| 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
| | 2 |
| how many type of subquery? | | 1 |
| How can I create a plain-text flat file from SQL Server as
input to another application? | | 2 |
| Explain Active/Active and Active/Passive cluster
configurations | | 1 |
| How do we get current date in SQL Server 2000, Oracle, MS
Access? | | 10 |
| What is user stored procedure & it purpose? | Wipro | 3 |
| What is the difference between constraints and triggers? | Wipro | 5 |
| What is blocking and how would you troubleshoot it? | | 1 |
| How to display n-1 columns from n number of columns, from a
single table in MS SQL server 2005? | | 1 |
| How to Run a Query on a Remote SQL Server? | | 1 |
| we have emp table like Ename,EDOJ,EDOB with Column
structure.but we want to know the employee Age.How? Any
Body Plz | | 6 |
| any one can explain
Self mapping
Delegation
Remote Credentials | | 1 |
| What are user defined datatypes and when you should go for
them? | | 1 |
| |
| For more SQL Server Interview Questions Click Here |
Ask Questions on ANYTHING, that arise in your Daily Life at 
Site Map
