Agrees with SQLite's documentation
Every row agrees with SQLite's documentation for PRAGMA synchronous, and every off row passes process and fails posix: it survives a killed program, not a power cut.
delete, full loses the last commit because the journal's unlink, which is the commit, is never made durable by a directory fsync. That is the case SQLite gives as the reason EXTRA exists.