| Other SQL Server Interview Questions |
| |
| Question | Asked @ | Answers |
| |
| What is the appropriate number of test cases that you can
write on a database? | Microsoft | 1 |
| How do you persist objects, permissions in tempdb | | 1 |
| 1.what is stored procedure?Its significance with example?
2.Explain about index with syntax and example?
plz do reply......... | | 1 |
| what is the diffrence between Snap Shot and Transaction
Replication | CSC | 1 |
| what is cluster and nin-cluster index? | | 4 |
| What is The Use Of TIMESTAMP DataType in SQL Server 2005?
| | 3 |
| Is it possible to delete duplicate rows in a table without
using a temporary table ? | | 6 |
| what is meant by deafult in sql server?
| | 2 |
| How to find the date and time of last updated table? | | 3 |
| What types of integrity are enforced by a foreign-key
constraint
| | 1 |
| What is the difference between DTS and SSIS? | Allianz | 3 |
| What is normalization and what are the different forms of
normalizations? | | 1 |
| one table has four field id,name,design,salary. i have to
find maximum salary . | | 6 |
| What is transaction ? Give me one example. | Melstar | 7 |
| How do I compare two values when one value(data type) is
char and the other is an integer? | | 3 |
| How many max. conditions can b written under the WHERE
clause?
Like select * from [tabnam] WHERE
(cond1...or..cond2....or...cond3...and.....so on.....???
(upto how much extent))????? | SAP-Labs | 2 |
| What do you mean by COLLATION? | | 4 |
| Explain sp_configure commands, set commands? | | 3 |
| how can we use a composite key for two tables and how can
we represent it | BoA | 1 |
| What is the use of MOVE keyword in restore command | IBM | 2 |
| |
| For more SQL Server Interview Questions Click Here |