verify the data in the database w.r.t frontend transactions

verify the constraint (primary key forien key ....)

verify the performance of the procedures

verify the triggrs (execution of triggers)

verify the transactions (begin commit rollback)

Hi Praveen

Can you explain how these tasks are performed?

Thanks

Vijay!

Verify wheather the fornt end values are correctly storing in the back end databse by writing the sql queries.

Verify the Constraints (Primary key foreign key Composite key)

check the performance of the Stored Procedurs

check for the execution of the Triggers

when u r testing the database u have to follow these things.

1. field level validations

2.chcek when u r enter the data in the frontend it is stored in the database or not.

3. triggers is fired perfectly or not

4.check the stored procedures for correct result.

praveena

can u give me ur mail id plz? if possible only

Hi

Pls send any DB testing related Doc.

Thanks

Murthy

Hello Praveen

whilst browsing I came upon this old posting of yours.

It would nice if you could be a little elaborate on the diff. types that you mentioned.Would be a complete answer then and could be helpful to many of us.

Thanks.

hi

i am new to this site i am very glad to all who r giving right answer and helping to freshers.If possible pls give briefy desc an database testing with one real time example .