70-433 · Question #208
You manage a SQL Server 2008 database that is located at your company's corporate headquarters. The database contains a table named dbo.Sales. You need to create different views of the dbo.Sales…
The correct answer is B. CREATE VIEW dbo.Region1Sales. Forces all data modification statements executed against the view to follow the criteria set within select_statement. When a row is modified through a view, the WITH CHECK OPTION makes sure the data remains visible through the view after the modification is committed.
Question
You manage a SQL Server 2008 database that is located at your company's corporate headquarters. The database contains a table named dbo.Sales. You need to create different views of the dbo.Sales table that will be used by each region to insert, update, and delete rows. Each regional office must only be able to insert, update, and delete rows for their respective region. Which view should you create for Region1?
Options
- ACREATE VIEW dbo.Region1Sales
- BCREATE VIEW dbo.Region1Sales
- CCREATE VIEW dbo.Region1Sales
- DCREATE VIEW dbo.Region1Sales
How the community answered
(56 responses)- A11% (6)
- B80% (45)
- C4% (2)
- D5% (3)
Explanation
Forces all data modification statements executed against the view to follow the criteria set within select_statement. When a row is modified through a view, the WITH CHECK OPTION makes sure the data remains visible through the view after the modification is committed.
Topics
Community Discussion
No community discussion yet for this question.