In real time how Data base testing is done Manually? Mean to ask we write sql q

In real time how Data base testing is done Manually?
Mean to ask we write sql queries WHere, If you r using test
management tool like HP QC

Question Posted / bal_7771

2 Answers
5646 Views
ABC, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

In real time how Data base testing is done Manually? Mean to ask we write sql queries WHere, If you..

Answer / rahul

Test management tools are used to store the information how the testing is to be done, plan the testing activities and report the status of quality assurance activities. Test management tool tracks bug status, defects and projects tasks, and allows for collaboration across the team.
HP QC, Jira, IBM Rational Quality Manager, Gemini are different types of Test management tools.

Where as DB testing is done by writing queries, executing them and verifying the retrieved result. The queries are written in Query Editor depending on which DB is used. Eg. If DB is MS SQL Server then the queries will be written in editor called MS SQL Server Management Studio.

Is This Answer Correct ?

2 Yes

0 No

In real time how Data base testing is done Manually? Mean to ask we write sql queries WHere, If you..

Answer / phu

You can't use test management tool to test DB.
What's test DB?
- Test right result data.
- Optimize storing data with standards: table, relationship, index, sorting.
- Optimize queries, functions.

So you can use any tools to test. E.x: test db on SQL Server: you can DB Management tool of SQL Server to test query and measure performance of queries, functions.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer