Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 View All Answers
What is gray box testing?
WE WANT HEALTHINSURENE PROJECT FUNCTIONAL TEST CASES
This was asked to me recently in Microsoft interview How would you do DOS copy command testing
Explain the gray box testing?
Can any tell to create test data for SUM (calculation), Scenario is 0 to 9 digits are available as we see in the calculator, I want to certify that the sum of the two numbers are working fine by providing test data.
i m a fresher working in healthcare industry. here we hve no tool for testing. how i ll do manual testing?plz suggest anyone me urgently... i knw to write test case bt i dont knw where to write n how to execute it manually
Explain the unit testing?
Explain the sanity testing?
Explain the glass box testing?
What are basic types of test cases?
Explain the ramp testing?
how to write test cases for the example state name starts with A B C D E F G H I J K L Z
What is component testing?
How to write test case for this scenario. The system shall allow for a wild card search for the first name with a minimum of one character.
How to write test cases for lift?
