Consider the following statement:
ALTER VIEW v_USCity AS
SELECT Name FROM City WHERE CountryCode = ‘USA’
What would be the result if the above statement was issued and the view v_uscity did not previously exist?
A.
The view v_uscity would be created.
B.
An error would be issued that the view v_uscity does not exist.
C.
A warning would be issued that the view v_uscity does not exist, then it would create it.
D.
The query would appear to have executed, but no action on that view would occur.
Explanation:
If the view does not exist already an error is issued (as can’t replace the existing view definition)