Interview Questions Answers in Oracle General, SQL PLSQL

yadagirireddy

{ City } bloomington
< Country > india
* Profession *
User No # 3062

Total Questions Posted # 0
Total Answers Posted # 2

Total Answers Posted for My Questions # 0
Total Views for My Questions # 0

Users Marked my Answers as Correct # 31
Users Marked my Answers as Wrong # 44

Questions / { yadagirireddy }

Questions Answers Category Views Company eMail

Answers / { yadagirireddy }

Question { Keane India Ltd, 67943 }

Difference between sub query and nested query ?

Answer

Hi Friends,

Query inside a query is called as Sub query. Sub query is
also called as Nested Query.

Thanks
REDDY

Is This Answer Correct ?

22 Yes

41 No

Question { Polaris, 23648 }

Types of joins ?

Answer

Hi Friends,

1)Inner or Natural Join.
2)Non equi Join.
3)Self Join.
and 4)Outer Join.

Thanks
Reddy

Is This Answer Correct ?

9 Yes

3 No