Vidyalelo
MySQL · Q419

MySQL

Programming · MySQL · question 419

Q419

What is xyz in the following MySQL statement? CREATE VIEW xyz AS SELECT a, b FROM t;

A.
table
B.
column
C.
view
Answer
D.
database

Answer: Option C

Solution

Answer: Option C
Solution:
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.