Selenium Interview questions

Total available count: 22
Subject - Software Testing
Subsubject - Selenium

How to get top two salaries from employee tables?

Type 1: Select * from EMP e where 2>= (select count (*) from EMP e where sal>e.sal) order by desc sal.

Type 2: SELECT Salary FROM (SELECT Salary FROM Employee ORDER BY salary DESC LIMIT 2) AS Emp ORDER BY salary LIMIT 1;

In this solution, we have first sorted all salaries form the Employee table in decreasing order, so that 2 highest salaries come at top of the result set. After that, we took just two records by using LIMIT 2.

Next 5 interview question(s)

If a project is long term project, requirements are also changes then test plan will change or not? Why?
Which test cases are not to be automated?
What is your involvement in test plan?
What are test deliverables?
What is back end testing using SQL?