Answer / swapna

Both primary key and unique enforce uniqueness of the
column on which they are defined. But by default primary
key creates a clustered index on the column, where are
unique creates a nonclustered index by default. Another
major difference is that, primary key doesn't allow NULLs,
but unique key allows one NULL only.

Answer / ramneet

There is one more diff b/w primary key and unique key that
there is only one primary key in a table but there are more
then one unique keys in a table.

Answer / gowthami radhakrishnana

1)primary key uses clustered index
unique key uses non-clustered index

2)primary key doesn't allow null values
but unique allows one null value

3)there is only one primary key but more than one unique
keys

Answer / ramneet

Primary can be used in foregin key but unique key does not
used.

mention different types of relationships in the dbms?

0 Answers  

---

Differentiate between a primary key and a unique key.

0 Answers  

---

tell me the disaster recovery plan

0 Answers   Microsoft,

---

why cluster and non clusterindex are used in sqlserver 2000? explain with example

1 Answers  

---

How to delete the duplicate rows from a table in SQL Server ??

3 Answers  

---

How can you check the version of sql server?

0 Answers  

---

What is 2nf normalization form?

0 Answers  

---

What’s the use of custom fields in report?

0 Answers  

---

write down the sql query? Table Name : emp1 empid empname 1 bala 2 guna Table Name : emp2 empid empname 1 <Null> 2 <Null> Solution : emp1 names are updated in emp2, write a query?

8 Answers  

---

hi, the following are the outputs of sp_spaceused and sp_tempdbspace sp_spaceused ------------ database size unallocated size tempdb 77752.95 MB 28026.99 MB sp_tempdbspace ------------- database size spaceused tempdb 77752.945312 1.007812 the unused space in sp_spaceused is nearly 28 Gb and in sp_tempdbspace is nearly 76 Gb cany any one explain about this output and why its giving different results.

0 Answers  

---

What is the difference between clustered and a non-clustered index?

0 Answers   NA,

---

What is a transaction and why is it important?

0 Answers  

---