Interview Questions Answers in SQL PLSQL

abhishek jaiswal

{ City } pune
< Country > india
* Profession * oracle erp trainee
User No # 103819

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 # 2
Users Marked my Answers as Wrong # 0

Questions / { abhishek jaiswal }

Questions Answers Category Views Company eMail

Answers / { abhishek jaiswal }

Question { TCS, 51623 }

What is the result, when NULL is compared with NULL?

Answer

Decode will return true if we compare null to null value.
select decode(commission_pct,null,0) from employees

Is This Answer Correct ?

1 Yes

0 No

Question { Cognizant, 366238 }

how to find the second highest salary from emp table?

Answer

select salary from employees a where &nth_highest_salary =(select count(distinct salary)
from employees b where a.salary<=b.salary)
/

Is This Answer Correct ?

1 Yes

0 No