Question { Vertex, 18230 }

write the SQL statement to retrieve the 2nd Highest salary
ammount(File Name="EMPLOY",Field Name="SALARY")

Answer

select top 1 from (select top 2 from emp order by sal desc)A
order by sal

Question { 3302 }

Hi all,

In Every interview interview asking one question

what type of challenges you have been faced in your project?

Answer

Challenges might be the risks and tough goals you have gone
through at your project.
a simepl example.

If there are about 100 test cases which needs to be
executed in 2days with 2 resources. then how do you plan to
do and how to tackle it.

and there are basically challenges will come at setting the
milestones for a project....

it may be in allocating resources...allocation of
time....etc...


You can say that my lead has assigned a project and it has
300 test cases to be executed but the time span is too
less...then you mentioned wht are the steps taken to see
taht the prject is delivered ONTIME....