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?

Answer

The record of book OS will be removed in the COPY_AUTHORS view since its YR_PUBLIHED is updated to 2016

This is a limited time offer, we will answer your OED for you for only ₱100 per subject!