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 do we have to check in database testing?

0 Answers  

---

What is single-user mode and what are the steps you should follow to start sql server in single-user mode?

0 Answers  

---

explain different types of jions with examples briefly?

1 Answers   Zensar,

---

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  

---

what are the different types of replication you can set up in sql server? : Sql server database administration

0 Answers  

---

what are different types of backups available in sql server? : Sql server database administration

0 Answers  

---

how to improve the speed of SQL database server and how to avoid dead lock?

1 Answers   TCS,

---

plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005

3 Answers  

---

What are partitioned views and distributed partitioned views?

0 Answers  

---

What is precedence constraint?

0 Answers  

---

Explain what is use of dbcc commands?

0 Answers  

---