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)?
- 3 Answers
- 6919 Views
- IBM, I also Faced
- E-Mail Answers
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 positive and negative testing explian with example?
11 Answers Accenture, Qutesys, Sabic,
Explain Boundary value analysis?
exact difference between smoke testing, sanity testing and unit testing
can you please tell me what is field validation and form validation in details,how is this perform
Difference between Agile process and Water Fall model
Hi guys,I have 3+ years of exp in manual testing in a bangalore based MNC company.I Like to jump in chennai.So please if u know any jobs in chennai firms please let me know in my email-id. anbarasu2k@rediffmail.com. cheers, anbarasu.
Who writes "white box " test cases ?
table X havng 3 column A,B,C....A column havng data 10 20 30.....now i wanna have 1o value in A columns all three rows
May I have to create another test case document for Adhoc Testing, Smoke Testing and all?
If you are not able to reproduce one defect then what will be the status of that defect in your defect tracking tool?
Define brain stromming?
why r u looking for change?what should be answer for this?i faced this question in an interview.suggest be gud answers.
Automation Testing 
