disc

• Aug 8th, 2006

 

to do database testing manually means doing it at the backend using sql (or any query language)statements directly on the tables and retreiving the data, this is my view if i am wrong then anybody is free to correct it.

suresh0249

 Profile 

• Aug 9th, 2006

 

hai,

data base testing is done by validating or verifying the data base not by writing any SQL quary in manual testing  so go through what the requirements we need that sol.

if any mistake please give me a reply.

joseph

• Aug 10th, 2006

 

Using Sql quires ...

Narendra

• Aug 17th, 2006

 

Hi,

As per my knowledge, we have to verify & validate the data in the database table. To do so first of all record the data present in the table by firing the query for particular action. Then add/modify/delete the data in the table. Then fire the same query again. Observe the modification in the datatable. If actual result matches expected result, the test cases passes otherwise fails.

Narendra.

devi

• Sep 1st, 2006

 

hi,

data base testing is done manually,to test the contents of data base and also to retrieve and storage activities of data base

in the way to test,its contents, first query the data base,get the result,take the snap shot of it.tehn compare both cell by cell manually.this is B.E ~ B.E

to test whether store And retrievals are done properly from data base,first query the data base through GUI,get the result and take snap shot  of it.

again query the data base directly by skipping the GUI,get the result set ,and compare the both cell by cell.this is F.E~B.E testing

chitra s

• Sep 12th, 2006

 

Yes database testing is done from the backened using SQL queries. Generally only select commands are used to verify the data. The data retrieved is compared to the Expected results.

Seetha lakshmy

• Nov 2nd, 2006

 

First, using the SQL query(mostly Select command with joins used) get the data from the database.

Then Compare that data with the frontend whether the back-end data is correctly displayed in the front-end.

Sanjeet

• Dec 15th, 2006

 

Database testing means to test 3 things:-

                   1.Whether data is storing and retriving from db or not:-

 To check this we can take the help of Sql Profiler and Query Analyser if ur using SQL Server

                   2. Performance of the query :-

 To check this we have to check the optimization of those queries.And to check whether Indexing is proper in that application or not.

                   3. Other properties of Tables:-

 Check other properties such as :- If data length is more than specified data type length,memory overflow should not be there etc......

       If i m wrong plz rectify me...........

 Thanks

 Sanjeet

                    

M.Praveen

• Aug 14th, 2007

 

Hi, As per my knowledge, we have to verify & validate the data in the database table. To do so first of all record the data present in the table by firing the query for particular action. Then add/modify/delete the data in the table. Then fire the same query again. Observe the modification in the datatable. If actual result matches expected result, the test cases passes otherwise fails and at the same time we should also test wheather the data is coming to front end form the corresponding table and their respective columns or not.