Does mariadb `NO_TABLE_OPTIONS`, `NO_FIELD_OPTIONS`, `NO_KEY_OPTIONS SQL_MODE` change database content?
mysqldump reads the database, but does not write to it.  It writes a text file you can look at.

You will find that those options remove certain settings relating character set, engine, auto_increment, etc.  These may make the generated SQL more compatible with some other database vendor or MySQL/MariaDB version.

The syntax I found was more like

mysqldump --compatible=no_table_options,no_field_options,no_key_options ...