Interview Questions Answers in Oracle General

saleem

{ City } kadapa
< Country > india
* Profession * student
User No # 9156

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 # 10
Users Marked my Answers as Wrong # 6

Questions / { saleem }

Questions Answers Category Views Company eMail

Answers / { saleem }

Question { HCL, 153723 }

find out the third highest salary?

Answer

select distinct(a.sal) from emp a where &3 = ( select count
(distinct(b.sal) from emp b where a.sal <= b.sal));

Is This Answer Correct ?

8 Yes

6 No

Question { 12418 }

What is autonomous transaction?

Answer

It is independent transaction>It will executes with out
interfering the parent transaction.

Is This Answer Correct ?

2 Yes

0 No