Answer Posted / shikha

PersonID
PersonID + LastName
PersonID + FirstName
PersonID + DOB
PersonID + LastName + FirstName
PersonID + LastName + DOB
PersonID + FirstName + DOB
PersonID + LastName + FirstName + DOB
LastName + FirstName + DOB
All of these will uniquely identify each record, so each
one is a superkey. Of those keys, a key which is comprised
of more than one column is a composite key; a key of only
one column is a simple key.

A candidate key is a superkey that has no unique subset; it
contains no columns that are not necessary to make it
unique. This table has 2 candidate keys:

PersonID
LastName + FirstName + DOB
Not all candidate keys make good primary keys: Note that
these may work for our current data set, but would likely
be
.

Do you know clustered and non-clustered index?

929

---

Can you explain what is the use of custom fields in report?

999

---

What is a mutating table error and how can you get around it?

962

---

Is it safe to delete log files?

867

---

What is a select query statement in ms sql server?

1006

---

Explain what are the restrictions while creating batches in sql server?

1020

---

How to change the ownership of a schema in ms sql server?

1087

---

Hi all, can any one please tell me the difference between sql server 2008 and orace 9i

1901

---

What is coalesce and check constraint in sql server?

1041

---

How do I connect to sql server database?

947

---

Explain tables in SQL Azure?

120

---

What is intellisense?

988

---

What is the security principal at the server level that represents your session?

961

---

How to change the name of a database user?

907

---

why would you call update statistics? : Sql server database administration

1010

---