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 constraints? Explain different types of constraints? : Sql server database administration

0 Answers  

---

Do you know how to send email from database?

0 Answers  

---

what is the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  

---

What is transact-sql ddl trigger?

0 Answers  

---

What are the difficulties faced in cube development? : sql server analysis services, ssas

0 Answers  

---

What is the difference between Temporary table variable and a Table variable? Or Which Table variable I should use inside Stored procedure?

3 Answers   Microsoft, TCS, Techastrum,

---

What is optimization and its types?

0 Answers  

---

how do you test proper tcp/ip configuration windows machine? : Sql server database administration

0 Answers  

---

What can be used instead of trigger?

0 Answers   ADITI,

---

what is the use of database index(apart from the last searching of records) and what is the use of composite key?

1 Answers  

---

Write a program to fetch first 10 records from a file?

0 Answers   Amdocs,

---