What aspect of database schema allows access to a specific dataset without exposing all fields in the underlying tables?

• A. Stored procedure
• B. View
• C. Trigger
• D. Index

Answer: (B)

A view is a significant aspect of a database schema designed to present a specific dataset by defining a virtual table. This virtual table is created based on a query that selects certain columns and rows from one or more underlying tables. When a view is used, users can access relevant data without seeing all the columns in the original tables, ensuring that sensitive or unnecessary information remains hidden. This feature provides an effective way to simplify data access for users, enforce security by limiting data exposure, and promote data abstraction, making it easier to work with complex data structures.

Stored procedures, while functional for encapsulating logic and operations on data, do not inherently limit field exposure; they act as predefined scripts that execute a set of commands, operating on all data unless specifically programmed to restrict or filter which fields are manipulated or returned. Triggers are mechanisms that automatically execute in response to certain events in a database but do not provide a way to present a dataset to users—they operate behind the scenes. Indexes are used to improve the speed of data retrieval operations on a database but do not affect how data is presented or accessed.