Which DML statement should a DBA use to create a view for medical staff that displays necessary patient information without full database access?

Which DML statement should a DBA use to create a view for medical staff that displays necessary patient information without full database access?

• A. SELECT VIEW
• B. CREATE TABLE
• C. CREATE VIEW
• D. ALTER VIEW

Answer: (C)

A DBA should use the "CREATE VIEW" statement to establish a view that filters and presents only the necessary patient information for medical staff. Views are virtual tables that allow users to access a subset of data from one or more tables without granting them full access to the underlying database. This is especially important in sensitive contexts such as healthcare, where patient privacy must be maintained while ensuring that authorized personnel can access the information they need.

Creating a view enables the DBA to define specific columns and rows that medical staff can query, effectively restricting access to sensitive data. This approach enhances data security while providing a way to streamline data accessibility for authorized users.

The other options, while related to SQL, are not appropriate for creating a view. "SELECT VIEW" is not a valid SQL command, "CREATE TABLE" is used for creating new tables rather than views, and "ALTER VIEW" is intended for modifying existing views, not for creating new ones. Thus, the proper choice for this scenario is to use "CREATE VIEW."