← Back to systems

Vibe-Coded Database Schemas & Data Integrity

6 questions · intermediate

Vibe-coded relational database schemas generated by AI models often look functional in superficial tests but harbor severe structural risks. This quiz tests your knowledge of database referential integrity, concurrency anomalies, row-level locking with SELECT FOR UPDATE, unindexed foreign key performance impacts, cascading deletions, and safe DDL migration strategies under PostgreSQL.

0 / 6

What happens at the database engine level when an application inserts a record referencing a non-existent parent ID into a table where foreign key constraints were omitted by AI-generated schemas?

Press 1 to 4 to pick an answer