Give me real life some test cases



Give me real life some test cases..

Answer / theega

Write test cases on a scenario where you have to transfer
data from one table to another.
Condition:The data should be copied and not deleted from
the first table. The rows should be copied one at time.



Test Case No Test Case Description Steps to Execute
Expected Result

TC-1 First Check How many Records Existing in the First
Table. Select Count(*) from Table1. System should show
no of records existing in the first table
TC-2 Tranfer one record from first table to second Table
insert into table2 select * from table1 where
rownum=1 System should show transfer one record
from first table to second table.
TC-3 To check whether data can not be deleted from first
table or not select * from table1 where rownum=1
System should show first record .
TC-4 To check whether data can be copied to second
table or not select * from table2 where rownum=1
System should show first record .
TC-5 Tranfer one record from first table to second Table
insert into table2 select * from table1 where
rownum=2 System should show transfer one record
from first table to second table.
TC-6 To check whether data can not be deleted from first
table or not select * from table1 where rownum<=2
System should show first and second record .
TC-7 To check whether data can be copied to second
table or not select * from table2 where rownum<=2
System should show first and second record .
TC-8 Execute Test Case -2 Until Rownum=no of record in
the first table insert into table2 select * from table1
where rownum=(select Count(*) from table1) System
should show first and second record .
TC-9 To check whether data can not be deleted from first
table or not Select * from Table1 System should show
all the records.
TC-10 To check whether data can be copied to second
table or not select * from table2 System should show
all the records.

Is This Answer Correct ?    4 Yes 1 No

Post New Answer

More Test Cases Interview Questions

how to write test cases for smart meter for gas and electricty

0 Answers  


write a navigation for object repostory

4 Answers  


difference between scenario and testcases?

5 Answers   CarrizalSoft Technologies, Satyam,


when you don't have time to write test cases, what do you do?

7 Answers   Satyam,


pliz anyone give suggest me the test cases for shorting numbers in asc/desc order.

4 Answers   IBM,






can any one send sample test case documents in informatica with examples plz send documents to "mrlsurya@gmail.com"

2 Answers   IBM, TCS,


Explain the agile testing?

1 Answers  


(questions asked in interview)hi every one can any one please answer to this questions.these questions were asked in an interview.i have another interview next week . 1.when the time schedule is tight how will you approch the testing,and the relese is nearing and we need to finish testing how can we follow in that case.do we need to exicute all the test cases or can priortise and leave some to next relase. 2. when a new feature is added to the existing application we need to add new test cases but after that do we need to change all the existing test cases and while running do we need to exicute entire application test cases or only the new feature test cases and related new feature test cases. 3.do you have any situation where you have to write and exicute the test cases same time, how will you follow.does it happens in real time. 4.example of bug which is not reproducible.like tester say that there is bug and developer say no can some example of such bugs. 5.during regression testing some times do we need to add new some additional test cases to test that bug.

3 Answers  


Hi, i attended interview in seimens they asked me suppose u have a car which is used by VIP and it has 2 alarms one is at front and other is back when ever smoke or fire is near to car it will detect it and beep alaram so wat r the possible test cases u can write plz give the answer

2 Answers   Siemens,


Do you write test plan and test case?

0 Answers   FF Solutions,


This part of a program is given: WHILE (condition A) Do B END WHILE How many decisions should be tested in this code in order to achieve 100% decision coverage? A. 2 B. Indefinite C. 1 D. 4

1 Answers   ISTQB,


How you will write test cases on DROP DOWN list BOX on GUI

5 Answers   eMids, Valtech,


Categories