Answer / swapna

Different types of joins are normal joins and set joins.

Normal joins are outer joins and inner joins.

Inner joins are cross join,equi join,non-equi joins,self
joins.

Outer joins are left outer join,right outer join,full outer
joins.

Set joins are union,union all,intersect,minus.

Answer / sachin patil

Diff types of join

1. Inner
2.Left Outer
3.Right Outer
4.Cartesian
5.Self Join

Describe triggers features and limitations?

0 Answers  

---

How to change the system date and time from SQL Plus Terminal ?

0 Answers   MCN Solutions,

---

Difference between Function and Procedure-in general?

6 Answers  

---

How to create a view using data from another view?

0 Answers  

---

Tell me about joins in database system and explain each in detail.

0 Answers   Axtria, ITC Indian Tobacco Company,

---

What is ms sql server service broker?

0 Answers  

---

You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?

0 Answers  

---

Is there any difference between the primary key and unique key?

0 Answers  

---

How is sql server used?

0 Answers  

---

Can we check locks in database? If so, how can we do this lock check?

0 Answers  

---

Tell me when is the update_statistics command used?

0 Answers  

---

1.can we set the more than 1 primary keys for a table? 2.please give me the difference between Cluster Index and non-Clustered Index 3.can we use query like this "Select * from Table1,Table2;"

8 Answers  

---