Below are the some of the important database testing interview question for freshers
1. Explain the steps involved in Database Testing.
Testing triggers and functions, as well as data integrity and validation.
2. What is Database Testing.
Database testing is a process of software testing that involves data validity and data integrity testing along with testing some other triggers and functions.
3. Is database Testing a back-end process?
Yes, it is a back-end process.
4. How many types are there is DB Testing?
There are three(3) different types of database testing.
5. What are the types of Database Testing?
Structural, Functional, and Non-Functional Testing.
6. Define DDL.
DDL stands for Data Definition Language.
7. What are some DDL commands.
some of the DDL commands are CREATE, ALTER, DROP, TRUNCATE
8. Define DML.
DML stands for Data Manipulation Language.
9. Name some DML commands.
some of the DML commands are INSERT, UPDATE, LOCK
10. Define DCL.
DCL stands for Data Control Language
11. Name some DCL commands.
DCL Commands are GRANT and REVOKE.
12. Name some of the DB Testing tools.
Database Rider, Database Benchmark, DbUnit are some of the Database testing tools.
13.Explain ACID properties?
The ACID stand for Atomicity, Consistency, Isolation, and Durability.
14. Explain White box testing.
Software testing using “white box” testing involves the tester having complete knowledge of the program’s internal workings.
15. Define Black box testing.
This is a method of software testing where the testers are not made aware of the program’s internal structure.
16. What is the difference in Database testing and Front-end testing?
While front-end testing examines the functionality of forms such as registration sheets and response sheets, database testing tests back-end components like databases
18. Explain joins in the Database?
Joins are used to combine two or more tables into a single table.
19. Name some of the database security Testing tools.
Vega, Web Scarab, Social Engineer Toolkit, are some of the DB security testing tools.
20. What is key in the DB?
An attribute, or set of attributes, that is used to uniquely identify or determine a row is called a key.
21. Name the steps involved in database testing.
- Set up the environment
- Run a Test
- Observe the result
- Validate the difference between observed and expected results
- Report the observations
22. What are different keys in a Database?
Primary key, Super Key, Foreign Key, are different keys in the database.
23. Expand CRUD operations?
CRUD stands for Create, Read, Update, and Delete operations
24. What is Load Testing?
This testing method is used to ascertain how the system behaves and performs under both typical and high load conditions.
25. Explain SQL injection threat.
Malicious SQL queries are introduced into databases to retrieve the most valuable information, posing a common danger known as SQL Injection (SQLI).