Which of the following statements is incorrect?
A) A view can be created with the CREATE VIEW command.
B) Views can be modified by using the ALTER VIEW...MODIFY command.
C) A view cannot be modified; if you need to change it,you must use the CREATE OR REPLACE VIEW keywords.
D) A view cannot be given the same name as another database object in the same schema.

Question

Which of the following statements is incorrect?​
A) ​A view can be created with the CREATE VIEW command.
B) ​Views can be modified by using the ALTER VIEW...MODIFY command.
C) ​A view cannot be modified; if you need to change it,you must use the CREATE OR REPLACE VIEW keywords.
D) ​A view cannot be given the same name as another database object in the same schema.

Quizplus · Accepted Answer

The correct way to modify a view is not by using an "ALTER VIEW...MODIFY" command. Instead, to change a view, you typically use the "CREATE OR REPLACE VIEW" statement, which effectively replaces the existing view with the new definition.

Which of the Following Statements Is Incorrect?​

Which of the Following Statements Is Incorrect?