Refer to the table AUTHORS and COPY_AUTHORS (Note during the creation of view the condition added is YR_PUBLISHED=2010). Supposed that the user update the YR_PUBLISHED of book OS to from 2010 to 2010 as shown below what is/are the possible output on both table and view?
The record of book OS will be removed in the COPY_AUTHORS view since its YR_PUBLIHED is updated to 2016Correct