Differentiate between a primary key and a unique key.


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL Server Interview Questions

how to select 5 to 7 rows from a table, which contains 10 rows?

21 Answers   IBM,


Explain what are the basic functions for master, msdb, model, tempdb databases?

0 Answers  


what are user defined datatypes? : Sql server database administration

0 Answers  


Can truncate be rolled back?

0 Answers  


What is the difference between UNION and UNIONALL?

5 Answers   CarrizalSoft Technologies, CTS,






A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,


What the different types of Replication and why are they used?

0 Answers  


Which are the olap features?

0 Answers  


What is the usage of the sign function?

0 Answers  


What are date and time data types in ms sql server?

0 Answers  


What is difference between index seek vs. Index scan?

0 Answers  


How do you check the performance of a query and how do you optimize it?

1 Answers  


Categories