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)

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