N

Nitin Gupta • 1.72K Points
Master

Q. xyz in the following statement is ____

Code:
CREATE VIEW xyz AS SELECT a, b FROM t;
  • (A) database
  • (B) table
  • (C) column
  • (D) view
  • Correct Answer - Option(D)
  • Views: 145
  • Filed under category MySQL

Explanation by: Nitin Gupta
A ‘View’ is created in MySQL by writing the clause ‘CREATE VIEW’ followed by the view name. Then follows the list of column names of the table that are to be presented as the view.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.


Question analytics