A

Admin • 831.35K Points
Coach

Q. Which statement creates a view in MySQL?

  • (A) CREATE VIEW view_name AS SELECT ...
  • (B) CREATE TABLE view_name AS SELECT ...
  • (C) MAKE VIEW view_name FROM SELECT ...
  • (D) DEFINE VIEW view_name AS SELECT ...
  • Correct Answer - Option(A)
  • Views: 16
  • Filed under category MySQL
  • Hashtags:
Explanation by: Admin
CREATE VIEW ... AS SELECT ... is the correct syntax. CREATE TABLE ... AS SELECT creates a real table (materialized copy). MAKE VIEW and DEFINE VIEW are not valid MySQL syntax.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.