Database Testing questions asked by Interviewer @IGATE

Below are the few database testing questions which have been asked by interviewer when I’ve attended the  IGATE walk-in Drive.

Company: Patni Computer System ( Now it’s iGATE)

Interview Type: Walk-in Drive

Date :  18^th September 2010, Saturday

• What is Database testing & What we normally check for in the Database Testing?
• How to Test database in Manually? Explain with an example.
• What is data driven test?
• How to check a trigger is fired or not, while doing database testing?
• How to Test Database Procedures and Triggers?
• Is a “A fast database retrieval rate” a testable requirement?
• What SQL statements have you used in Database Testing?
• What are different Joins, Give example of each.
• Can you delete a parent table record if there is a child table record exits? How ?
• What is Referential Integrity.
• What is RowID
• How to know the database version
• How to execute SQL script in Query window
• How to create temporary variable
• How to print an Environment variable
• What is meant by Database user, how it is different from Login