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
Pls tell me test cases for pepper grinder
How to write email id in world wide web
write a test case for telephone billing ?
How to write test cases or test scripts for UAT testing which is done manually
Elaborate test plan and content availability in test plan.
Positive and Negative test cases for the speedometer?(minimum 5 each)
can any body help me with providing a a case for usability testing...
Can any one tell me how to write test data. i mean, to test each input, 2 test input(1 for +ve, & other for -ve) are given. so , for example, if i want to write test data for login form, how many test data should i write in test case?
Write a test case of login window?
Explain the state testing?
Write a test case for a car, which has been, recently launch in a market to check its durability, fuel efficiency and its optimum speed.
Can some body help to write possible test cases for a credit card at POS (point of sale)
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
How many test cases u will write for Adhoc testing? How many test cases u will write for Alpha testing? How many test cases u will write for Beta testing? How many test cases u will write for Release candidate testing? How many test cases u will write for Product release testing? How many test cases u will write for Functional testing? How many test cases u will write for Non-Functional testing? How many test cases u will write for Integration testing? How many test cases u will write for System testing? How many test cases u will write for Component testing? How many test cases u will write for Release testing? How many test cases u will write for Load testing? How many test cases u will write for Stress testing? How many test cases u will write for Black box testing? How many test cases u will write for White Box testing? How many test cases u will write for Performance testing? How many test cases u will write for Automation testing? How many test cases u will write for Compatibility testing? How many test cases u will write for Regression testing? How many test cases u will write for Endurance testing? How many test cases u will write for System Integration testing? How many test cases u will write for Boundary value testing? How many test cases u will write for Usability testing? How many test cases u will write for Walk through testing? How many test cases u will write for Sanity testing? How many test cases u will write for Smoke testing? How many test cases u will write for Installation testing? How many test cases u will write for Soak testing? How many test cases u will write for Volume testing? How many test cases u will write for Security testing? Write test cases for Multi path testing? How many test cases u will write for Multi path testing? Write test cases for Dynamic Capacity Expansion (DCE)? Write test cases for Dynamic Volume Expansion (DVE)? Write test cases for Dynamic Raid Expansion (DRM)? Write test cases for Drive failure? Write test cases for Controller Failover? Write test cases for Cable pull? Write test cases for RAID Controller?
How to write test case for this scenario. If the Zip Code field is populated, the system shall compare the zip code value entered to the zip code value in the Family Individual Information Tab
