Redefining a view

Unlike inserting and updating, redefining a view doesn't mean modifying the actual data a view holds. Rather, it means modifying the underlying query that makes the view. In the last video, we learned of two ways to redefine a view: (1) CREATE OR REPLACE and (2) DROP then CREATE. CREATE OR REPLACE can only be used under certain conditions.

The artist_title view needs to be appended to include a column for the label field from the labels table.

问题

Can the CREATE OR REPLACE statement be used to redefine the artist_title view?

答案选项

Yes, as long as the label column comes at the end.

No, because the new query requires a JOIN with the labels table.

No, because a new column that did not exist previously is being added to the view.

Yes, as long as the label column has the same data type as the other columns in artist_title

练习

Redefining a view

说明 1 / 共 2 个

问题

答案选项

.css-6su6fj{-webkit-flex-shrink:0;-ms-flex-negative:0;flex-shrink:0;}练习

说明 1 / 共 2 个

问题

答案选项

练习