Hi friends!! Can u tell me, what is meant by Database
Testing? How it can be done? What is tested in it(like any
Queries like Select and all are tested or not)?
Answers were Sorted based on User's Feedback
Answer / srini..
Testing the backend db like comparing the actual results
with expected results.
DB testing basically include the following
1)Data Validity testing
2)Data Integrity testing
3)Performance related to database.
4)Testing of procedure, truggers and functions.
For doing Data validity testing you should be good in
SQL queries, for data intigrity testing u should know abt
reerential integrity and different constraint.
For performance related things u should have idea abt the
table structure and design.
For testing procedure triggers and functions u should be
able to understand the same.
Correct me if i am wrong
Srini....
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / avinash
even i want to know the answer...please can anyone tell?
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / vijay rao
C db testing includes many other kind's. In that v r mainly concerned about ETL testing Its a process of EXTRACTING the data from source(OLTP- ONLINE TRANSACTION PROCESSING) AND TRANSFORMING it according to user requirement and LOADING the data in to target(DATA WAREHOUSE) its just similar to your functional testing only. Here u should b through with SQL, PL-SQL CONCEPTS. U have different types in db testing -> DATA FORMAT TESTING, DATA TYPE TESTING, DATA SIZE,MIGRATION,UPGRADEATION,AGAINST USER REQUIREMENT, ETL,PERFORMANCE,DATA OBJECT ETC
| Is This Answer Correct ? | 0 Yes | 0 No |
1. define Database testing ? 2. define severity and priority and types with example?
i have faced this question in one interview.kindly let me know if u know the ans . the ques is the tester have been found 20 bugs in the requirement .after dev. has been fixed 20 bugs again tester retest the bugs he found again 12 bugs dev .fixed 12 bugs keep on its going ..finally its comes zero defects now how will u checking the application stability ..
You have been given 2 projects to test, what are the key factors you consider when prioritizing you work load?
When to start and Stop Testing?
How do we estimate the number of test cases?
what is test strategy and methodology ?what is the different between them?
are you ready to work on new domain but you dont have any body to take help or suggestion (seniors).you are the initiator?how will you work in such cases?
what are the techniques(steps) to follow for writing test cases? could u explain me with brief real time example?
What is the difference between Requirement and Specification?
what is inspection,walkthrough and review
When should testing be stopped?
Expalin about PET model?