πŸ“Š MySQL
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
πŸ’¬ Discuss
βœ… Correct Answer: (D) view

Explanation: 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.

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.

πŸ’¬ Discussion


πŸ“Š Question Analytics

πŸ‘οΈ
241
Total Visits
πŸ“½οΈ
4 y ago
Published
πŸŽ–οΈ
Nitin Gupta
Publisher
πŸ“ˆ
84%
Success Rate