-
Database Testing
How to test Back end testing for web portal application? What all the main things must be consider?Pls give detail documents?Database testing or Backend Testing is same
Jyothi_E
- Jun 6th, 2007
Database testing and backend testing are same.In this type of testing testers need to have the knowledge on front end application and the backend database schema.When the field values are inserted thr...
lavanyamk2000
- Mar 26th, 2007
Back end testing and Database testing both are same.For testing Web portal we have to be clear with requirement and mapping documents.Do transactions through Web portal and check in backend whether the changes are reflected or not.
-
How to extract data from different datasource
( For e.g You have databases Oracle, Sql Server 2000 etc and one of the table (columns) is unique in both the databases)?
mithr17
- Nov 23rd, 2011
@ dugulam: I would have agreed with your answer if both the databases were of the same type. Meaning if both the DBs were Oracle or both were SQL Server. But, the example in the question involved diff...
dugulam
- Apr 10th, 2011
U can extract data from different table using the joins in sqlusing inner join outer join etc.
-
How to verify build instructions.Mention steps.
idreams27
- Jul 6th, 2007
Hi,Usually you will be provided with build instructions manual( which contians sequence of steps how to proceed with your build deployment) as part of Test Execution phase. This is one important point...
hanumanth mulimani
- Nov 16th, 2006
Hi, Nice question But i think it depends on the projects to projects.Best is if it has some somke test cases that will work out There may be many builds in one day, so some time u may not even have ti...
-
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 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...
-
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...
-
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 ...
-
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....
-
Data Redundancy and Data Consistency
How will you check data redundancy and data consistency using SQL queries?
-
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...
-
What steps does a tester take in testingStored Procedures?
rkaur
- Oct 11th, 2007
HiThanks for the above info...but no body has told the steps for testing stored procedures....I would appreciate a quick reply...Thnx
Venki
- Oct 25th, 2006
It is necessary to impliment error handling mechanism in stored procedures, where in every system thrown error messages will be taken care off. Its testers job to check for error handling mechanism.Sa...
-
-
Hi ,How to do negative testing for database testing ?andWhat is mean by internal quality auditing ?Please explain if u have any related document please forward it.Thanks & Best Regards.ZahirHussainCELL : 9382899885CHENNAI
idreams27
- Jul 6th, 2007
For internal Audits.Internal Quality Audit is related to the process that you are following within an organization. It may include how the projects are assessing the quality based on the process the c...
Naveen Pathak
- Mar 12th, 2007
We can do negative testing for Database:In a login window we can pass unexpected data in the user name and password.Mainly like blind SQL injection or LDAP injection.Regards:Naveen Pathak
-
This is regarding security of a Database ...How can i test the security of a DB written using Stored Procedures....1.Can I do SQl Injection attacks..If notwhat else are the methods
idreams27
- Jul 6th, 2007
Hi,Security testing can be performed in many ways. It can performed specified areas 1. Black-Box Level 2. White-Box Level and finally at 3. Data...
Naveen Pathak
- Feb 19th, 2007
Hi DearThe scurity test conduct in following areas:1) Whether user comes from proper Login Page2) Applying SQL injection and session hijecking 3)Whether Customer order file are un restrictive . 4)Email confirmation should be abaliableRegards;Naveen Pathak
-
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
-
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 Tester generally used commands
What commands do database tester generally use & whether they are given privileges to the all tables to access?
dadhichi golla
- Feb 23rd, 2012
Select ename,dept,sal from emp group by ename having dept order by sal
kurtz182
- Jan 12th, 2010
The Transact-SQL commands most often used by a tester are:USE database_name SELECT column_names FROM table_nameSELECT DISTINCT column_name FROM table_name'SELECT column_name FROM table_name W...
DataBase Testing Interview Questions
Ans