| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance.... | Siemens | 6 |
| What's the difference between a primary key and a unique key? | Wipro | 8 |
| explain different types of jions with examples briefly? | Zensar | 2 |
| how can i store resumes in database? | HCL | 2 |
| What are the advantages of using sql server over ms access
or why should one use sql instead of ms access | Impetus | 1 |
| what is the signification difference of this bit data type
between sql 6.5 and later version sql server? | | 1 |
| How can I create a plain-text flat file from SQL Server as
input to another application? | | 2 |
| i want only duplicates rows from coloumn
ex. emp_id(colomn name)1,1,2,3,3,4,5,5.
so i want only duplicates no.
| iFlex | 2 |
| What is the Query of getting last 10 transaction Reports
(like insert, update, Delete Data from Tabele) ? | Wipro | 4 |
| What is lock escalation? | | 1 |
| What is a deadlock and what is a live lock? How will you go
about resolving deadlocks? | Microsoft | 1 |
| please can anyone answer this query
Table 1 has 2 columns: EmployeeId,Age
Table 2 has 2 columns: EmployeeId, Region
Write SQL to Find the region who has the oldest person | | 7 |
| Difference between Triggers and Stored Procedure | Protech | 9 |
| What are the types of model in sql server and explain | TCS | 1 |
| How the data stores in a page? | | 1 |
| Anyone please explain me the concept of Serialization? | | 3 |
| what is index seek and index scan? | | 2 |
| please tell me the query to get details of the employee
having the second largest salary | 247Customer | 8 |
| what is physical sort data and logical sort data in index? | | 2 |
| How to list all tables having unique constraints in any of
the columns in a database. | | 1 |
| |
| For more SQL Server Interview Questions Click Here |