Explain foreign key in sql server?

0 Answers  

---

what is Buffer cash and Log Cache? Can you Explain it?

1 Answers   Wipro,

---

Explain multiserver query

0 Answers  

---

2) Consider a Table name A which has below records ID --- 5 5 5 5 5 Consider another table B which has below records ID -- 5 5 5 5 5 5 5 5 How many rows will be returned by each of the below queries a) select * from A inner join B on A.id = b.ID b) select * from A left join B on A.id = b.ID c) select * from A right join B on A.id = b.ID

2 Answers   Synechron, TCS,

---

What is the meaning of resultset type_scroll_insensitive?

0 Answers  

---

Explain what are the authentication modes in sql server?

0 Answers  

---

What is normalization? Describe its different types.

0 Answers   Wipro,

---

Why truncate is ddl?

0 Answers  

---

Can we insert data into a view?

0 Answers  

---

What is a transactions?

0 Answers  

---

Your sql server is running out of disk space. You notice that there are several large files with ldf extensions what are these files?

0 Answers  

---

Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?

0 Answers  

---