[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]

    Search the Q&A Archives

what do u test for in database testing other than data...

<< Back to: comp.software.testing Frequently Asked Questions (FAQ)

Question by kvs
Submitted on 2/28/2004
Related FAQ: comp.software.testing Frequently Asked Questions (FAQ)
Rating: Rate this question: Vote
what do u test for in database testing
other than data integrity(insert, delete, update...)


Answer by Sonu
Submitted on 3/19/2004
Rating:  Rate this answer: Vote
This will not be exact Testing but can be done as verification.
Field size validation with the Front End or with the Design.
Field size validation, if application is having data for multiple language.
Return type of each function and Out Parameter for each procedure.
If Data base is any file Generation routine that can be tested.

 

Answer by Rohan
Submitted on 4/18/2004
Rating:  Rate this answer: Vote
In DB testing we need to check for
1. The field size validation
2. Check constraints.
3. Indexes are done or not (for performance related issues)
4. Stored procedures
5. The field size defined in the application is matching with that in the db.

 

Answer by dfsdfs
Submitted on 6/17/2004
Rating:  Rate this answer: Vote
xfgdrgdfgcfgdfgsdfjdehsdhfgshdgfshdgfsdhsdgfhsdgfhsdgfshgdfjgdfshdgfsdhgfsdg

 

Answer by jayakrishna
Submitted on 6/19/2004
Rating:  Rate this answer: Vote
we can validate the columns length with our design requirements
and we can check whether all the data from the application is being inserted into the database properly, or not
imposes constraints on the data i.e. database integrity

 

Answer by Saravanakumar
Submitted on 8/9/2004
Rating: Not yet rated Rate this answer: Vote
With the all above answers, database replication and database fail-over can also be tested.

 

Answer by sug
Submitted on 8/12/2004
Rating: Not yet rated Rate this answer: Vote
To get the row count and column count

 

Answer by rajiv
Submitted on 8/24/2004
Rating: Not yet rated Rate this answer: Vote
database testing is done mainly for five reasons:
1.relevance of search results
2.data intigrity
3.data validity
4.data recovery
5.security

 

Answer by Gautam Bhanage
Submitted on 11/29/2004
Rating: Not yet rated Rate this answer: Vote
There should be a integrity check and a domain value check that ensures that the values are being properly entered in the database. Also, retrival and updation from the database should be checked based on various operations like insert, update and delete.

 

Answer by suri
Submitted on 1/7/2005
Rating: Not yet rated Rate this answer: Vote
check the data with insert, modify,retrive, delete options by writing quiries. and also use the storeprocedures.

 

Answer by vasu babu
Submitted on 1/10/2005
Rating: Not yet rated Rate this answer: Vote
1) referential integrity
2) validation of constraints
3) validation of data
4) Indexes
5) deadlocks
6) Stored procedures
7) normalization

 

Answer by Ganti
Submitted on 3/2/2005
Rating: Not yet rated Rate this answer: Vote
Database Testing is Useful for:
1.To check whether all the data entered in Front end is updating in the Back end respective tables or not.
2. Checking Field size of every column.
3. Checking the datatype validation.
4. Checking and verifying the stored Procedures and triggers working.
5. Data Truncation.

 

Answer by Shakil Jamshedpur
Submitted on 3/25/2005
Rating: Not yet rated Rate this answer: Vote
first of all we check the client is loaded on the system where we are testing. we check each columns data type, size, constraint by putting correct data and verify by putting incorrect data. column name is according to data model or not. whether accepting defined data type. we see relation between tables are according to data model or not. we check data integrity, stored procedure, trigger if defined(means firing on particular action or not). etc.

 

Answer by ramesh
Submitted on 4/23/2005
Rating: Not yet rated Rate this answer: Vote
It is used for checking the database constraints, field size validation, background color, procedures and functions etc.,

 

Answer by sajn
Submitted on 4/24/2005
Rating: Not yet rated Rate this answer: Vote
> Length of fields
> Check if it inserts garbage values if the field entered on form is blank
> Check for special characters; what values does it put in database, etc.
> Max column width; also, make sure they match with what the field requires in the requirements.
> Entering numbers, characters, and special characters

 

Answer by saleem meer
Submitted on 4/25/2005
Rating: Not yet rated Rate this answer: Vote
existing of database,exe of database,records,triggers,joints

 

Answer by GuruJi
Submitted on 5/11/2005
Rating: Not yet rated Rate this answer: Vote
Database Testing is a broad term and depends on what type of data it holds.If it's a web server,we emphasise on links retrival and CPU/Memory related performance and usage aspects.

 

Answer by suren
Submitted on 5/16/2005
Rating: Not yet rated Rate this answer: Vote
excellent

 

Answer by ramesh.subburam
Submitted on 5/26/2005
Rating: Not yet rated Rate this answer: Vote
Database Tesing is higly used in Migrated application particularly for Oracle to Latest technology like .net or J2EE because Most of the application doesn't contain the complete functional document. Hence there is lot of chance in missing the functionality of the application so only by database testing we can check the complete functionality of the application.

 

Answer by siri
Submitted on 5/31/2005
Rating: Not yet rated Rate this answer: Vote
Check constraints
The field size defined in the application is matching with that in the database

 

Answer by Srinivas
Submitted on 6/7/2005
Rating: Not yet rated Rate this answer: Vote
Checking field length, field type.
Check for proper data inserted in database.
Check for stored procedures created or not.
Check the triggers are created properly.
check the Constraints.
Check the Primary and foreign key inserted or not.


 

Answer by booger
Submitted on 6/17/2005
Rating: Not yet rated Rate this answer: Vote
Manipulation Testing – Insert/Edit and Delete (valid) data from the three tables
Validation Testing – Test each constraint implemented from task 2 by entering invalid data and make sure it is not allowed
Relational Testing – Test the relation between the two tables is done properly by trying to create an appointment with a non existing contact and trying to assign a non-existing company to a contact.
Integrity testing – try to delete a contact who has some appointments and try to delete a company which has contact allocated with it.

 

Answer by KVembu
Submitted on 7/13/2005
Rating: Not yet rated Rate this answer: Vote
Volume, Capability, and Reliability of DB.

 

Answer by simran
Submitted on 7/15/2005
Rating: Not yet rated Rate this answer: Vote
about database testing

 

Answer by karims
Submitted on 7/27/2005
Rating: Not yet rated Rate this answer: Vote
Data base testing should be able to verify data integrity controls,
including checking backup and recovery procedures, access control, and data validation rules.

 

Answer by vijay
Submitted on 8/18/2005
Rating: Not yet rated Rate this answer: Vote
We check for what we inserted from the Frontend and at the time of retrieval what values are displaying in the Frontend.
Take care
bye

 

Answer by meetsubaa
Submitted on 8/27/2005
Rating: Not yet rated Rate this answer: Vote
always

 

Answer by Mehul
Submitted on 9/5/2005
Rating: Not yet rated Rate this answer: Vote
How can we test Database?

 

Answer by hari
Submitted on 9/20/2005
Rating: Not yet rated Rate this answer: Vote
Backend testing includes testing how the data inserted from the application is stored in the databast tables. Query that data to test if it is saving in the DB. Checking the Inserted data is stored in the proper columns of the proper tables.

 

Answer by ruchi gupta
Submitted on 9/29/2005
Rating: Not yet rated Rate this answer: Vote
1-duplicate related checks
2-check all the functions n stored procedures
3-data integrity , check constraints
4-check the whether data are properly coming into database .

 

Answer by Nitin
Submitted on 10/5/2005
Rating: Not yet rated Rate this answer: Vote
Actually the database testing is like data verification.
If it is the database transfer from one type of  database to another e.g paradox to ms sql, first of all we can check the number of records, then number of fields(columns) and then values.

 

Answer by Nani
Submitted on 10/6/2005
Rating: Not yet rated Rate this answer: Vote
Database testing includes various factors such as:
1. Table consistency.
2. Query Consistency.
3. Query performance.
4. Procedure Consistency.
5. And also checks whether all the tables are in normalized form or not.bcoz which will make a query to drag exact result.

 

Answer by chinni
Submitted on 10/11/2005
Rating: Not yet rated Rate this answer: Vote
its an audition made on the database for the satisfaction of all the constraints, when data is entered from GUIs

 

Answer by Sumeet Mali
Submitted on 10/24/2005
Rating: Not yet rated Rate this answer: Vote
i.e Only Verification can be done in Database Testing. Can anyone please let me know if w can test the database by modifying the fields lenght ?

 

Answer by srilathat
Submitted on 12/5/2005
Rating: Not yet rated Rate this answer: Vote
we can validate the front end and back end column attributes position.
We can check all the relevant fields data in application and database in correction position or not.
For instance if the defined designed requirements is to register first name and last name , but the db table is created with last name and first name. The data should be inserted at their relevant positions.
imposes constraint on the data i.e. domain integrity.

Mail me if this sounds unclear
saisri_8@rediffmail.com

 

Answer by jesh
Submitted on 1/6/2006
Rating: Not yet rated Rate this answer: Vote
1. Check the Fields are defined Correctly in the Respective tables.
2. Check the Field length
3. Check the Realtionship b\w tables
4. Check the Dependencies b\w tables
5. Check the Primary Key & foriegn  keys are Defined for respective tables.
6. Checkall the data Integrity testing Such as Insert,delete.update....
7. Data Vaildation
8.Load testing
9. Check Stored Procedure,indexs,triggers are defined

 

Answer by deepak
Submitted on 3/9/2006
Rating: Not yet rated Rate this answer: Vote
If the database is designed with ERWin, the complete compare feature is there. It will pull out all the mismateches between the model and the actual implementation .

 

Answer by sudhir
Submitted on 3/14/2006
Rating: Not yet rated Rate this answer: Vote
ODBC manually by creating SQL
use data junction to create conversion file  converts database to target text file.
in WR creatte DB cp

it is three types  

 

Answer by kiran
Submitted on 4/11/2006
Rating: Not yet rated Rate this answer: Vote
DB can be tested for
1.functionality
2.performance
in functinality we test the business rules,mandatory or optional kind of things,and field level validationslike length etc.
in performance we test constraints,indexed,stored procedure etc
we also have to test the mapping kind of things like insert,delete update etc

 

Answer by ashish thapliyal
Submitted on 5/5/2006
Rating: Not yet rated Rate this answer: Vote
and we can check whether all the data from the application is being inserted into or retrieved from the database properly, or not

 

Answer by Kumar
Submitted on 5/24/2006
Rating: Not yet rated Rate this answer: Vote
Other then SQL, the DB testing includes, all the GUI constraints, check for the Data population in the DB, test the load( Load testing), Performance testing, Import and Export of Data, And also depends of the applications and front end and back end

 

Answer by Kumar
Submitted on 5/24/2006
Rating: Not yet rated Rate this answer: Vote
Other then SQL, the DB testing includes, all the GUI constraints, check for the Data population in the DB, test the load( Load testing), Performance testing, Import and Export of Data, And also depends of the applications and front end and back end

 

Answer by suni
Submitted on 6/12/2006
Rating: Not yet rated Rate this answer: Vote
Database testing is depend on the application.checking column name are in meta data formate(length,breath....ect).Test joints are working.upadate ,insert,delete all commands are working properly or what.

 

Answer by suni
Submitted on 6/12/2006
Rating: Not yet rated Rate this answer: Vote
Database testing is depend on the application.checking column name are in meta data formate(length,breath....ect).test joints are working.upadate ,insert,delete all commands are working properly or what.

 

Answer by Favad
Submitted on 6/20/2006
Rating: Not yet rated Rate this answer: Vote
In database testing the major activities we have to check is Transaction logic and Concurrent execution of the application.

This means whether the application is following the ACID rules or not.

 

Answer by Scott Ambler
Submitted on 7/1/2006
Rating: Not yet rated Rate this answer: Vote
I wrote a detailed article about database testing at http://www.agiledata.org/essays/databaseTeting.html which you may find interesting.  

- Scott

 

Answer by sadheesh
Submitted on 7/4/2006
Rating: Not yet rated Rate this answer: Vote
How to do gui testing manually?

 

Answer by ghfhfhf
Submitted on 7/8/2006
Rating: Not yet rated Rate this answer: Vote
gdfsgfgsdfgdfgdgsfgsgsdfgsdfgsdfgsdgsdgfsdfgsdgsdgsdgsd

 

Answer by anik
Submitted on 7/15/2006
Rating: Not yet rated Rate this answer: Vote
by checkig the fiels size validations which is given in prd and checking the values are stored correctly ..and checking the constarints

 

Answer by uykkk
Submitted on 7/31/2006
Rating: Not yet rated Rate this answer: Vote
,jk,j,,j,

 

Answer by Chinmaya
Submitted on 8/1/2006
Rating: Not yet rated Rate this answer: Vote
In database testing..the following areas should be tested :

1. referntial integrity
2. data integrity
3. data validation
4. performance of triggers.
5. validation of stored procedures.
6. column field size validation.

 

Answer by Brij Bhan Singh
Submitted on 8/22/2006
Rating: Not yet rated Rate this answer: Vote
By database Testing we can ensure data being populated accurately as instructions i.e. insertion, deletion, Updation etc.It also ensure the constrant, Integrity, and latest data having all the tables.

 

Answer by syeda safia
Submitted on 9/4/2006
Rating: Not yet rated Rate this answer: Vote
database testing is nothing but testing the front end field effect on backend database tables and comparing whether it is changing pertaining to it or not

 

Answer by suresh kumar pattapagalu
Submitted on 9/13/2006
Rating: Not yet rated Rate this answer: Vote
Data Base Testing Generally deals with date which is flowing in integrated application,should reflect in database,if we fire a query it should able to show all the details which were enter to test the functionality and database.(ex:::In a school/Banking domain if we r entering name of the customer,it should be saved in the database..As a test engineer we r testing that the name is added in the database or not soon)
2)field size is also compared between application and database.

 

Answer by jay
Submitted on 9/26/2006
Rating: Not yet rated Rate this answer: Vote
please provide me with various steps to be taken care when u r testing db migration

 

Answer by ishtiaq
Submitted on 10/6/2006
Rating: Not yet rated Rate this answer: Vote
stored procedures plays an important role in database testing.
Start testing from backend to get more results.

 

Answer by VijayReddy
Submitted on 11/13/2006
Rating: Not yet rated Rate this answer: Vote
Database Testing is to check the backend of each apllication, This includes all the,
1) Lenths of fields,
2) Primary keys,
3) Parent fields,
4) check constraints,
5) Triggers,
6) Mendatory Fields,
7) Unique fields.

 

Answer by Scott Ambler
Submitted on 12/10/2006
Rating: Not yet rated Rate this answer: Vote
At http://www.agiledata.org/essays/databaseTesting.html I have a fairly extensive article describing database testing.  You can test both at the interface to the database (black box testing) and internally within the database (clear box testing).

- Scott

 

Answer by mohan
Submitted on 2/9/2007
Rating: Not yet rated Rate this answer: Vote
In database testing we test for whether data integrity , we will check whether the constraints are working as per requirement,test the security of the database, provided that only authenticated users might use the database , verifying the replication process etc

 

Answer by w a n k
Submitted on 4/1/2007
Rating: Not yet rated Rate this answer: Vote
Hello thar i like to w a n k

 

Answer by Abhinav
Submitted on 5/2/2007
Rating: Not yet rated Rate this answer: Vote
Verify if the data is populated in the right tables and verify when updated any data value, its updated in all the appropriate tables of the database corerctly.

 

Answer by satya
Submitted on 5/17/2007
Rating: Not yet rated Rate this answer: Vote
In DB testing
1) we will check like what data we entering in the front end weather it going correctly in table (data base)
2) Field level validation
3) stored procedures


 

Your answer will be published for anyone to see and rate.  Your answer will not be displayed immediately.  If you'd like to get expert points and benefit from positive ratings, please create a new account or login into an existing account below.


Your name or nickname:
If you'd like to create a new account or access your existing account, put in your password here:
Your answer:

FAQS.ORG reserves the right to edit your answer as to improve its clarity.  By submitting your answer you authorize FAQS.ORG to publish your answer on the WWW without any restrictions. You agree to hold harmless and indemnify FAQS.ORG against any claims, costs, or damages resulting from publishing your answer.

 

FAQS.ORG makes no guarantees as to the accuracy of the posts. Each post is the personal opinion of the poster. These posts are not intended to substitute for medical, tax, legal, investment, accounting, or other professional advice. FAQS.ORG does not endorse any opinion or any product or service mentioned mentioned in these posts.

 

<< Back to: comp.software.testing Frequently Asked Questions (FAQ)

[ Home  |  FAQ-Related Q&As  |  General Q&As  |  Answered Questions ]
© 2008 FAQS.ORG. All rights reserved.