Kizspy Question: 33
(Choose 1 answer)
Let ParamountMovies be the VIEW defined from the Movies table:
CREATE VIEW ParamountMovies AS
SELECT title, year
FROM Movies
WHERE studioName = 'Paramount'
If you execute the statement:
DROP VIEW ParamountMovies
choose the correct statement for the Movies table.
A. Dropping the VIEW does not affect any tuples in the Movies table.
B. Dropping the VIEW affects some tuples in the Movies table that belong to the VIEW ParamountMovies.
C. Dropping the VIEW ParamountMovies that was created from the Movies table, so we can no longer query
the Movies table.
D. The Movies table will be drop out the database.
