Answer Posted / prasanna

1.Inner Join
- Equi Join
- Natural Join
2.Outer Join
- Left Outer Join Or Left Join
- Right Outer Join Or Right Join
- Full Outer Join Or Full Join
3.Cross Join
4.Self Join

What are the options which must be set to allow the usage of optimistic models?

931

---

What happens if null values are involved in comparison operations?

930

---

How many columns can we include on clustered index ?

955

---

what protocol both networks use? : Sql server database administration

946

---

Can you please explain the difference between function and stored procedure?

973

---

What do I need to start working with sql studio? : sql server management studio

1071

---

What will be the maximum number of indexes per table?

926

---

Explain the properties of sub-query in sql server?

973

---

what is sql server? : Sql server database administration

952

---

What is page in sql server?

921

---

How will you find out if there are expensive SQL statements running or not?

987

---

What is the difference between migration and upgradation in sql server?

1059

---

Is there any difference between primary key and unique with the not null condition?

918

---

What is the status of services on passive node for failover cluster in sql server? : sql server database administration

1199

---

What should be the fill factor for indexes created on tables? : sql server database administration

1110

---