• Software and Applications (non-game)
  • Database Programming

How do you carry out database testing in any application?

User Avatar

Wiki User

βˆ™ 2011-09-12 23:48:11

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.

2011-09-12 23:48:11
This answer is:
User Avatar

Add your answer:

Earn +5 pts
Q: How do you carry out database testing in any application?
Write your answer...

Related Questions

Role of database in accounting?

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

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.

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 application allows you to enter or retrieve data?

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

What are examples of MS Access using database?

MS Access does not use databases, it is a database application. You can make a database of class members and track almost any information about each individual.

What are Software 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 concept of security testing?

It is a process to determine that an information system protects data and maintains functionality as intended. Security testing is basically a type of software testing that's done to check whether the application or the product is secured or not. It checks to see if the application is vulnerable to attacks, if anyone hack the system or login to the application without any authorization.

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 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.

What does it mean to populate a database?

Populating a database generally means adding information (data) to a database, thus filling in any pregenerated information needed. It could also mean adding the fields to a database in order to be able to fill it with information. The final common use of that term is to connect a database to a front end application in order to use the information stored in that database.

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.

When will Publix accept application?

Publix will accept an application at any time. There is a kiosk in each store for applications. If the store needs employees, they look through the applications available in the database. The application process is quick, private, and easy to use.

What is dry run regarding software testing?

In software development, static testing, also called dry run testing, is a form of software testing where the actual program or application is not used. Instead this testing method requires programmers to manually read their own code to find any errors. Static testing is a stage of White Box Testing.

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.

What is manual testing?

Manual Testing is a process carried out to find the defects. In this method the tester plays an important role as end user and verify all features of the application to ensure that the behavior of the application. The Manual Testing is very basic type of testing which helps to find the bugs in the application under test. It is preliminary testing, must be carried out prior to start automating the test cases and also needs to check the feasibility of automation testing. The Test Plan is created & followed by the tester to ensure that the comprehensiveness of testing while executing the test cases manually without using automation testing tool. It is not necessary to have knowledge of any testing tool for manual software testing. As the Software testing fundamental always says that "100% Automation is not possible" so the Manual Testing is very important. The main Goal of Manual Testing is to make sure that the application under test is defect free and software application is working as per the requirement specification document.

When is a database not a database?

When it is not in use for any reason.

Types of testing in software testing?

Well it generally depends on what approach you want to take in the testing. What we think generally as the testing is the Black box testing and white box testing. Black box testing is basically testing the software without knowing whats inside is (Code). And white box testing is opening up the interiors of the software so that we can find the errors in it. Other type might be Static and Dynamic testing. Dynamic testing is basically running the software to find out the bugs. (Taking it on the ride ! ) and static is examining it without running it. Then there are Static black box, static white box, dynamic white box testing too. Static black box being examining testing just the specification, Dynamic white box is running the software while you take a look at how the code works during the running. and static white box is taking a look at code just to see if any errors like syntax errors. There are more types like Data testing, State testing, Configuration testing, Compatibility testing, translation-Localisation testing, Documentation testing etc. There's a book by a nice man, Ron Patton, titled 'Software Testing' that'd teach you much about testing. In much cooler way. :D

Why we do regression testing?

when the tester come's to conformation that the big is fixed, then he starts Regression testing on that modified build. in this testing, the tester test's or checks whether the modified build is showing any impact on other application or not.. means whether new application or functionality is effecting other application or not.the tester checks after fixation of bug,we got any side effects in application or not... why because , during the bug fixing some parts of coding may be changed or functionality mat be manipulated.. in this case the old test cases will up-dated or completely re-written according to new feauter of application where bug fixed area.

Which is the best company to outsource performance testing process?

If you are looking to outsource software testing services, Sapizon Technologies is the perfect choice for you. They are considered one of the top software testing companies in the USA. Through the robust implementation of effective strategies, they have established themselves as a force in this domain. With their team of experienced and skilled software testers, they perform efficient performance testing to ensure the desired software application meets the market requirements. With efficient performance testing, Sapizon enables some important features of your software application are in optimal condition: Speed: The first thing every user notices in this is the speed of an app. Users want pages to load quickly without any interruptions. When this does not happen, it leads to unsatisfied customers. An application that loads quickly generates a lot of revenue giving you a competitive advantage. As the old saying goes, time is money. Sometimes, when too many users are performing the same action in an application, the networks lag, and things are slowing down. This can be very frustrating for certain users. If one or two instances like these happen, you can potentially lose the customer. Performance testing is conducted to ensure the application performs all functions at a consistent without any interruptions. Software testers ensure they test every function for speed thoroughly. Scalability: Testing for scalability is conducted on hardware, software, or database level. The performance of an application is measured by its ability to scale up or scale down the number of users interacting with the system. First, it measures the number of active users. Analyzing this data, you can determine how many more users can be added to the database at that precise moment. Along with that, it also projects how long a page will take to load in this scenario. Software testers measure the scalability of an application efficiently while conducting performance testing.

Do they make a supercharger for a 3.4 camaro at all?

We carry all major brands and I have NOT seen any on the market for your application.

What Types of Testing is Specifically Important for Web Testing?

The most important types of testing for web testing includes-:1. Functionality testing:As name suggests, This is used to check if your product is as per the specifications as you intended for it. It is basically to check the major functionality of the application which also includes-:Outgoing linksInternal linksPage Redirection (No 404 page and Broken page)2. Usability testing:Usability testing has now become a vital part of any web based project in most of the software testing companies. The Usability testing is a way to see how your application or product is easy to use or user friendly if you are testing it with real users.3. Compatibility testing:This testing ensures that our web application displays correctly across different devices. As most of the websites displayed differently in different browsers. Also, we need to test if the web application is being displayed correctly across browsers, JavaScript, AJAX and authentication is working fine. Sometimes, we may also have to check for 'Mobile Browser Compatibility' if the software testing companies also deals with Mobile testing services.4. Performance Testing:As the name suggests that it will ensure that our web application site handle extreme amount of user traffic. As the application response behavior is different with different connection speeds. It is also important to determine that how the application will recover if it will get crash occurs due to extreme user traffic.Hope this information is clear to you and get back to us in case need more information.

What is difference between database and database management system?

A database is a collection of tables which store information. A Database Management System is an application/environment for creating, modifying and administering any number of individual databases. For example: MSSQL databases are typically managed using MS SQL Server Management Studio MySQL databases are commonly managed using PHPMyAdmin

How do you download facebook mobile application for samsung duos china phone?

You can download the App from Google play or from any database website i.e Google or Yahoo.

What is an application program?

An application program (sometimes shortened to application) is any program designed to perform a specific function directly for the user or, in some cases, for another application program. Examples of application programs include word processors; database programs; Web browsers; development tools; drawing, paint, and image editing programs; and communication programs.

Role of database management system in a business info system?

DBMS has very important role in any type of web/business application. It basically manage data insertion, deletion, update and retrieval. When we login in any app, login and password is stored in database along with any activity e.g. orders, shipment etc., we access data using programming language e.g. PHP, ASP, VB, Java etc using SQL (DBMS) and display on web page. So DBMS is a software component,which comes with any database to manage the database. we can also refer as database engine or database service, which interect with programs and return the desired result.