Topic: Database Testing
Not finding your answer? Try searching the web for Database Testing
Answers to Common Questions
How to Test a Database
Millions of bytes of data are entered into computers by businesses, educational institutions and other organizations daily. Creating a new database is not difficult, but before you start using this data collector, you need to perform a seri... Read More »
Source: http://www.ehow.com/how_5163291_test-database.html
What is ACID test in application in database system?
The ACID model is one of the oldest and most important concepts of database theory. It sets forward four goals that every database management system must strive to achieve: atomicity, consistency, isolation and durability. No database that ... Read More »
Source: http://wiki.answers.com/Q/What_is_ACID_test_in_application_in_dat...
How do you carry out database testing in any application?
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.... Read More »
Source: http://wiki.answers.com/Q/how_do_you_carry_out_database_testing_i...
More Common Questions
Answers to Other Common Questions
simplest way 1) create a new database WEBTEST 2) Backup the production Database 3) Force restore the backup over the WEBTEST database... but do you really want all the production data? are there any legal reasons for you not doing this ... ...
Read More »
Source: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Serv...
the drop database command will do it: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_de-dz_82lh.asp DROP DATABASE Removes one or more databases from Microsoft® SQL Server™. Removing a database deletes the databa...
Read More »
Source: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Serv...
if you are using RMAN http://arjudba.blogspot.com/2008/04/use-rman-to-validate-before-and-after.html
Read More »
Source: http://www.experts-exchange.com/Q_24830739.htm
Data bas testing basically include the following. 1)Data validity testing. 2)Data Integritity testing 3)Performance related to data base. 4)Testing of Procedure,triggers and functions. for doing data validity testing you should be good in S...
Read More »
Source: http://answers.yahoo.com/question/index?qid=20080828051410AAUxZmT
That's a good question - in my experience, the answer is that some people never test them. They forget that the backup alone is not sufficient, and that you must validate it and be able to restore it. I think the actual time depends on the ...
Read More »
Source: http://www.quora.com/How-often-should-database-backups-be-tested
if there is any problem in any data page, you will get error message
Read More »
Source: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Serv...
Oops, good that MikeOM_DBA responded with a better answer. He is right, outlines can be managed with the OUTLN schema, and exported/imported by exporting that user. From the 9i docs: http://download-west.oracle.com/docs/cd/B14117_01/server....
Read More »
Source: http://www.experts-exchange.com/Database/Oracle/10.x/Q_24885411.h...
