PUJA

• Oct 21st, 2017

SELECT * FROM(SELECT DENSE_RANK() OVER (ORDER BY SAL DESC) AS RNK FROM EMPLOYEE) WHERE RNK=2;

dedeepya

• May 31st, 2017

"sas Data ds; Infile datalines; ...

Answer Question  Select Best Answer

How will you check data redundancy and data consistency using SQL queries?

Khemchand Mahajan

• Aug 26th, 2017

By using Normalisation Concept we can check data redundancy and consistency problem.

sandesh mastake

• Apr 23rd, 2013

Data redundancy means youre checking for duplication. In order to make that check, you need to determine what signifies a duplicate within the table to which you are referring. There is not a single q...

Answer Question  Select Best Answer

devsree

• Jun 9th, 2017

If data is not inserted into table then how will you test? Can you please help me?

aiza

• Sep 15th, 2015

Database testing involve testing data in backend, database testing can be done using SQL queries

Answer Question  Select Best Answer

ashish ubale

• Mar 10th, 2016

Parvathi, last query(update) will set all recno to 45. Because it does not have where condition.

neha lakhani

• Jul 20th, 2014

Employe2 mains emp2 salary < compar to emp1 salary

Answer Question  Select Best Answer

Swathi

• Sep 24th, 2015

Make a transaction to create entry employee table, where the same row already exists in department table.
Here we will get violation error.

Gaurav.khurana

 Profile Answers by Gaurav.khurana Questions by Gaurav.khurana

• Aug 25th, 2015

If you put entry in employee table, an entry is created in department table with some values. Now make a transaction such that employee table gets an entry. To verify correctly you can see the body o...

Answer Question  Select Best Answer

How will you verify that there are no social security numbers greater than or less than 9 digits long in a table called customer_info?
Write the SQL query that will identify any social security numbers that do not meet this criteria

Deepak

• Aug 13th, 2015

Use Not Equal to instead

Code
SELECT * FROM customer_info WHERE length(SSN_No)<>9

Poorva

• Aug 12th, 2015

We need to use len and not length in the syntax

Answer Question  Select Best Answer

What is Data migration and how does a tester test the Migration Data

satish tyagi

• Jun 27th, 2015

Can you explain migration testing with help of example

Sats

• Apr 8th, 2015

Database migration can be thoroughly tested by first studying the mapping document as to how the migration process is going to translate the data from source to destination and taking a few samples from the source data and then verifying the destination DB with the help of mapping doc.

Answer Question  Select Best Answer

Accy test

• Nov 28th, 2014

Well, in order to test report generating after successful execution of job,you need to perform following tests: 1. Verify the report is generated at the respective path or not. 2. Verify the format/...

Answer Question  Select Best Answer

kritee

• Sep 26th, 2014

Database testing is nothing but impact on db with respect to impact on front end users operation.

Pawan Kumar Singh

• Jun 5th, 2012

Database testing involves the tests to check the exact values which have been retrieved from the database by the web or desktop application. Data should be matched correctly as per the records are stored in the database.

Answer Question  Select Best Answer

What are the exact roles and responsibilities of a database tester?

Bina Sarmah

• Nov 15th, 2012

To conduct database testing the test engineers are following bellow issues:
1) Verification of data entered by the users through application at back end.
2) Verification of database design
3) Verifying the data integrity
4) Verification of SQL scripts.

Answer Question  Select Best Answer

How are ORACLEs AIM (Application Implementation Methodology) used in testing?

Sandhya.Kishan

 Profile Answers by Sandhya.Kishan Questions by Sandhya.Kishan

• Mar 13th, 2012

During testing oracles amis at Business System Testing which focuses on linking test requirements back to business requirements and securing project resources needed for testing. It supports utilizin...

Answer Question  Select Best Answer

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

 Profile Answers by kurtz182 Questions by 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...

Answer Question  Select Best Answer

Rajnish Jha

• Jan 12th, 2012

Join: We can display data from two or more than two table using Join.

There are 4 Types of Join-
1) Natural Join
2) Inner Join
3) Outer Join
4) Cross Join

Outer Join is further divide into two types-
1) Left outer join
2) Right Outer Join

mithr17

 Profile Answers by mithr17 Questions by mithr17

• Nov 30th, 2011

May I suggest internet?

Answer Question  Select Best Answer

How would you check the database integrity testing through SQL?

geocityco

• Nov 28th, 2011

Check database integrity Check the allocation and structural integrity of user and system tables, and indexes in the database, by running the DBCC CHECKDB Transact-SQL statement. This ensures that a...

Answer Question  Select Best Answer

( For e.g You have databases Oracle, Sql Server 2000 etc and one of the table (columns) is unique in both the databases)?

mithr17

 Profile Answers by mithr17 Questions by 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

 Profile Answers by dugulam Questions by dugulam

• Apr 10th, 2011

U can extract data from different table using the joins in sqlusing inner join         outer join etc.

Answer Question  Select Best Answer

mithr17

 Profile Answers by mithr17 Questions by 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.

Answer Question  Select Best Answer

What are the test scenarios to test a database migrated from SQL Server 2005 to SQL Server 2008

nicel007

 Profile Answers by nicel007 Questions by 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

 Profile Answers by vaibhavst Questions by 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....

Answer Question  Select Best Answer

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

 Profile Answers by nicel007 Questions by 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

 Profile Answers by Ravi raj Questions by 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...

Answer Question  Select Best Answer

How do you do back end testing?

prashantmunjewar

 Profile Answers by prashantmunjewar Questions by 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

Answer Question  Select Best Answer