Question

What keywords are used to create a view in a database?

1) create view
2) create or replace view
3) modify view
4) change view

Answer 1

The keywords used to create a view in a database are CREATE VIEW, CREATE OR REPLACE VIEW, and MODIFY VIEW.

Step-by-step explanation:

The keywords used to create a view in a database are:

1. CREATE VIEW: This keyword is used to create a new view. It allows you to specify the columns and tables included in the view.
2. CREATE OR REPLACE VIEW: This keyword is used to create a new view or replace an existing view with the same name. It ensures that if a view with the same name already exists, it will be replaced.
3. MODIFY VIEW: This keyword is not used to create a view. Instead, it is used to modify the definition of an existing view, such as adding or removing columns.