ExamVeda
Login
Home
This question belongs to MySQL MySQL Miscellaneous
MySQL Miscellaneous
?

In the following MySQL query, "person_1" belongs to which category of table in MySQL?
CREATE VIEW person_1 AS
SELECT fname, lname, person_id FROM person;

Answer & Solution
Correct Answer: Option B
This question asks about the type of table "person_1" is in a MySQL query. Let's break it down:

The code you see is a CREATE VIEW statement. Views in MySQL are like special virtual tables.

Here's why:
* They don't store data directly: A view doesn't have its own data. It simply takes data from another table (in this case, the "person" table). * They act as a shortcut: Views let you select specific columns (fname, lname, person_id) from the "person" table and give them a new name ("person_1"). This makes accessing the data easier.

So, the answer is Option B: Virtual Tables.
Examveda
Question posted by Examveda
Community

Join the Discussion

No comments yet Be the first to discuss this question.