-
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 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 ...
-
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 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...
-
Is there any Freeware Tool to do Database Testing, frequently used in I.T. industry
-
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?
-
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
-
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...
-
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 ...
-
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...
-
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 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 .
-
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
-
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...
-
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....
-
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
-
What is your approach to do back endtesting?
How do you do back end testing?
prashantmunjewar
- Dec 16th, 2010
Cross Verify the front end changes reflection in case of Add, update and Delete operatiomn of any field.it confirms that your changes made by application saves successfully
-
Sql case statement in etl testing.
When QA will use casestatement(sql query) in etl testing or datavalidation testing , like how he will be writing that Query to test the date validation . Can you provide with example
nicel007
- Mar 4th, 2011
Suppoe there is table called SOURCE, conatins column NAME and AGE. The reuirement is that to poulate records from SOURCE to the target tale TARGET. In TARGET table contain following co...
Ravi raj
- Feb 1st, 2011
Select * from EMP where EMP_DOJ = 010110Here EMP is the Table name,EMP_DOJ is the date of joining of the Employee in EMP table.If any record/records found with DOJ as 010110,it will retrive all the re...
-
Database Migration Test Scenario
What are the test scenarios to test a database migrated from SQL Server 2005 to SQL Server 2008
nicel007
- Mar 4th, 2011
1. No of tables in both old and new should be same2. Table structures in both old and new should be same.3. If it's a Data nmigration to , then ned to compare the no of records in all the tables i...
vaibhavst
- Mar 23rd, 2010
We need to check out what was all the enhancement the SQL Server 2008 has in it. We need to design our testcase considering the following points.1. Data type used2....
-
What is way of writing testcases for database testing?
mithr17
- Nov 2nd, 2011
Ok lets do this by taking an example. Lets say you are testing the integration between database and a user registration web application. User registration web site becomes your front-end and database...
govind kumar
- Aug 9th, 2011
For writing test cases in Database first one should define the project name, then module,Bug number,objective,steps/action undertaken,expected result,actual result, then status, priority and severity.
DataBase Testing Interview Questions
Ans