How do you test whether the database is updated as and when an information are added in the front end?Give me an example?
It depends on what level of testing we are doing.When we want to save something from front end obviously, it has to store somewhere in the database. We will need to find out the relevant tables involved in saving the records. Data Mapping from front end to the tables.Then enter the data from front end and save. Go to database, fire queries to get the same date from the back end.Reply
Can I change properties of a run time object?
No (but Yes also). We can use GetROProperty("outerText") to get the outerText of a object but there is no function like SetROProperty to change this property. But we can use WebElement().object.outerText="Something" to change the property. Reply
What steps does a tester take in testing Stored Procedures?
First the tester should to go through the requirement, as to why the particular stored procedure is written for. Then check whether all the required indexes, joins, updates, deletions are correct comparing with the tables mentions in the Stored Procedure. And also he has to ensure whether the Stored Procedure follows the standard format like comments, updated by, etc. Then check the procedure calling name, calling parameters, and expected reponses for different sets of input parameters. Then run the procedure themself with database client programs like TOAD, or mysql, or Query Analyzer. Rerun the procedure with different parameters, and check results against expected values. Finally, automate the tests with WinRunner.Reply
What are the different stages involved in Database Testing
verify field level data in the database with respect to frontend transactions :
> verify the constraint (primary key,forien key ....)
> verify the performance of the procedures
> verify the triggrs (execution of triggers)
> verify the transactions (begin,commit,rollback)Reply
How can software QA processes be implemented without stifling productivity?
When we implement software QA processes without stifling productivity, we want to implement them slowly over time. We want to use consensus to reach agreement on processes, and adjust, and experiment, as an organization grows and matures.
Productivity will be improved instead of stifled. Problem prevention will lessen the need for problem detection. Panics and burnout will decrease, and there will be improved focus, and less wasted effort. At the same time, attempts should be made to keep processes simple and efficient, minimize paperwork, promote computer based processes and automated tracking and reporting, minimize time required in meetings and promote training as part of the QA process.
However, no one, especially not the talented technical types like bureaucracy, and in the short run things may slow down a bit. A typical scenario would be that more days of planning and development will be needed, but less time will be required for late night bug fixing and calming of irate customers. Reply
How to use SQL queries in WinRunner/QTP
In QTP using output databse check point and database check point, Select SQL manual queries option and enter the "select" queris to retrive data in the database and compare the expected and actual.Reply
Where to use function or action?
Well answer depends on the scenario. If we want to use the OR feature then you have to go for Action only. If the functionality is not about any automation script i.e. a function like getting a string between to specific characters, now this is something not specific to QTP and can be done on pure VB Script, so this should be done in a function and not an action. Code specific to QTP can also be put into an function using DP. Decision of using function/action depends on what any one would be comfortable using in a given situation.Reply
What is checkpoint?
Checkpoint is basically a point in the test which validates for truthfulness of a specific things in the AUT.
There are different types of checkpoints depending on the type of data that needs to be tested in the AUT. It can be text, image/bitmap, attributes, XML etc.Reply
To learn to use WinRunner, should I sign up for a course at a nearby educational institution?
Free, or inexpensive, education is often provided on the job, by an employer, while one is getting paid to do a job that requires the use of WinRunner and many other software testing tools.
In liquid of a job, it is often a good idea to sign up for courses at nearby educational institutes. Classes, especially non-degree courses in community colleges, tend to be inexpensive. Reply
What is database testing and what we test in database testing?
Database testing is all about testing joins, views, inports and exports , testing the procedures, checking locks, indexing etc. Its not about testing the data in the database.
Usually database testing is performed by DBA. Database testing involves some in depth knowledge of the given application and requires more defined plan of approach to test the data.
Key issues include :
A) Data Integrity
B) Data Validity
C) Data Manipulation and updates
Tester must be aware of the database design concepts and implementation rules.
Data bas testing basically include the following.
A)Data validity testing.
B)Data Integritity testing
C)Performance related to data base.
D)Testing of Procedure,triggers and functions.
for doing data validity testing we should be good in SQL queries. For data integrity testing you should know about referintial integrity and different constraint. For performance related things you should have idea about the table structure and design. For testing Procedure triggers and functions we should be able to understand the same. Reply