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

what is meant by smoke Testing??

7 Answers  

---

What are the advantages of SCSI compared to ATA or IDE ?

1 Answers  

---

What are the various steps you will follow for the defect prevention? What is the procedure?

1 Answers  

---

What is the formal technical review?

2 Answers   TCS,

---

Does functional testing comes under Black box or white box testing?

4 Answers   Infeneon Technologies, S1 Services,

---

When should exploratory testing be performed?

1 Answers  

---

Where do you see yourself five years from now?

5 Answers   Hexaware, RBI,

---

Hi I have done M.Tech Biotechnology from Anna University,but i did not get Job in my field.so I tried to learn Software testing . If i do ISQTB certifications , i will get job in MNC or not .Please let me know please mail to skirubanandan@lycos.com

2 Answers  

---

i have around 2 years experience in testing,please tell me,what kind of questions i will get?

2 Answers  

---

what is the strength of ur company?

8 Answers   MBT, TN,

---

what is opaque testing?,what is transparent testing

3 Answers   HP,

---

What is quality circle?

1 Answers  

---