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.

Suppose you are an ad-serving company and you maintain a log of cookie data for ads you serve to the web pages for a particular vendor (say amazon). a. how can you use this data to determine which are the best ads? b. how can you use this data to determine which are the best ad formats? c. how could you records of past ads and ad clicks to determine which ads to send to a given ip address? d. how could you use this data to determine how well the technique you used in your answer to part c was working? e. how could you use this data to determine that a given ip address is used by more than one person? f. how does having this data give you a competitive advantage vis-à-vis other ad-serving companies?