xyz in the following MySQL statement is . . . . . . . .
CREATE VIEW xyz AS SELECT a, b FROM t;
CREATE VIEW xyz AS SELECT a, b FROM t;
A. table
B. column
C. view
D. database
Answer: Option C
Solution (By Examveda Team)
This question is about understanding the CREATE VIEW statement in MySQL.This statement is used to create a view, which is a virtual table based on the data from another table.
In the given code, xyz is the name that is being given to the view being created.
Therefore, the correct answer is Option C: view.
Related Questions on MySQL Miscellaneous
How is communication established with MySQL?
A. SQL
B. Network calls
C. A programming language like C++
D. APIs
Which type of database management system is MySQL?
A. Object-oriented
B. Hierarchical
C. Relational
D. Network
Join The Discussion