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 we test the login page using jwebunit test case...

0 Answers   CTS,


could u please tell the testcases to test gmail

13 Answers   Jamcracker, Snap On,


how many test cases u write in day while testing yr application.and wat z ur role after u finished testing application plz do reply

9 Answers  


explain with examples- transaction testing, syntax testing, domain testing, logic testing, and state testing.

1 Answers  


how to write a jwebunit testcase for ejb3.0 project

0 Answers   Wipro,






Do you know explain security testing?

0 Answers  


Can any one please tell me what is the use of negative test cases when we are giving the invalid input in test data

3 Answers  


Write a test case for yahoo

2 Answers  


Given the following code, which is true about the minimum number of test cases required for full statement and branch coverage: Read P Read Q IF P+Q > 100 THEN Print “Large” ENDIF If P > 50 THEN Print “P Large” ENDIF how to find statement and branch coverage? Explain in brief?

0 Answers   ISTQB,


If there are 3 modules what would be test for that three modules but that 3 modules are not developed or what are the test case for that 3 modules

0 Answers  


need for documenting test cases??? advantages and disadvantages of documenting test cases???

2 Answers  


If the pseudo code below were a programming language ,how many tests are required to achieve 100% statement coverage? 1. If x=3 then 2. Display_messageX; 3. If y=2 then 4. Display_messageY; 5. Else 6. Display_messageZ; 7. Else 8. Display_messageZ; A. 1 B. 2 C. 3 D. 4

1 Answers   ISTQB,


Categories