how do we do database testing manually.Suppose if i want to
check whether a particular record is inserted in the
database or not.

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

In how many ways you perform batchtesting ?

1525


1.For a single module how many builds are possible 2.what will be the max or min time to finish up an single module

1585


Write the 10 high test cases for making video call/face time?? Write the test cases for credit card accessing the money transfer?? Write the test cases for file transfer from one user to other from Google Drive/drop box?

3649


how recovery manager works in winrunner

1563


What is boundary value testing? Give an example.

720






What are the main key components in client and server applications?

701


Can anyone write test cases on google account creation page in the testing template format , urgent pls and explain if possible how to execute also

1590


Scenario A year ago we developed a standards compliant website for a client. Their site is very popular resulting in the client wanting to be able to track how it is being used by their users. The first part of this project is to create a Login function so that users can be identified on the website. The data supplied by users would have to be handled securely. You have been allocated this project to work on. You will be responsible for the task from start to finish and will be expected to give feedback to your manager. User expectations  The client wants their users to be able to login using a page that fits in with the website design.  Tom wants to access the website but doesn’t want his login information to be available to anyone else.  Paul doesn’t want to login to the website because he’s not a frequent user. Task Please provide some feedback on how you would do the following:-  Being the only Test Engineer on this task, what would your approach be for this requirement?  Identify the key areas for testing this page.  What tools if any, would you use to perform the testing, bearing in mind that the testing will be done without using an ‘automated test tool’.  Provide a sample test case that could be used for testing this page, for example as a word or Excel document.

1458


how to indentify memory leakages after the build

1646


What are the different ways of doing black box testing?

655


wht is Manual Testing Frame work

1666


Artifacts in design phase of SDLC ?

3080


What is the difference between web based application and client server application?

5484


What r the sequences that leads to automation?

1513


Write the test cases for yahoo home page

1701