Thursday, 14 April 2016

what is Database testing - this Question is most important for real time interview point of view

Here are the Displayed Question which are most important for real time interview point of view, so read complete questions. 


1). what is Database testing?

 Testing the back end databases like comparing   the actual results   with expected results.

2). what is database testing and what we test in database testing?

Data bas testing basically include the following.
1) Data validity testing.
2) Data Integrity testing
3) Performances related to database.
4) Testing of Procedure, triggers and functions.

For doing data validity testing you should be good in SQL queries
For data integrity testing you should know about referential integrity and different constraint.
For performance related things you should have idea about the table structure and design.
For testing Procedure triggers and functions you should be able to understand the same.

3). What we normally check for in the Database Testing?

Database testing involves some in-depth 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

4). How to Test database in Manually? Explain with an example?

Observing that operations, which are operated on front-end is effected on back-end or not.
The approach is as follows:
While adding a record thru' front-end check back-end that addition of record is effected or not.
So same for delete, update...
Ex: Enter employee record in database thru' front-end and check if the record is added or not to the back-end (manually).

No comments:

Post a Comment