Answer / uday kumar_anem

1. select count(*)
from employee
where sal>=20000 and sal<=50000

2. select count(*)
from student
group by course

Answer / krishna

here they want number of employees not empno.
select count(empid),sal from emp where sal between 20000
and 50000;

Answer / vishal

oh sorry i missed it..

thx for correcting me :-)

Answer / vishal

assuming emp-id and sal tobe the fields in the
table "Employee" followng query can be used

Select emp-id, sal from Employee where sal between "20000"
and "50000"
OR
you have to run two different queries to extract records as
selecting records above 20,000 would cover the second part
too

2. select count (stud_id) from Student where
course_name="Testing"

hope they would help

Explain testing?

0 Answers  

---

Which of the following is not a Game Genre? a) RTS b) STR c) FTS d) RPG

6 Answers   EA Electronic Arts,

---

i am a PG science(chemistry),now am working test engineer in small organization,now i will decide to move better organization please send model cv and advises

0 Answers  

---

If your current project is US based project, where will your Business Analyst stay ? India or US ??

3 Answers   ADP,

---

What is linked Servers in SQL Server

1 Answers   CybAge,

---

A number of critical bugs are fixed in software. All the bugs are in one module, related to reports. The test manager decides to do regression testing only on the reports module.

0 Answers  

---

Explain automated testing?

0 Answers  

---

Suppose one functionality appears in an application which was not there in the requirements..so what u do as a tester?

7 Answers   Covansys,

---

Could anyone share FAQs for Test Manager position.

1 Answers  

---

26). how will know do written test cases are sufficient to validate application of functionality? 27). how will you prepare test data to validate input object? 28). explain defect status? 29). how will know whether the developer accepted you defects or not? 30). explain acceptance test? 31). explain when we stop testing? 32). explain scope of your project? 33). in which module you conducted testing? 34). explain defects which you found in that module? 35). if defect is not reproducible then what information you will provide to developer 36). if developer is not accepted your defect then what you will do?

2 Answers  

---

What is memory leaks and buffer overflows ?

0 Answers  

---

Explain what test plan is? What is the information that should be covered in test plan?

0 Answers  

---