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
.

What is index, cluster index and nonclustered index?

997

---

What is normalization and what are the advantages of it?

992

---

What is sql server agent and what are the two modes of authentication in sql server?

1064

---

Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?

975

---

How to create indexed view?

1052

---

What command must you use to include the not null constraint after a table has already been created?

1157

---

How to deploy the Report?

140

---

What is exporting utility?

1031

---

What are database states in ms sql server?

1187

---

Explain full-text indexing?

996

---

How to modify existing triggers using "alter trigger"?

1023

---

How to add the custom code in Report?

129

---

What is user-defined inline table-valued function?

966

---

Define constraints and give an example of their use?

1046

---

I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that

2037

---