Skip to content

CS Professional · Artificial Intelligence, Data Analytics and Cyber Security - Laws and Practice · Database Management

An insurer's DBA wants staff in the claims department to see only the claim number, claimant name and claim status from a table that also holds Aadhaar numbers and bank details, so that personal data is not exposed unnecessarily. Which database feature at the external level best achieves this?

Creating a view with only claim number, claimant name and claim status and granting access to that view is best. It works at the external schema level, hiding sensitive columns from claims staff while preserving the base table, which supports data minimisation. Indexes or file organisation changes do not restrict visibility.

  1. ACreating a view containing only the three permitted columns and granting access to the viewCorrect
  2. BDropping the Aadhaar and bank columns from the base table
  3. CCreating a secondary index on the claim number column
  4. DConverting the table to a different file organisation

Explanation

A view at the external schema level exposes selected columns while the base table remains intact for authorised users, supporting data minimisation. Dropping columns destroys needed data. An index and file organisation change are internal-level performance measures and do not restrict visibility.

Did you get it right without looking?

One question tells you little. A timed set on Database Management shows your real accuracy, how long you take and where you lose marks.

Practise Database ManagementFree diagnostic mock

More Database Management questions