-
What is database testing and what we test in database testing
Mahadevan_S
- Jun 25th, 2010
Database Testing deals with the following:-1) Testing the data in the Database for Feed/Flat File data based on the requirements by writing medium to complex queries using SELECT, INNER JOINS/OUTER JO...
Rajani
- May 8th, 2007
Hi Raghu,The answer you gave is very useful,. but can you be a bit more elaborative as of to what extent do we need to work with indexes, cursors and how to test a SP with some examples if possible!!Thanks Rajani
-
Basic Database Testing
What are the basic things you test in database testing?
Sharad_Noida
- Jun 8th, 2010
In DB Testing we validate the proper data is maintained at Backend. We also validate the Stored Procedure return the expected result. And we also perform the Data migration migration means upgrade testing on DB like upgrade DB from SQL 2005 to SQL 2008....
-
Using the Select Statement to Test data
kurtz182
- Jan 12th, 2010
SELECT column_names FROM table_nameSELECT DISTINCT column_name FROM table_nameSELECT column_name FROM table_name WHERE conditionSELECT column_name FROM table_name WHERE condition1 AND condition2SELECT...
ashishks
- Aug 28th, 2009
1. Select * from <Table Name> ---> It will select all rows from the table.2. Select <Column Name1>, <Column Name2 from <Table Name> ---> It will select all rows of col...
-
Testing for application accuracy
Testing for application accuracy using the Update and Delete statements
kurtz182
- Jan 12th, 2010
UPDATE table_name SET column1 = “new_value” WHERE conditionUPDATE table_name SET column1 = “new_value” WHERE condition1 AND condition2UPDATE table_name SET column1 = “new_value” WHERE condition1 OR condition2 DELETE FROM table_name WHERE condition
-
How can we test the correctness of data in our report with database(oracle) in our application when user do not have any knowledge about database testing or sql queries?
kurtz182
- Jan 10th, 2010
The answer to this question depends on what is meant by the term "correctness of data". A tester can often test the correctness of data type and constraints on the data by reviewing the application's technical specifications.
sriramkalli
- Oct 3rd, 2007
if the Users are using any Reporting tool like Business Objects they can test the correcness of the data with the report generated in Oracle.They dont need to know any sql if they use business objects tool .
-
How can we write testcases from Requirements..?Do the Requirements represent exact Functionality of AUT
kurtz182
- Jan 6th, 2010
I think you've got it backwards: The application under test (AUT) must represent the exact requirements. To answer your first question, the requirements are authored by someone in the b...
abhishektuppada
- Oct 15th, 2007
Well I would slightly differ from all the others, As per my knowledge the Test Cases are to be written based on the Business Requirements & not the Use Cases. Writing Test cases based on the Use C...
-
How do you test whether the database is updated as and when an information are added in the front end?Give me an example?
kurtz182
- Jan 6th, 2010
Depending on the information you are validating, you can check using simple or complex queries in the Query Editor of the SQL Management Studio There are a few things you may wish to c...
vsubraya
- Dec 17th, 2009
1. Enter the required input to complete the transaction or process so that the data or information updated into back end tables.2. Note the Transaction number, or date/time stamp during which you have...
-
Oracle / PostGRES - Database Installation & Configuration
What do mean by Database Installation & Configuration? How to install and configure? What is the role of tester for this?
ramesh7584
- Dec 22nd, 2009
As I knew the Database Installation & Configuration comes under back-end testing. When we develop a project based on client request, we should consider client environment. if they has Wi...
vemparalasuresh
- Jan 14th, 2009
I am giving this answer by considering product not base on project oriented. If suppose, product has developed in Oracle 8i environment, and new customer wants the same product in Oracle10g. As ...
-
What we normally check for in the Database Testing?
In DB testing we need to check for, 1. The field size validation 2. Check constraints. 3. Indexes are done or not (for performance related issues) 4. Stored procedures 5. The field size defined in the application is matching with that in the db.
goksn
- Sep 7th, 2009
In my experience , I have done the followign test activities as part of databaes application*Data Integrity: Whether relationship between tables (as defined while designing tables) are getting respect...
prasadmeduri
- Feb 4th, 2009
Based on the testcases written for the module, we have to cover the UI testing,Whichever modules we are testing, our main focus should be on database. 1) What are tables affected?2) From where the dat...
-
What SQL statements have you used in Database Testing?
I said I used select statements most of the times. So, the interviewer took it granted that I am unaware of insert, update and delete statements. Hence it is better to read out whole of the SQL as an answer to this question.
ashishks
- Aug 28th, 2009
The following are the most widely used Sql statments in database testing:1. Use Database2. Select3. Insert4. Update5. Delete6. Drop7. Alter8. Modify Structure9. Join(Inner and outer)10. Views
vemparalasuresh
- Jun 18th, 2008
suresh:- we can't say, insert , update, delete are sufficient. the db tester have good knoeledge on sql
-
How do you connect to the database from application?
archus
- Jun 26th, 2009
We can use connection object class to establish connection to the specified DB during runtime set ConObj=CreateObject("ADODB.Connection") ConObj.Open"Provider = Provider Name"...
Raman
- Nov 5th, 2007
You can use ADO's(ActiveX Data Objects)?for connecting database from applications.If u are new to ADO and want to learn?refer the following URLhttp://msdn2.microsoft.com/en-us/library/ms807730.aspx?
-
Is there any Freeware Tool to do Database Testing, frequently used in I.T. industry
-
Investigate Test Issues
Describe your experience using tools like SQL to query into the underlying data to investigate test issues that have arisen, requiring bulk data to be pulled out of source systems and analysed?
-
Testing of Management Information
Describe the experience you have had with "hands-on" testing, focusing particularly on where this has been testing of management information, including data migration work?
-
How a trigger can help in improving performance? How many types of triggers are there and What do they do?
chandraagi
- Oct 3rd, 2008
Use of triggers: we can do the record insertion/deletion/updation when we perform certain operation on a table or database logon and logoffImproves the security of data and tracking the changes done on a table recordsbased on the type operation triggers are Insert, Update, Delete
sulochanalak
- Jul 13th, 2007
I can answer for types of triggersTypes to triggers :?1. Database trigger: can be?executed before and after the dml commands?????? a. Row level: if we want to cahnge any row then row level triggers ar...
-
Testing using SQL queries
how to do 100% data validation (between source database and Teradata ) using QTP? Can you record and run functionality using SQL queries?
GamGom
- Jul 30th, 2008
1. The no. of arguments being passed
2. The data type of each of the arguments being passed
3. The order of the arguments being passed
4. The return value
5. The data type of the return valuesiriatwork
- Dec 27th, 2007
Hey i think you should shift this question to Testing Tools -> QTP to have better answers or rather to get answers in the first place...
-
How to test data loading in Data base testing
vemparalasuresh
- Jun 18th, 2008
suresh:-Based on situation 1) before running the script, count how many record that has, after running script, count how many records it has...
Khajam
- Jun 11th, 2007
Hi All,Data Loading represents Loading a data from a source table to target table based on business logic. This is also called as Extraction, Transformation and loading (ETL).For doing this there are ...
-
What is the difference between functions & procedures?
krishna pal singh
- Aug 28th, 2007
Function always return a values using the return statement but a procedure may or may not return values
-
How to check a trigger is fired or not,while doing Database testing?
arunatrimurti
- May 19th, 2008
Step 1 ) First we should know what the trigger is doing,this we discuss with development team or else tester should be able to know it with knowledge of tables or by reading the trigger in the databas...
Amit Bansal
- May 9th, 2007
I am using SQL SERVER. In SQL SERVER, there is a tool SQL Profiler. Using SQL Profiler you wll check a trigger is fired or not. You will also check if trigger is fired then whats the output of fired trigger.
-
DataBase Testing Interview Questions
Ans