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

List the comparison between FC and FCOE?

0 Answers  

---

What makes an inspection different from other review types?

0 Answers  

---

what are the certifications do we have in testing,i hold 2yrs 4months experience in testing..who are offering,how much do they cost..whom to contact .plz give me supporting URLs

2 Answers  

---

Send me the interview questions

1 Answers  

---

What is path coverage testing?

0 Answers  

---

---

what r the contents in usecase?

6 Answers   MBT,

---

Find odd man out related to EA a) Play fish b) Take2 c) Hasbro d) Pogo

8 Answers   EA Electronic Arts,

---

Explain what test plan is?

0 Answers  

---

Explain Peer Review in Software Testing?

0 Answers   MCN Solutions,

---

What is the difference between functional test type and navigation test type?

3 Answers   Value Labs,

---

In what basis you will write test cases?

8 Answers   Accenture,

---

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?

0 Answers  

---