Which option restricts changes to data to conform to the select criteria of a view?
-
(a) SCHEMABINDING
-
(b) CHECK OPTION
-
(c) ANSI_NULLS
-
(d) All
CHECK OPTION is a view option that ensures any INSERT or UPDATE operation through the view must satisfy the view's defining query criteria. This prevents data modifications that would make the rows invisible to the view itself. SCHEMABINDING is specific to SQL Server and binds objects to the schema, while ANSI_NULLS controls NULL comparison behavior.
In SQL, WITH CHECK OPTION is a clause added to a view definition that ensures any INSERT or UPDATE performed through the view must satisfy the view's WHERE/select criteria — rows that would fall outside the view's filter after the change are rejected. This directly matches "restricts changes to data to conform to the select criteria of a view," making CHECK OPTION correct. SCHEMABINDING locks the view's definition to the underlying table schema to prevent structural changes, unrelated to row-level filtering. ANSI_NULLS controls how NULL comparisons behave, unrelated to view update restrictions. "All" is wrong since only CHECK OPTION serves this specific purpose.