Which SQL command should a company use to create a view that limits direct access to the underlying tables?

Which SQL command should a company use to create a view that limits direct access to the underlying tables?

• A. SELECT VIEW
• B. CREATE VIEW
• C. EDIT VIEW
• D. DROP VIEW

Answer: (B)

To create a view that limits direct access to the underlying tables, the appropriate SQL command is "CREATE VIEW." This command allows you to define a virtual table, known as a view, which is based on the result of a SELECT statement.

When a view is created, it provides users with a specific window into the data without granting them direct access to the underlying tables. This encapsulation of the data can help enhance security by allowing administrators to control what data users can see and interact with. By utilizing views, you can also simplify complex queries by abstracting them into a single table-like structure, thus making it easier for end-users to retrieve data without needing to understand the complexities of the database schema.

The options related to views which are not suitable for creating a view, such as "SELECT VIEW" and "EDIT VIEW," do not exist in standard SQL syntax. "DROP VIEW" is a command used to delete an existing view and does not relate to the creation of a new view. Thus, "CREATE VIEW" is the correct command to employ for establishing a view that restricts direct table access.