Database Testing Interview Questions and Answers

Here you can find Database Testing Interview Questions and Answers.

Why Database Testing Interview Questions and Answers Required?

In this Database Testing Interview Questions and Answers section you can learn and practice Database Testing Interview Questions and Answers to improve your skills in order to face technical inerview by IT companies. By Practicing these interview questions, you can easily crack any Database Testing interview.

Where can I get Database Testing Interview Questions and Answers?

AllIndiaExams provides you lots Database Testing Interview Questions and Answers with proper explanation. Fully solved examples with detailed answer description. All students, freshers can download Database Testing Interview Questions and Answers as PDF files and eBooks.

How to solve these Database Testing Interview Questions and Answers?

You no need to worry, we have given lots of Database Testing Interview Questions and Answers and also we have provided lots of FAQ's to quickly answer the questions in the Database Testing technical interview.

Database Testing Interview Questions and Answers

What is data-base testing?

Data base testing is segmented into four different categories. Testing of Data Integrity Testing of Data Validity Data base related performance Testing of functions, procedure and triggers

Database Testing Interview Questions and Answers

In database testing, what do we need to check normally?

Normally, the things that we check in database testing are: Constraint Check Validation of a Field size Stored procedure Matching application field size to database Indexes for performance based issues

Database Testing Interview Questions and Answers

Explain what is data driven test?

In a data-table, to test the multi numbers of data, data-driven test is used. By using this it can easily replace the parameters at the same time from different locations.

Database Testing Interview Questions and Answers

What are joins and mention different types of joins?

Join is used to display two or more than two table and the types of joins are: Natural Join Inner Join Outer Join Cross Join The outer join is divided again in two: Left outer join Right outer join

Database Testing Interview Questions and Answers

What are indexes and mention different types of indexes?

Indexes are database objects and they are created on columns. To fetch data quickly they are frequently accessed. Different types of indexes are: B-Tree index Bitmap index Clustered index Covering index Non-unique index Unique index

Database Testing Interview Questions and Answers

While testing stored procedures what are the steps does a tester takes?

The tester will check the standard format of the stored procedures and also it checks the fields are correct like updates, joins, indexes, deletions as mentioned in the stored procedure.

Database Testing Interview Questions and Answers

How would you know for database testing, whether trigger is fired or not?

On querying the common audit log you would know, whether, a trigger is fired or not. It is in audit log where you can see the triggers fired.

Database Testing Interview Questions and Answers

In data base testing, what are the steps to test data loading?

Following steps need to follow to test data loading Source data should be known Target data should be known Compatibility of source and target should be checked In SQL Enterprise manager, run the DTS package after opening the corresponding DTS package You have to compare the columns of target and data source Number of rows of target and source should be checked After updating data in the source, check whether the changes appears in the target or not. Check NULLs and junk characters

Database Testing Interview Questions and Answers

Without using Database Checkpoints, how you test a SQL Query in QTP?

By writing scripting procedure in VBScript, we can connect to database and can test the queries and database.

Database Testing Interview Questions and Answers

Explain how to use SQL queries in QTP ?

In QTP using output database check point and database check, you have to select the SQL manual queries option. After selecting the manual queries option, enter the “select” queries to fetch the data in the database and then compare the expected and actual.