| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the system function to get the current user's user
id? | HCL | 1 |
| How to work on DTS?what is the main requirement? | ivan | 1 |
| What is the use of placing primary key and foreign key
constrains on columns. | Value-Labs | 2 |
| Define candidate key, alternate key, composite key. | | 5 |
| What is a transaction and what are ACID properties? | | 2 |
| If there is failure during updation of certain rows, what
will be the state? | | 1 |
| what is normalization?
what is denormalization?
| Satyam | 4 |
| What are functions | | 3 |
| How To delete duplicate record from a particular table? | eXensys | 8 |
| SYNTAX FOR VIEWS WITH EXAMPLE
HOW TO LINK TWO TABLES | Microsoft | 1 |
| What is a function? Give some example? | | 1 |
| What is a Stored Procedure? | | 5 |
| Can you give an example of Stored Procedure? | | 2 |
| What is SQL server agent? | SAP-Labs | 2 |
| How to count the number of duplicate items in a table? | | 1 |
| how to implement locking in sql server | Satyam | 1 |
| What are the main control-of-flow T-SQL constructs?
| | 1 |
| What is the difference between two queries:
1. SELECT * FROM table WHERE 1=1;
2. SELECT * FROM table | HP | 12 |
| What is the difference between OLEDB and ODBC | CFCI | 2 |
| Difference between writing SQL query and stored procedure ? | Cognizent | 8 |
| |
| For more SQL Server Interview Questions Click Here |
Site Map