A, B, and C are incorrect. The PURPOSE column is not required in order to create the
view—the subquery in line 2 through line 4 is a valid SELECT statement. The code on lines
9 and 10 specifies scalar subqueries and is correct. The lower PROJECT_COST value will
not prevent the INSERT from working; however, it will prevent the row from ever being seen
through the MAJOR_PROJECTS view. A SELECT statement that attempts to display this row
in the future could do so by querying the original table PROJECTS, but not the view MAJOR_
PROJECTS, which only sees rows with a PROJECT_COST greater than 10000 but certainly
allows them to be inserted through the view into the underlying table.
view—the subquery in line 2 through line 4 is a valid SELECT statement. The code on lines
9 and 10 specifies scalar subqueries and is correct. The lower PROJECT_COST value will
not prevent the INSERT from working; however, it will prevent the row from ever being seen
through the MAJOR_PROJECTS view. A SELECT statement that attempts to display this row
in the future could do so by querying the original table PROJECTS, but not the view MAJOR_
PROJECTS, which only sees rows with a PROJECT_COST greater than 10000 but certainly
allows them to be inserted through the view into the underlying table.