Implement a SQL Engine's Storage Layer: Create Database, Schema, Table and Row CRUD

Read the full interview experience this question came from →

Quick Overview

Implement the final storage layer of a SQL engine: create databases, schemas, and tables, then insert, select, update, and delete rows with every change persisted to disk. It tests on-disk layout and catalog design, row identity, crash safety and durability, and the trade-offs between log-based and page-based designs.

Implement a SQL Engine's Storage Layer: Create Database, Schema, Table and Row CRUD

Company: Fivetran

Role: Software Engineer

Category: Software Engineering Fundamentals

Difficulty: easy

Interview Round: Technical Screen

Overview: Implement the final storage layer of a SQL engine: create databases, schemas, and tables, then insert, select, update, and delete rows with every change persisted to disk. It tests on-disk layout and catalog design, row identity, crash safety and durability, and the trade-offs between log-based and page-based designs.

Read the full Fivetran Software Engineer interview experience this question came from

Fivetran logo
Fivetran
Sep 10, 2026
easySoftware EngineerTechnical ScreenSoftware Engineering Fundamentals
2
0
Loading...