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 are the restrictions that views have to follow?

0 Answers  

---

In which format does an image save in SQL Server database ?

0 Answers   MCN Solutions,

---

What is difference between clustered index and non clustered index?

0 Answers  

---

What is 'Join' and explain its various types.

0 Answers   Genpact,

---

---

What options are available to audit login activity? : sql server security

0 Answers  

---

How to create logins using windows Authentication mode?

2 Answers  

---

How to grant a permission in ms sql server using "grant execute" statements?

0 Answers  

---

How to list all login names on the ms sql server?

0 Answers  

---

What is lock escalation?

1 Answers  

---

What is blocking and how would you troubleshoot it?

3 Answers   HCL,

---

Indexes are updated automatically is the full-text index also updated automatically?

0 Answers  

---