All Questions
Data Modeling easy

Why is it best practice to include `created_at` and `updated_at` timestamps on every table row?

  1. A They provide a metadata audit trail that is essential for debugging data corruption and sorting records chronologically for end-users.
  2. B They are strictly required by the ANSI SQL:2011 standard and the database engine will reject any table definitions that omit them.
  3. C They significantly accelerate full-text search operations by providing a secondary internal index for the database's natural language parser.
  4. D They prevent the accidental creation of duplicate rows by acting as a secondary, time-based unique constraint that is enforced by the disk controller.

One system design question a day, with spaced repetition so the ones you miss come back.

Get the app

Related questions