-
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...
-
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 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
DataBase Testing Interview Questions
Ans