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 |
what is testing?
5 Answers Naukri.com, RealTech, TCS, Value Labs,
what is mean by service level testing? what will come under this?
Imagine you are in an empty room with a fan, a bulb and an air conditioning system. There is a switch board on the wall with 32 switches and 2 plug points. You are tasked with testing this setup. Assume you are not given any requirements whatsoever. How would you approach it? What would be your priorities? If you make any assumptions, do state them.
what is the diff between application server and data base server?
What is the diffrence between Beta Testting & Acceptance Testing
send the senario template
what is the general pattern of explanation of projects in interview, can u ans me plz.......... ex: online banking application
What is known issues?
3 Answers Mantra Media, Yardi,
What is Internalisation testing?
what is the difference between waterfall model & v-model?
what is entry criteria for testing?
what is the diffrence between qualityassurance and system testing explain in detail with an example?
3 Answers Cap Gemini, iFlex, Mind Tree, Zenith,