Database Testing Checklist - Bug Reaper

                  Bug Reaper

Lean about Automation Testing,Selenium WebDriver,RestAssured,Appium,Jenkins,JAVA,API Automation,TestNG,Maven, Rest API, SOAP API,Linux,Maven,Security Testing,Interview Questions

Friday, 27 September 2013

Database Testing Checklist





1.) Data integrity

The complete data belonging to each entity should be stored in the database. Depending on the database design, the data may be present in a single table or multiple related tables. Parent-child relationships should exist in the data. There should not be any missing data.

a.)
Is the data stored in tables is correct.
b.)Is there any unnecessary data present.
c.)Is the data present in the correct table.
d.)Is the data present in correct field within the table.



2.)Database performance (query execution times, throughput etc.) and locking problems
You may identify the main queries (or procedures) that are used in the application and time them with sample data. Locking problems may become apparent when multiple inserts/ updates are being made 
to the same entity simultaneously.

3.)Data security

You may check if any data that should be encrypted e.g. passwords, credit card numbers is in plain text or not. The database should not have the default passwords. Even application accounts should have passwords that are complex and not easily guessed.



Miscellaneous

a.)Are the log events added in database for all login events
b.)
Does scheduled jobs execute timely.
c.)
SQL Injection should not be allowed and handled properly
d.)Backup and Recovery:Is timely backup of Database taken.

e.)
Security:Is the data secured from unauthorized access:  Are different user roles created with different permissions
Do all the users have access on Database

f.)
Is the Field length specified on UI same as field length specified in table to store same element from UI into database.
g.)Check for Primary key:  For Primary key 'Allow Null' condition should not be allowed.
h.)Check for each field and UI element:  Field length of field in data base and on UI(if mentioned) should be same.

19 comments:

  1. I would really like to read some personal experiences like the way, you've explained through the above article. I'm glad for your achievements and would probably like to see much more in the near future. Thanks for share.
    python course in pune
    python course in chennai
    python course in Bangalore

    ReplyDelete
  2. I always enjoy reading quality articles by an individual who is obviously knowledgeable on their chosen subject. Ill be watching this post with much interest. Keep up the great work, I will be back

    angularjs Training in chennai

    angularjs-Training in tambaram

    angularjs-Training in sholinganallur

    angularjs-Training in velachery

    angularjs-Training in pune

    angularjs Training in bangalore

    ReplyDelete
  3. The knowledge of technology you have been sharing thorough this post is very much helpful to develop new idea.
    here by i also want to share this.
    Java training in Bangalore|best Java training in Bangalore
    Java training in Chennai
    Java training in Bangalore
    Java online training
    Java training in Pune

    ReplyDelete
  4. Nice Post! Thank you for sharing very good post, it was so Nice to read and useful to improve my knowledge as updated one, keep blogging.
    Angular js Training in Electronic City

    ReplyDelete
  5. It is explained in clear way. It is very easy to understand the information.

    Best SAP Training in Bangalore for SAP, we provide the sap training project with trainers having more than 5 Years of sap training experience, we also provide 100% placement support.

    ReplyDelete
  6. Great site you have got here.. It’s difficult to find high quality writing like yours these days. I truly appreciate individuals like you! Take care!!

    ReplyDelete
  7. nice work! This is the type of information that should follow the web. Embarrassment captivating position Google for not positioning this transmit higher!keep on sharing!!

    Android Training in Chennai

    Android Online Training in Chennai

    Android Training in Bangalore

    Android Training in Hyderabad

    Android Training in Coimbatore

    Android Training

    Android Online Training

    ReplyDelete
  8. Myself so glad to establish your blog entry since it's actually quite instructive. If it's not too much trouble continue composing this sort of web journal and I normally visit this blog. Examine my administrations.  
    Read these Salesforce Admin Certification Topics which are really helpful. I read these Salesforce Admin and Developer Certification Dumps and very much useful for me. 

    ReplyDelete
  9. Thanks a lot very much for the high your blog post quality and results-oriented help. I won’t think twice to endorse to anybody who wants and needs support about this area.

    java training in chennai

    java training in velachery

    aws training in chennai

    aws training in velachery

    python training in chennai

    python training in velachery

    selenium training in chennai

    selenium training in velachery

    ReplyDelete
  10. This post is so interactive and informative.keep update more information...
    Android Training in Tambaram
    Android Training in Chennai

    ReplyDelete