When performing DML operations on a view with no INSTEAD OF triggers defined, there are specific restrictions. The WITH CHECK clause impacts the ability to perform INSERT or UPDATE operations but does not affect DELETE operations. Views cannot be used to add or modify rows in an underlying table if the defining query contains the DISTINCT keyword, as DISTINCT implies a transformation that may alter the uniqueness or distribution of rows. Additionally, views cannot be used to insert rows into an underlying table if the table has columns with NOT NULL constraints lacking default values, and these columns are not referenced in the defining query of the view. These restrictions ensure that the integrity and constraints of the underlying table are maintained.