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 are software related risks? give me an example.

3 Answers  

---

What is a test closure?

0 Answers  

---

when we need testing

3 Answers  

---

Does anyone have a solution for this?

0 Answers  

---

What is upwardly compatible software?

0 Answers  

---

---

What is a user manual?

0 Answers  

---

how can i express my feeling as a test engineer having 3 years of exp, how do u enjoyed the testing? urgent

2 Answers  

---

Testplan & Tesdata a.)Testers workbench b.)Testing Strategy c.)Testing Policy d.)Testing Measurements

1 Answers   Amdocs,

---

After working in development for six months, what made you to shift into testing? I faced this question several times.

3 Answers   IBM, Indus Logic,

---

Testing wherein we subject the target of the test, to varying workloads to measure and evaluate the performance behaviors and the ability of the target and the test to continue to function properly under these different workloads?

0 Answers  

---

What are the technical reviews?

1 Answers   TCS,

---

CASE tools provides which one of the following benefits? 1. Minimizing of data redundancy 2. Automatic update to company-wide database when project database is updated 3. Lower price of CASE tool 4. Better integration with other CASE tools 5. Better performance across LAN/WAN

1 Answers   TCS,

---