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
Can anybody help me in writing test cases for a scenario? need help at the earliest. will send you the requirement doc to your email id. thanks raj
hai we need to get some data from a logfiles and populate into database .to check this we need to write test cases .how to write test case for this scenario tell me as functional and stress testing differ
how to prepare a test case for online restaurant table reservation system. plz give an answer ASAP, email at suja_rvndrn@yahoo.co.in
If I have to write the test cases for any report & there is date box.then may I have to write only select date or have to write all steps required for selecting date
In manual testing, I have query regarding data conversion testing. I am working on xml document. How do we write test cases for below input as well as for output
Input:
Who will take care of test plan and test case?
Sample test cases for data conversion(Utility billing system)
How to generate test cases for 'replace a string' method?
Write Test cases for the below scenario? scenario 1: Replace the current CSS software with TML software. Scenario 2: Provide the same reports for business as currently provided by CSS software. Not: CSS and TML are customized software.
How to write test case for this scenario. The system shall allow for a wild card search for the last name with a minimum of one character
Explain the gray box testing?
Write test cases for 8+4?
How to write the test cases for STP
What is test environment? Elaborate with example.
What is use case testing?
