Here you can find Database Testing Interview Questions and Answers.
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.
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.
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.
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
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
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.
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
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
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.
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.
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
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.
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.