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.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
I know functional test cases are derived from frs and system design specs. But are test cases for performance, database, boundary, relational integrity and other types of tests other than functional tests created from frs and system design specs as well? When are these test cases created? Are they in the same test plans alongside functional test cases or is their a different test plan that includes these test cases?
What is the procedure of manual testing?
What is Bomb Testing?
Is an "A fast database retrieval rate" a testable requirement?
After insert the record in front-end, how will you check the back end by manually? Please explain?
If anybody from banglore having the real time exp in manual testing with 3+ yrs exp and looking for change send your profile to vinodhanandhan@gmail.com
Have you worked in UDAP (Credit Card act 2009) project?What did you test in Billing & Payment modules?
Wat type of questions ll be asked in interview for an 1-2 yrs. experinced persond and i need some database concept question in testing.
What kind of testing to be done in client server application and web application? Explain
Why Equivalence Partitioning is called equivalence or what is the significance of equivalence term in ECP?
How should validation activities be handled?
discuss black box and white box testing is not widely used if you disagree tell me why?
what r the 5 major defects that u found in ur shopping related project?
wat is meant by frontend and backend testing
what is diffrence between dynamic black box testing and dynamic white box testing
