Database testing test cases example

Example 1: database testing

In my company I verify the UI response with database 
response as well as api response for database verification
1- I am checking if correct data is getting saved 
in the database after successful submit
2- Checking if data is rolled back from database 
in case of failed transactions
3-I am checking if data is committed to the database 
only when transaction is successful Example: some patients 
don't have permission to request refill it has to be thru physician.
4-I am also testing data integrity to check whether 
data stored in correct places as planned. 
Currently I use Oracle DB to manually verify database 
and I use Jdbc to integrate java by getting a 
Connection from oracle database then I create
STATEMENTS for using SQL queries and I create
RESULTSET object to store my data. I use 
Java data structures to compare results and storing them.

n my framework I have database utility class which 
handles everything related to setting up connections, 
closing connections, getting data from database and 
storing results from database into different collections arrays etc. 
So that I can easily work with it.
CONNECTION : 
Connection connection = DriverManager.getConnection(url,username, password) 
//throws SQL exception:checked exception
Statement statement = connection.CreateStatement()   
//throws SQL exception: checked exception
ResultSet resultSet = statement.executeQuery("Query")

Example 2: what to test in database testing

In Database testing, 

Testing of Data Integrity
Testing of Data Validity
Data base related performance
Testing of functions, procedure and triggers
are necessary to test.

What is Database Black Box Testing?

	Database Black Box testing involves:
	•	Data Mapping
	•	Data stored and retrieved
	•	Use of Black Box testing techniques
    such as Equivalence Partitioning 
    and Boundary Value Analysis