| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Let us say master db itself has no backup. Now you have to
rebuild the db so what kind of action do you take? | | 1 |
| How do we get current date in SQL Server 2000, Oracle, MS
Access? | | 11 |
| What are sub-queries? Give example? In which case
sub-queries are not feasible? | Infosys | 3 |
| How will oyu test the stored procedure taking two parameters
namely first name and last name returning full name? | | 3 |
| Please get the 4 th maximum salary from a table without
using any sql keyword (TOP,MAX are mot allowed) | | 5 |
| What is a Linked Server? | | 1 |
| What types of integrity are enforced by a foreign-key
constraint
| | 1 |
| How to write a script for upate the data in prod , i have
50000 row are there | TCS | 2 |
| What is database replicaion? What are the different types
of replication you can set up in SQL Server? | HCL | 4 |
| how will u create "n" possible tables in sql...
| Oracle | 1 |
| How will u find the query which is running in some other
machine | IBM | 2 |
| Can we call SP inside a query? | Wipro | 4 |
| What is an execution plan? When would you use it? How would
you view the execution plan? | | 1 |
| what are the problems in logshipping? | | 2 |
| can anyone explain me the concept of Serialization in Detail
and Clear? plz its urgent i have interview on friday (15th feb) | | 1 |
| Difference between Function and Stored Procedure? | C1-India | 4 |
| which one will take 1st priority in case of insert statement
and select statement??? | | 1 |
| What is normalization in Database ? | | 4 |
| 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 the different types of replication? How are they used? | | 3 |
| |
| For more SQL Server Interview Questions Click Here |