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

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
 

Poorva

• Aug 12th, 2015

We need to use len and not length in the syntax

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

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

What are the basic things you test in database testing?

Sharad_Noida

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

Answer Question  Select Best Answer