DataBase Testing - What we normally check for in the Database Testing?

GeekInterview.com > Interview Questions > Testing > DataBase Testing

DataBase Testing | Question 1 of 47

What we normally check for in the Database Testing?

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.

Total Answers and Comments: 13

Last Update: August 14, 2007

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

Sorting Options

Page 1 of 2

« First

Last »

July 12, 2005 08:23:53

Santhosh

RE: What we normally check for in the Database Testing?

In DB Testing, basically all the events like Add, Delete, Update, Modify etc...

Is this answer useful? Yes | No

July 26, 2005 01:58:44

Phani Kumar

RE: What we normally check for in the Database Testing?

How to test Stored Procedures? send me Immediately

Is this answer useful? Yes | No

July 31, 2005 06:12:42

shankar

RE: What we normally check for in the Database Testing?

what r the documents supported for integration testing?

Is this answer useful? Yes | No

August 22, 2005 07:47:59

Anand Kulkarni

RE: What we normally check for in the Database Testing?

Database testing involves some indepth knowledge of the given application and requires more defined plan of approach to test the data. Key issues include :
1) data Integrity
2) data validity
3) data manipulation and updates.

Tester must be aware of the database design concepts and implementation rules

Is this answer useful? Yes | No

August 22, 2005 08:57:38

Kishore

RE: What we normally check for in the Database Testing?

How to test Stored Procedures?

Is this answer useful? Yes | No

October 17, 2005 23:43:20

Preston

RE: What we normally check for in the Database Test...

how can i test the stored procs. anyone? thanx

Is this answer useful? Yes | No

July 04, 2006 03:36:25

anil

RE: What we normally check for in the Database Test...

Hi all,

1) Display and change stored procedure variables.

2) Stop execution at any point.

3) Alter Program logic.

Correct me if i am wrong.

Regards,

-Anil.

Is this answer useful? Yes | No

August 01, 2006 16:02:41

LoniT

Member Since: July 2006 Contribution: 13

RE: What we normally check for in the Database Test...

can you mention steps taken by a tester to test stored procedures..starting from connecting to database and so on..To make it easier to understand how to start tesing SP and Triggers.

Thanks.

Is this answer useful? Yes | No

August 17, 2006 10:29:51

Aruna Kumar G

RE: What we normally check for in the Database Test...

Normally we check whether data would be saved properly in data baseÂ and retriving data from the data base.

That will be normally check for in the Data Base

Is this answer useful? Yes | No

April 10, 2007 02:26:42

#10

dinesh.birla

RE: What we normally check for in the Database Test...

Stored procedureÂ is nothing but a collection ofÂ different queries,

this stored procedure is used to make the execution more easy instead ofÂ calling the query every time you can call the stored procedure directly by using its name.

Is this answer useful? Yes | No

Page 1 of 2

« First

Last »

Go To Top