Following steps need to follow to test data loading
DCL stands for Data Control Language, it is used to control data.
The two types of DCL Commands are:
Grant: By using this command user can access privilege to database
Revoke: By using this command user cannot access the database
The statements like SELECT, INSERT, UPDATE, DELETE are used to manipulate the table, while ALTER TABLE, CREATE TABLE and DELETE TABLE are used to manage table.
Normally, the things that we check in database testing are:
Writing a testcases is like functional testing. First you have to know the functional requirement of the application. Then you have to decide the parameters for writing testcases like
Knowledge of following things is required before writing the database test cases:
RDBMS stands for Relational Database Management Systems that use SQL, and the important RDBMS that SQL uses are Sybase, Oracle, Access ,Ingres, Microsoft SQL server etc.
In a data-table, to test the multi numbers of data, data-driven test is used. By using this it can easily replace the parameters at the same time from different locations.
After execution of the test in terms of finding the defect that has been already detected and fixed. Re-execution of the same test with different input values to confirm the original defect has been successfully removed is called Re-testing or confirmation Testing.
Retesting is also called Data Driven Testing, but the difference between both is,
Retesting:- It is a manual testing process whereas application testing done with entire new set of data.
DataDriven Testing(DDT):-It is an Automation testing process where application will be tested with multiple test data.It is simple and easy than retesting where tester just sit in front of system and enter different new input valuesmanually from front-end interface, it is really boring technique.
Black box testing me testing the software for the outputs on giving particular inputs. This testing is usually performed to see if the software meets the user's requirements. There is no specific functional output expected for running this test.
The white box testing is done to check the accuracy of code and logic of the program. This testing is done by the programmer who knows the logical flow of the system.
For data load testing:
On querying the common audit log you would know, whether, a trigger is fired or not. It is in audit log where you can see the triggers fired.
Performance testing is a software testing technique to determine that how a system performance in terms of speed, sensitivity and stability under a heavy workload.
The performance testing requires expensive tools and well-trained and experienced testers for operation.
Data base testing is segmented into four different categories.
In database, a record is the set of values/fields of a specific entity.
For example; Office_Employee Record, Book Record etc.
To measure the system response, load testing is done. If the load exceeds the users pattern it is known as stress testing. Examples of load testing are downloading the set of large files, executing multiple applications on a single computer, subjecting a server to large number of e-mails and allotting many tasks to a printer one after another.
The tester will check the standard format of the stored procedures and also it checks the fields are correct like updates, joins, indexes, deletions as mentioned in the stored procedure.
Once the testing is done, QTP will generate a report. This report will show the checkpoints, system message and error that were detected while testing. The test results window will show any mismatches encountered at the checkpoints.
RDBMS stands for Relational Database Management Systems. Major RDBMS that are involved with SQL are Sybase, Oracle, Access, Ingres, Microsoft SQL server etc.
Indexes are database objects and they are created on columns. To fetch data quickly they are frequently accessed. Different types of indexes are:
Yes, the requirements should signify the exact functionality of AUT.
To do so:
To define database structure, DDL is used. DDL stands for Data Definition Language. The various DDL commands include Create, Truncate, Drop, Alter, Comment and Rename.
To write a testcases from requirements, you need to analyse the requirements thoroughly in terms of functionality. Thereafter you think about the appropriate testcases design techniques like Equivalence partitioning, Black box design, Cause effect graphing etc. for writing the testcases.Yes, the requirements represent exact functionality of AUT.
To test database procedures and triggers, input and output parameters must be known. EXEC statement can be used to run the procedure and examine the behaviour of the tables.
First of all, we need to check what all enhancements and changes happened to the SQL Server where we are planning to migrate.
Next, design the test case according to the following consideration:
In QTP using output database check point and database check, you have to select the SQL manual queries option. After selecting the manual queries option, enter the "select" queries to fetch the data in the database and then compare the expected and actual.
Testing the database manually involves checking the data at the back end and to see whether the addition of data in front end is affecting the back end or not, and same for delete, update, insert etc.
By writing scripting procedure in VBScript, we can connect to database and can test the queries and database.
Join is used to display two or more than two table and the types of joins are:
The outer join is divided again in two:
Performance testing determines the speed of the computer system performance. It includes the quantitative tests like response time measurement. The problem in performance testing is that you always need a well-trained and experienced man power also the tools you use are expensive.
QTP testing process is based on following steps:
Creating GUI (Graphical User Interface) Map files :
CMMI stands for Capability Maturity Model Integration is a process development training and evaluation model of various business processes in software engineering.
Five CMM Maturity levels for an organization are:
1) Initial: At this level, organizations don’t have any verified technique and environment, so that; usually organizations budget and schedule time go over.
2) Repeatable: At this level, organizations have basic techniques and guidelines to limit the cost and schedule time, capable in repeating the same in the next similar project.
3) Defined: At this level, all techniques are well organized and explained clear and standard form.
4) Managed: At this level, organizations are much more developed than Defined level. Here, techniques are contacted using statistical and other quantitive technique.
5) Optimizing: Organizations determinedly attempt to develop performance via modern technical progress.