answersLogoWhite

0

How do you carry out database testing in any application?

Updated: 8/16/2019
User Avatar

Jmadhukar

Lvl 1
12y ago

Best Answer

No matter what the database or application, these are some basics (I have been a database administrator for over 10 years).

1. A test environment is necessary. You do not want to test or implement changes in a production environment. But, the test environment must be close enough to the production environment for the tests to actually let you know if the change/update will work or not harm production.

2. Benchmarks. If you are going to test a new job, benchmark each change and document each change. Change 1 thing at a time. Then you will know which change made it break or made it work.

3. Coolaboration. A DBA and application team must work together. Who made what change? When? Testing needs to be scheduled to make sure one group isn't making changes that will adversely affect what you are testing.

There is more--lots more. but this will help you get started.

User Avatar

Wiki User

12y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: How do you carry out database testing in any application?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Role of database in accounting?

The role of a database, in any application, is to provide data storage.


How create a regression suite when a defect is fixed?

To complete testing application if any modification done any modules or functionality that is called regression testing.


What is the difference between a programming language and a database?

Programming language is to develop an application where a database is a place at which we can store the data about any objects and a software which maintains this database is called DBMS.


What are testing objectives?

The objective of software testing is to check: 1. whether the application is working as expected without any errors or bugs(Functionality) 2. whether the performance of the application is as expected & meets the need.


What is the difference between Mobile Testing and Mobile Application Testing?

Mobile testing is the process of testing mobile devices and their components, such as hardware, software, and networks. It is performed to ensure that the devices meet the required quality standards and are ready for release to the market. Types of tests - Hardware testing, software testing, network testing Examples of tests - Battery life testing, performance testing, security testing Mobile application testing, on the other hand, is the process of testing mobile applications to ensure that they meet the functional and non-functional requirements of the users and the business. It is performed to identify and fix any bugs or defects in the applications before they are released to the public. Types of tests - Functional testing, non-functional testing Examples of tests - Installation testing, usability testing, performance testing I hope this information is helpful.


What software allows the user to enter retrieve and update data in an organized and efficient manner?

Any application that lets you save and retrieve a file. My best guess is that you are looking for database as an answer.


Is Norton Antivirus a Computer application?

Any file on a computer that is supposed to carry out a specified action when executed is classified as an application. So yes, Norton is a computer application.


Why you do compliance test?

In compliance testing we generally check that the application will follow the company standards or not. So we done compliance testing to check the application will follow all the company standards and will not regulate any laws of the company.Ex. company logo etc


What is the difference between an operational and a transactional database?

The difference is not so much in the database itself but with the application that uses it. An operational application does all database queries/updates in a single one-and-done manner. Transactional applications have multiple steps that are considered a single unit and may involve dozens of database operations that must all be completed before any are finalized. Otherwise, the entire transaction is rolled back.


Are there any subcategories to user acceptance testing If yes, what are those?

Yes, there are four types of user acceptance testing, as follows: Alpha and beta testing Alpha testing refers to the tests that developers conduct by themselves. It does not involve the end-users in any way. It is one of the first stages of testing an application. On the other hand, if you, as end-users, conduct a test for an unreleased application, it would be beta testing. Beta testing helps developers identify the issues that arise when actual users work with an application. Contract acceptance testing Contract acceptance testing involves testing a product and seeing if it meets the terms specified in a contract. If the application meets all those terms, contract acceptance testing is successful. On the contrary, if there are flaws in the application and it does not meet the contract requirements, the developers must work on the application and rectify those issues. If the developers fail to meet those requirements, they may face legal action. Regulation acceptance testing Regulation acceptance testing resembles contract acceptance. In the case of contract acceptance, the client sets the guidelines and requirements for the application. However, in the case of regulation acceptance, bodies like the government lay the guidelines. These guidelines ensure that the application does not compromise national security, people, etc. The developers must meet those guidelines to launch the application for public use. Failing to do so may lead to fines, a ban on the application, and other legal action. Operational acceptance testing Operational acceptance testing falls under quality management. It aims to ascertain that the application is ready to go into the production environment. It also establishes that the already existing platforms can support the application. Freelance platforms like Eiliana enable you to find excellent user testing jobs.


Are there any disadvantages to having data linked?

Yes. If your data source is deleted or moved, your spreadsheet or database application will have no data to display.


Different Software testing modules?

Black box testing:- Internal system design is not considered in this type of testing. Tests are based on requirements and functionality. White box testing:- This testing is based on knowledge of the internal logic of an application's code. Also known as Glass box Testing. Internal software and code working should be known for this type of testing. Tests are based on coverage of code statements, branches, paths, conditions. Unit testing :- Testing of individual software components or modules. Typically done by the programmer and not by testers, as it requires detailed knowledge of the internal program design and code. may require developing test driver modules or test harnesses. Incremental integration testing :- Bottom up approach for testing i.e continuous testing of an application as new functionality is added; Application functionality and modules should be independent enough to test separately. done by programmers or by testers. Integration testing: - Testing of integrated modules to verify combined functionality after integration. Modules are typically code modules, individual applications, client and server applications on a network, etc. This type of testing is especially relevant to client/server and distributed systems. Functional testing:- This type of testing ignores the internal parts and focus on the output is as per requirement or not. Black-box type testing geared to functional requirements of an application. System testing :- Entire system is tested as per the requirements. Black-box type testing that is based on overall requirements specifications, covers all combined parts of a system. End-to-end testing: - Similar to system testing, involves testing of a complete application environment in a situation that mimics real-world use, such as interacting with a database, using network communications, or interacting with other hardware, applications, or systems if appropriate. Sanity testing :- Testing to determine if a new software version is performing well enough to accept it for a major testing effort. If application is crashing for initial use then system is not stable enough for further testing and build or application is assigned to fix. Regression testing :- Testing the application as a whole for the modification in any module or functionality. Difficult to cover all the system in regression testing so typically automation tools are used for these testing types.