|
Explanation: Tables that underlie views often have constraints that limit the data that can be added to those tables. Views cannot add data to the underlying table that would violate the table’s constraints. However, you can also define a view to restrict the user’s ability to change underlying table data even further, effectively placing a special constraint for data manipulation through the view. This additional constraint says that INSERT or UPDATE statements issued against the view are cannot create rows that the view cannot subsequently select. This constraint is configured when the view is defined by adding the WITH CHECK OPTION to the CREATE VIEW statement. Incorrect Answers: 1: This view does not provide correct semantic of question task. 2: WITH READ ONLY clause is incorrect syntax in the CREATE VIEW command. 4: This view does not provide correct semantic of question task. 5: NO UPDATE clause is incorrect syntax in the CREATE VIEW command. OCP Introduction to Oracle 9i: SQL Exam Guide, Jason Couchman, p. 301-303 Chapter 7: Creating Other Database Objects in Oracle
|