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

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

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

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

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

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

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

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

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

Answer Question  Select Best Answer

kurtz182

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

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

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

reddygma

 Profile Answers by reddygma Questions by reddygma

• Dec 4th, 2008

Yes, You can use TOAD - Tool for Oracle Application Developer

rajuvo

 Profile Answers by rajuvo Questions by rajuvo

• May 18th, 2008

TOAD - Tool for Application Developers

Answer Question  Select Best Answer

babu

• Aug 15th, 2007

Show stopper means in application we are not able to go further to access it for eg. if the login screen does not allow the user to enter means, you cannot go further, so it stops the entire show.

Adith

• Jul 13th, 2007

Db_connect("session name", Connection String)db_execute_query("session name", SQL Query, Record_Number);for(i=0;i<Record_Number;i++){db_get_row("session name",i, rdata);}db_disconnect("session name");

Answer Question  Select Best Answer

ramumcato

 Profile Answers by ramumcato Questions by ramumcato

• May 29th, 2008

 Function returns some value, where as procudure doesn't return any value.

krishna pal singh

• Aug 28th, 2007

Function always return a values using the return statement but a procedure may or may not return values

Answer Question  Select Best Answer

kurtz182

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

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

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

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

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

 Profile Answers by vemparalasuresh Questions by vemparalasuresh

• Jun 18th, 2008

suresh:-             we can't say, insert , update, delete are sufficient. the db tester have good knoeledge on sql

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

DHARNEESH

• Oct 17th, 2006

Can u explain u'r solution with example

surendra

• Aug 28th, 2006

hi ,  i am new to this site,i am very glad to all who r giving right answer and helping to freshers.If possible pls give briefy desc an database testing with one real time example .

Answer Question  Select Best Answer

Mithilesh Jha

• Oct 7th, 2006

-- When we test our application, we may want to check how it performs the same operations with multiple sets of data. For Example:- Suppose we want to check how our application responds to multip...

Dhyanesh

• Sep 28th, 2006

Data Driven Testing is our simple BLACK BOX FUNCTIONAL testing to validate the functional requirement.nothing more or less than above defination. it is not paramaterization.

Answer Question  Select Best Answer

vemparalasuresh

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

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

Answer Question  Select Best Answer

Praveen Singh

• Jul 19th, 2006

Hi,You can test through manually through oracle or pl/sql by executing the queries and through automation by retrieveing the data and comparing with the input.Thanks,Praveen

saritha

• May 26th, 2006

With database chk point only in winrunner,but in manual we will go to front end using some information.will get some session names using tht session names we search in backend.if tht information is correct then wewill see query results.

Answer Question  Select Best Answer