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

How to find that tools work well with your existing system?

1589


What is an mr?

665


what is the relation between all tabs in quality center & explain the testing process in quality center with tabs?

1575


What are the Major Functionality for a ATM machine ??

4970


Hi Friends, I have completed 3 rounds of an Interview with HR discussion also and got Offer letter from Cognizant, but after in 30 min they send one more email like Offer is on Hold, and its not valid... Could you please guide me any one , Can i expect Offer again from Cognizant or Can i drop the hopes ?.

1366






What is bottom-up approach?

670


What is the difference between code walkthrough and code review? What is the difference between walkthrough and inspection?

2489


a newly launched web site is hosted on web server.It is expected that 100 people visit the website every hour and browse 30 pages spending a total 15 minutes. what is the maximum hits/sec that the web server should support this load?justify your answer. need urgently. by rimesh

1409


What is meant my Firewall testing? how the testing is performed on it?

1775


Can anybody give me some tips on how to face telephonic interview and Write some expected telephonic questions as a 2+yr exp. in testing. Try to give Ques. that u already hv faced in telephone. Plz Help me out friends.

1593


What is client server application testing?

1535


What r the sequences that leads to automation?

1496


Information about Automated Software Installer

1449


What is mean by incident logging system ?

2024


You have a testing team of 10 members, and now you have to reduce it by 5 member and you dont want to increase risk in your product, you are try to cover all functionality to test. What test Strategy you follow.

2122