| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| Define candidate key, alternate key, composite key. | | 9 |
| SYNTAX FOR VIEWS WITH EXAMPLE
HOW TO LINK TWO TABLES | Microsoft | 1 |
| Explain DBMS, RDBMS? | | 4 |
| what is Data Transformation Services (DTS) ?can u explain
me in detail? | TCS | 5 |
| wat will be the sql query to extract only last 3 records
from table supose table hving thousands for records | | 16 |
| how to dispaly a particular row details from a given table | | 1 |
| How to find the date and time of last updated table? | | 3 |
| What is de-normalization and when do you do it? | | 3 |
| employee table has employee id
-----------
empid
----------------
1
2
3
3
3
4
5
5
5
6
6
6
7
here the values r repeated two times.how to select the
repeated values only.i.e 3,5,6 should alone come. | | 2 |
| About DTS usage ? | Cognizent | 2 |
| What is the purpose of using COLLATE in a query? | | 1 |
| How to delete particular value in the column of a table.Is
it possible or not?if possible give it as in query. | | 4 |
| What are the all different types of Joins in SQL Server
2000, Anybody can explain each join with definition..Thanks
in advance.... | Siemens | 6 |
| How do you read transaction logs | | 1 |
| What is a transaction and what are ACID properties? | | 2 |
| how to implement locking in sql server | Satyam | 1 |
| what are the joins,primary key,foriegn key, candidate key,
super key and expain them? | Polaris | 2 |
| how to connect sybase to sql server 2005?. | ABC | 1 |
| Hi Can any one tell me the Good institute to learn SQL esp
for Data Base Testing or SQL from scratch to the
proficiency level in Hyederabad and facult also. Thankyou
well in advance | | 6 |
| How To Change Column Ordinal Position in SQL Server 2005
using Query i.e I Want To Add Column at Particular Ordinal
Position in SQL Server 2005 | | 2 |
| |
| For more SQL Server Interview Questions Click Here |