Every database stores data on disk. Understanding the underlying mechanisms helps you make better choices.
Data lives in pages (typically - KB). When you query, the database reads pages from disk into memory. Write operations modify pages in memory first, then flush to disk. This page-based model explains why sequential access is faster than random access.