how do we do database testing manually.Suppose if i want to
check whether a particular record is inserted in the
database or not.
Answers were Sorted based on User's Feedback
Answer / satish
Open the database and verify whether record is updated. For
that you should have good command in SQL.
correct me if I am wrong
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / jagadish
checking whether newly inserted result is correctly existed
or not is called data validation.For just open the table and
check whether the new record added or not
insert the data from the front end end and check the
corresponding table is updated with the record by using
enterprise manger to check the data base and its table for
this u have to know the corresponding table which will store
the data. or use the queiry analyzer to write the queiry to
check the table is updated with the data or not this is good
as u can check for the table which contains no of record.
initial at the build of project u can check the records by
just checking the tables manually. it is not required by the
testers to learn the sql queiry language as the developers
will give the quiery used
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / vish
via querrying and
login with the created user name then u will come to know.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / satyaprasad
checking wether newly inserted result is correctly existed
or not is called datavalidation.For just open the table and
check wether the new record added or not
Is This Answer Correct ? | 0 Yes | 0 No |
If you are a database tester. They will provide you with ER
diagram ( This diagram shows how many tables are in the
database and how they are inter related including the
primary and foreign keys.) If you can figure it out in which
table the data is inserted or you can take help from
developer, write the SQL query and check the table. It will
be easy if you use query because table contain vast data and
if you go through the table it takes lot of time.
Is This Answer Correct ? | 0 Yes | 0 No |
Could anyone share FAQs for Test Manager position...
What is Defect Leakage?What Gap Analysis? What are the functioanl requirements to test the Software? What is Latency bug?
3 Answers Tavant Technologies, Yardi,
is test data the same as test condition
How do we estimate the number of test cases?
Written Paper at Net Solutions: 1) Difference between Smoke Testing and Sanity Testing. 2) Bug life cycle. 3) Write the steps followed in STLC in your company. 4) Define: 1) BVA (Boundary Value Analysis) 2) ECP (Equivalence Class Partitioning) 5) Write test cases for a login screen with following fields/buttons: Username: Password: Login (Button) Cancel (Button)
Can anyone explain about metrics
When will the testing starts? a)Once the requirements are complete b)In requirement phase
Hi,Please can any one tell me about SAP Testing concepts.
What is a testbed in manual testing?
What is the main use of preparing traceability matrix and explain the real time usage?
What r test closure documents?
For Editing functionality: If there are 10 fields on survey form.User can edit anything from theese 10 fields. User can edit only first field or he can edit 3 fields at a time or can edit all 10 fields at a time or can edit 1 field of one survey form, 2nd field of 2nd survey form, 3rd field of 3rd survey form etc. upto 10th fields or nothing will edit & close the form . My question is --> I have to write test cases for above all scenarios? Let me know it's urgent.