Database Testing Interview Questions(29)

Database testing Multi Choice Questions with answers:

1. Data base testing basically includes the following. (c)
1) Data validity testing.
2) Data Integrity testing
3) Performance related to data base.
4) Testing of Procedure, triggers and functions.


A) 1, 2 and 3
B) 2, 3 and 4
c) All of above
D) 1, 3 and 4

2. Steps in Database Testing?(A)
1. Verify whether the front end values are correctly storing in the back end database by writing the sql queries.
2. Verify the Constraints (Primary key, foreign key, and Composite key)

3. Check the performance of the Stored Procedures

4. Check for the execution of the Triggers

A. 1, 2, 3 and 4

B. 3, 1, 2, and 4

C. 4, 3, 2, and 1

D…2, 4,3 and 1

3. What is Data migration?

A .Translation of data from one format to another format

B. Translation of data from one storage device to another storage device

C.Both A & B

D. None of the above

4. What is Cross join (A)

A. A join without any condition, every row in first table joined with every row in 2nd table.

B. Result set contains all rows from the right table and matched rows from the left table

C. Result set contains only matched rows.

D.None


5. What we normally check for in the Database Testing?(4)

1) Data Integrity
2) Data validity
3) Data manipulation and updates.
4).All of the above

6. What SQL statements have you used in Database Testing? (c)

A).DDL for creating tables in database

B).DML for the manipulations like insert alters and deletes operations.

C). Both A & B

D). None

7. ADO's(ActiveX Data Objects) is used to (A)

A. connect to the database from application

B. for creating tables in database

c. To l insert alters and delete operations

D. None


8. What is the difference between functions & procedures? (B)


A. procedures returns value whereas functions doesn't

B. functions returns value whereas procedures doesn't

c. Both Functions and procedures returns value

D.All of the above

9. Blind SQL injection or LDAP injections are used to (B)
A. Positive testing in for database
B.Negative testing for database
C.Both positive and Negative testing for database
D. All types of Testing for database.

10. We can normally check for in the DB testing (d)
a) The field size validation, Check constraints, Indexes are done or not (for performance related issues
b) stored procedures
c) The field size defined in the application is matching with that in the db
d) All of the above

11.Database testing is… (d)
Checking the integrity of UI data with Database Data
Checking whether any junk data is not displaying in UI other than that stored
Checking the Data Migration
Both (a) and (c)
Both (a) and (b)


12. What sql statements can use in DB testing… (b)
DUL (Data Useful Language) and DML (Data Manipulation Language) .DDL for creating tables and database
DML for the manipulations like insert, alter, and delete operations, DDL (Data Definition Language), DCL, DTL…….
Both (a) and (b) are correct
None of these

13. The stages are in DB testing….. (d)
verify the data in the database w.r.t back end transactions, verify the performance of the commands
Verify the properties
verify the performance of the procedures
verify the triggers (execution of triggers), verify the data in the database w.r.t front end transactions, verify the performance of the procedures, verify the transactions (begin,commit,rollback)

14. In DB testing using the tools for Load testing….. (d)
Web performance, Radview
Rational suit test studio
Empirix, Mercury Interactive
All of the above

15. How to database testing manually? (b)
a) While adding a record through front-end and no need to check back-end
b) While adding a record through front-end check back-end that addition of record is effected or not.
c) Both (a) and (b)
d) None of these

16. How can use sql queries QTP..? (a)
a) Using database checkpoint then we have to write the sql statement
b) Fetch the values from the XML checkpoint then also we can have to write the sql statement
c) NO values from the database then also we can have to write the sql queries
d) None of these

17. How a trigger can help in improving performance (c)
a) Cannot be executed before and after the dml commands Statement level: it is executed even though no row is changed from the table
b) Cannot be executed before and after the dml commands Row level: if we want to change any row then row level triggers are not fired, Basic level: it is executed even though no row is changed from the table
C) Can be executed before and after the dml commands Row level: if we want to change any row then row level triggers are fired Statement level: it is executed even though no row is changed from the table
d) None of these

18. Data quality is nothing but….(b)
a) Accuracy of content, Reports
b) Completeness, timelines, structure, Accuracy of content
c) Presentation, Reports
d) None of these

19. Data quality issues are… (d)
a) Invalid values, invalid keys, missing values, orphans
b) Inconsistent null rules, inconsistent data types, inconsistent cases
c) Out of range, potential constants, potential defaults
d) All of the above

20. What do we test in database testing? (d)
Data validity & Data Integrity
Performance related to data base.
Testing of Procedure triggers and functions
All the Above.

21. What are the SQL statements used in Database Testing? (c)
DDL, DML, DCL.
Stored procedures and Triggers.
Both (a) & (b).
None of the Above.

22. What we normally check for in the Database Testing? (d)
The field size validation
Check constraints.
Indexes & Stored procedures
All the above

23. Write a query to find the second largest value in a given column of a table (a)
select max(sal) from emp_table where sal < (select max(sal) from emp_table)
select * from emp where score=(select max(score) from emp where score<(select max(score)from emp));
All the above

24. What are the different stages involved in Database Testing (a)
a) Verify the data in the database w.r.t front end transactions
Verify the constraint (primary key, foreign key ....)
Verify the performance of the procedures
Verify the triggers (execution of triggers)
Verify the transactions (begin, commit, rollback)

b) The field size validation
Check constraints.
Indexes are done or not.
Stored Procedures.
The field size defined in the application is matching with that in the db.
c) All the above.
d) None of the Above.

25. What is data driven test? (a)
a) Data driven test is used to test the multi numbers of data in a data-table, using this we can easy to replace the parameters in the same time from different locations.
b) Re-testing is also called Data Driven Test.
c) It is process of changing inputs and expected values.
d) None of the Above.

26. What is Data Migration? (c)
a) Data migration is actually the translation of data from one format to another format.
b) Data migration is actually the translation of data from one storage device to another
Storage device
c) Both (a) and (b).
d) None of the above.

27. What is Quality Auditing? (d)
Quality audit is normally conducted by QA people to find out the level to which the standards have been attained
Quality audit is normally conducted by QA people to check the quality of the Test Data Present in the Database.
This audits will help you in finding the loop holes and gaps following in the current process and helps them to refine them accordingly
Both (a) and (c).

28. How to connect to the database from application? (a)
ADO (ActiveX Data Objects).
OLDE
ODBC
All the above

29. What are the steps that must be included in testing guideline document for database testing? (d)
The tester should know which tables to look at.
The tester should know how to log on to the database (The Credentials)
Specify the conditions of pass/fail for the data in the column
All the above.