Question

The WITH CHECK OPTION clause _________.a. prevents a row in a view form being updated if that would cause the row to be excluded from the view. b. protects a view by binding it to the database structure. c. prevents underlying base tables from being deleted or modified in any way that affects the view. d. prevents other users from examining the SELECT statement on which the view is based.

Answer 1

Answer:

The correct answer to the following question will be Option A.

Explanation:

For such a standards-compliant perspective, the WITH CHECK OPTION clause could be provided to prohibit additions to rows under which the select statement WHERE clause is sometimes not valid.

• This also prevents changes to rows under which the WHERE clause becomes accurate but perhaps the change will result in it not being valid.
• It helps to prevent updating of a row throughout a view process if this causes the row to still be omitted from those in the display.