answersLogoWhite

0

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

13y ago

What else can I help you with?

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 meaning of pass through odbc?

Pass through ODBC refers to a method of directly sending SQL queries from an application to a database using ODBC (Open Database Connectivity) without any intermediate processing or manipulation by the application. This allows the database to execute the queries more efficiently and can improve performance for complex queries.


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.


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

Mobile testing : Mobile Testing encompasses mobile application testing, mobile device testing, mobile phone testing, mobile system testing.Mobile application testing : Mobile application testing is a process by which application software developed for hand held mobile devices is tested for its functionality, usability and consistency. Mobile applications either come pre-installed or can be installed from mobile software distribution platforms. Mobile devices have witnessed a phenomenal growth in the past few years.


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.


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


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.


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.