Examveda

What is xyz in the following MySQL statement?
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 asks about the meaning of "xyz" in a MySQL statement. Let's break it down:
The statement is:
CREATE VIEW xyz AS SELECT a, b FROM t;
This statement is creating a view in MySQL.
A view is like a virtual table that doesn't store data directly, but instead gets its data from another table. In this statement, "xyz" is the name of the view being created.
So the correct answer is Option C: view.

This Question Belongs to MySQL >> MySQL Miscellaneous

Join The Discussion

Related Questions on MySQL Miscellaneous