Answer / Arun Kumar Verma

False. A primary key cannot be shared between multiple tables, but they can have common columns that are part of unique or foreign keys.

Explain system views?

1 Answers  

---

What is change data capture (cdc) feature?

1 Answers  

---

What is the use of nvl work?

1 Answers  

---

What is sql injection and why is it a problem? : sql server security

1 Answers  

---

How to enable/disable indexes?

1 Answers  

---

could you please reply for these question: 1.About Use Apply? 2.Avoid cursors - When we have a situation that we can not avoid the use of cursor than what is the alternate solution? is there anything we can use instead of cursor to perform the desired task? which optiomize the peroformance too. 3.What is computed columns? Thanks in advance. Regards, Rupesh

3 Answers  

---

What is partition, how will you implement it? : sql server analysis services, ssas

1 Answers  

---

Write a SQL command to insert and update only a particular field?

1 Answers   ADITI,

---

Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?

2 Answers  

---

what are the Prerequisites for Replication?

2 Answers   IBM,

---

What do you mean by an execution plan? How would you view it?

1 Answers  

---

Which are new data types introduced in sql server 2008?

1 Answers  

---