Vidyalelo
MySQL · Q394

MySQL

Programming · MySQL · question 394

Q394

A View can be used to select a subset of the table columns.

A.
True
Answer
B.
False

Answer: Option A

Solution

Answer: Option A
Solution:
This question asks about Views in MySQL.
A View is like a saved query that allows you to see only specific parts of a table, like a filtered window into your data.
So, can a View be used to pick and choose only certain columns from a table?
The answer is True.
Views are very helpful for:
- Simplifying complex queries.
- Limiting access to sensitive data.
- Making your database structure more user-friendly.
Think of a view as a custom snapshot of your data that shows you only what you need to see!