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 |
Is compatabilitytestig and port testing are same
What kind of inputs do we need from the end user to start proper testing?
what type of quetion may be asked for experienced person in manual tester of 1 year?
What type of questions will be asking for 2 years experience candidate in manual testing?
1.What is the risk factor problem related to project?
difference between test strategy,test plan and test methodology. which will create first and who will create those and is there anyone optional in that
What is your framework of current project
What is Independant Testing? When and where this type of testing will be performed?
whats the difference between test matrix and traceability matrix? tell me with some illustrations.
What is diference between Draft and Build
In a listbox of cities, if I enter B, it should display all the cities starting with B, then if i type BA, then all cities starting with BA and so on. Pls anyone give me all the positive and negative test cases for this. It is urgent. Realtime questions pls.
What is a Test Strategy and the basic test strategies? What is a Test Methodology and the basic test methodologies?