This winter holiday season, give a precious gift to your career by upgrading your skills. | Get Flat 15 - 20% OFF on All Courses | Save Today

[iqquestion id=31]

2 thoughts on “Database : Database Testing Discussion 4

  • nasir

    Validate the table, column naming conventions
    To check if the correct datatype is selected for a column
    To check the consistency in datatypes for columns common across tables
    To ensure the usage of correct field width and consistency in field width for columns common across tables
    Existence of primary key, foreign key
    Validity of constraints
    Check for presence/existence of indexes on a column
    Note the time of execution, compilation of queries
    Normalize/denormalize the tables

  • sivi ramesh

    We check for data validity – checking for the correctness of the data.
    data integrity- enforcing the business rules into database tables.

    We test database schema, stored procedures, triggers.

Leave a Reply