Results 1 to 3 of 3

Thread: database testing

  1. #1
    Junior Member
    Join Date
    Dec 2006
    Answers
    20

    database testing

    1.what is meant by"The field size defined in the application is matching with that in the db".
    2.what is field size validation in database testing.


  2. #2
    Junior Member
    Join Date
    Jun 2006
    Answers
    17

    Re: database testing

    Hi all,

    For every field that we enter through UI have certain field length which is defined in the database tables already.
    for example,
    While creating a new user id for Gmail account, when u enter the field
    "Desired Login Name" more than 30 chars or less than 6 chars, It'll display a message like "Sorry, your username must be between 6 and 30 characters long".
    So when we enter the field it'll not accept because the field length is more than 30 chars, as Database doesn't allow more than 30 chars. This is nothing but field validation in DB. In this way we'll verify that field length by giving different combinations .


  3. #3
    Expert Member
    Join Date
    Nov 2006
    Answers
    518

    Re: database testing

    Every db is designed with db constraints.

    Example, Name should be less then 30 characters. Anything more then 30 is invalid.

    1) If data is entered directly into the db using SQL command like “INSERT” then the appropriate error message is displayed to the user and the data is not inserted into the db table.

    If the same functionality of entering data into the db is handled by a s/w application, then this s/w needs to ensure that it sends correct data to the db that doesn’t violate any of the db constraints.

    So, to ensure that the s/w application sends correct data to the db, the controls in the s/w application should also be defined with the same constraints as that of the respective table in the db. This means "The field size defined in the application is matching with that in the db".

    2) Field size validation in db testing is to test the db if it correctly implements the defined constraint. i.e. to check weather or not the db is restricting the user from entering more then 30 characters for Name in the above example.

    Lack of WILL POWER has caused more failure than
    lack of INTELLIGENCE or ABILITY.

    -sutnarcha-

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
About us
Applying for a job can be a stressful and frustrating experience, especially for someone who has never done it before. Considering that you are competing for the position with a at least a dozen other applicants, it is imperative that you thoroughly prepare for the job interview, in order to stand a good chance of getting hired. That's where GeekInterview can help.
Interact