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,

---

How can your resolve deadlocks?

4 Answers   IBM, IMS, Iron Mountain, NuWare,

---

How to create indexed view?

0 Answers  

---

What is perspective, have you ever created perspective? : sql server analysis services, ssas

0 Answers  

---

What is update locks?

0 Answers  

---

---

Mention the differences between having and where clause.

0 Answers  

---

What is a join in sql?

0 Answers  

---

Do you know what is bit data type and whats the information that can be stored inside a bit column?

0 Answers  

---

How to change the data type of an existing column with "alter table" statements in ms sql server?

0 Answers  

---

Do you know sql server 2008 introduces automatic auditing?

0 Answers  

---

How would you add a section to a table?

0 Answers  

---

What are different types of database indexes?

0 Answers  

---