A view is which of the following?

Solution (By Examveda Team)

Option A: A virtual table that can be accessed via SQL commands - This option correctly describes a view in SQL. A view is a virtual table based on the result-set of an SQL statement. It can be queried and manipulated using SQL commands, but it does not store data like a physical table.
Option B: A virtual table that cannot be accessed via SQL commands - This option is incorrect because views are specifically designed to be accessed via SQL commands.
Option C: A base table that can be accessed via SQL commands - This option describes a physical or base table, not a view.
Option D: A base table that cannot be accessed via SQL commands - This option is incorrect because base tables are accessed and manipulated using SQL commands.
Conclusion:
In SQL, a view is a virtual table that is created based on a SQL SELECT query. It can be queried like a regular table using SQL commands. Therefore, the correct answer is Option A: A virtual table that can be accessed via SQL commands.