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
Write the use cases for following 1. Comment section of Facebook 2. Instagram status Implementation
Explain the domain testing?
write the testcases for migrating data from one database to another database?
How to write a test case for create folder in the email. create aliases for email adress in the email. thanks Its urgent
What is the state testing?
how to test stand alone programs?
How does the size of the OPCODE field limit the number of operations? Give an example to support your explanation?
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
WE WANT HEALTHINSURENE PROJECT FUNCTIONAL TEST CASES
Pls tell me test cases for pepper grinder
Which of the following defines the expected results of a test? Test case specification or test design specification.
How to write test cases for the following scenario: The system shall limit the search result display to 200 records. Do we need to write test data for it. How do we create a test data for it.
Some test case for mambo cms (only basically: graphic, function...) Thanks for answer.
They were asking sily questions and definitions rather than practical experience related questions. More focused on Definitions.
Explain the concurrency testing?
