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
Explain transaction testing?
How to write test case for this scenario. The system shall auto populate the Email Address on the contact screen with the Email Address of the user profileĀ
Explain the load testing?
Can someone tell me the test cases to test the password for with following scenario: 1. Password should be minimum 6 chars and maximum 8 chars. 2. Password should consist one uppercase letter 3. Password should consist of one numeric 4. Password should consist of one special character.
write test case for button of google page?"i am feeling lucky" if button is not appear on page?
What is gray box testing?
can anyone please help me in writing Test cases for HRMS,ERP and for CRM Apllications...I am joined as a trainee.so i have to write test cases for these applications..Soo can anyone pls help me....mail id: bapuji.karyampudi@gmail.com....Please reply me guys.
How to write test case for this scenario. The system shall compare the requested name with the Service Member Name field in the database
Elaborate test plan and content availability in test plan.
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?
Can some body help to write possible test cases for a credit card at POS (point of sale)
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
Write all test cases for Bus Pass Renewal
Explain the soak testing?
write test cases for flipkart.