Question: What is the valid way to create a database view in MySQL?
- `CREATE VIEW v1 SELECT * FROM t1 WHERE col1 > 10;`
- `CREATE VIEW v1 AS BEGIN SELECT * FROM t1 END;`
- `CREATE VIEW v1 BEGIN SELECT * FROM t1 END;`
- `CREATE VIEW v1 AS SELECT * FROM t1;`
Answer: The correct answer of the above question is Option D:`CREATE VIEW v1 AS SELECT * FROM t1;`