Which of the following commands is used to create a view in SQLite?
a) CREATE VIEW
b) ADD VIEW
c) ALTER VIEW
d) MODIFY VIEW
Answer: a) CREATE VIEW
Explanation: The CREATE VIEW statement is used to create a view in SQLite. The syntax is as follows: CREATE VIEW view_name AS SELECT column1, column2, … FROM table_name WHERE condition;
