knvpraveena

 Profile Answers by knvpraveena 

• Jan 22nd, 2006

 

 

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)

Vijay Rentala

• Apr 11th, 2006

 

Hi Praveen,

Can you explain how these tasks are performed?

Thanks

Vijay!

Rathan

• Apr 25th, 2006

 

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

durga4578

 Profile Answers by durga4578 Questions by durga4578

• Apr 25th, 2006

 

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.

raghumb

 Profile Answers by raghumb 

• Apr 26th, 2006

 

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.

Rajesh

• May 2nd, 2006

 

praveena,

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

murthy

• Jun 19th, 2006

 

Hi

Pls send any DB testing related Doc.

Thanks

Murthy

LoniT

 Profile Answers by LoniT Questions by LoniT

• Jul 26th, 2006

 

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.

 

surendra

• Aug 28th, 2006

 

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 .

DHARNEESH

• Oct 17th, 2006

 

can u explain u'r solution with example