Answer Posted / janaki

hi this is janaki
i will tell u with example

we have class table with columns as
create table class
( cn number,
cname varchar2(15),
csize number):
class table created.
now we create a procedure for this table

create procedure proce1(@cno,@cn,@cs)
as
begin
if @cs>20
begin
insert into class values(@cno,@cn,@cs)
end
else
print 'csize should be greater than 20'
end

--procedure created.
we can make use of the 'exec(execute) command to call a
procedure by passing the parameters.

Exec proc1 111,'abc',35
these values to be inserted in class table.

this is the way we have to test stored procedures.ok.
Janaki.

What is validation in software testing?

1143

---

what is the main field of bugzilla which we fill to report bug to any developers???give some brief description??

2020

---

How to integrate Bugzilla with QTP?

2777

---

What is stub?

1183

---

Presently working in software company as a software test engineer with 1.5 yrs of experience but i am 2002 passout.Gap is 6 yrs.Is there any problem getting job in MNC? Which criteria HR follows for recruiting test engineer?

1976

---

1.For a single module how many builds are possible 2.what will be the max or min time to finish up an single module

2009

---

1.How can you Pick Integration Test Cases? 2.When will you start Regression Testing? 3.What is the difference between QA & QC? 4.When Will you Exit In Testing? 5.Test Deliverable's 6.What is the difference between windows based appln and web based appln? 7.What are the types of regression testing?

5133

---

What is an end-to-end testing?

1080

---

Write the test cases for yahoo home page

2225

---

test cases for compose functionality of gmail

2022

---

How do you scope, organize, and execute a test project?

2198

---

What if an organization is growing so fast that fixed testing processes are impossible? What to do in such situations?

1393

---

Explain compatibility testing with an example.

1030

---

1...DIFF BETWEEN QTP AND WIN RUNNER? 2... CHECKPOINTS AND EXPLAIN EACH OF THEM? 3...WHY IS STEP GENERATOR? 4... WHAT IS THE DIFF BETWEEN FUNCTIONS AND SUB ROUTINE?

1856

---

How do you determine user soad for a perf test of a Web application?

2300

---