How do you test database interactions in integration tests?

You use a test database or in-memory database to run queries and verify data persistence

and retrieval, ensuring the data layer works as expected without affecting production data.