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 |
What is checklist? who will prepare it? i face this question in HSBC?
Can anyone tell me what should be the test cases for Security Testing?
what is v-model? explain it in detail?why we call it as v- model not an u-model?
What is Error Feeding?
How you will assure client that the number of test cases written by you is sufficient or can complete the test coverage completion criteria?
Can you explain how state transition diagram can be helpful during testing?
what are the differnt error code that comes when an error occured in web application?
I am working in a small company as a QA analyst. Suppose company has a no testing work and they give me some other works like data entry work then how to reply in that matter. Means what I have to say? whether I have to accept the work or what? Please reply.
How did you go about testing a project?
What should be done after a bug is found?
What is diff between equialence partioning and boundary value analysis
This question has been asked in my recent inerview with Adithya Birla Group.When to prepare System test plan after getting build or before getting build?