Interview Questions Answers in Oracle General, SQL PLSQL

muhammed zaheer

{ City } bahrain
< Country > india
* Profession * programmer
User No # 13277

Total Questions Posted # 0
Total Answers Posted # 3

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

Users Marked my Answers as Correct # 92
Users Marked my Answers as Wrong # 19

Questions / { muhammed zaheer }

Questions Answers Category Views Company eMail

Answers / { muhammed zaheer }

Question { 14377 }

pls explain connect by prior with example and its real time
use

Answer

Connect by prior can be used to create heirarchical tree
structure

Is This Answer Correct ?

6 Yes

3 No

Question { Cognizant, 361471 }

how to find the second highest salary from emp table?

Answer

select max(sal) from emp where sal < (select max(sal) from
emp)

Is This Answer Correct ?

86 Yes

16 No

Question { 4961 }

Is it possible to enter only time value into a column of a
table in sql?

Answer

No,
you can store as (HH24:MI) at form level, also make format
DateTime.
Query by - to_date(HH24:MI)
Also you can use Timestamp - I tied it in Oracle 10g. It
will store date and time

Is This Answer Correct ?

0 Yes

0 No