Skip to content

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

A DBA at an Indian e-commerce company grants a junior clerk only SELECT permission on the orders table and no rights to modify or delete rows. This arrangement best illustrates which security principle?

This illustrates the principle of least privilege. Users receive only the minimum permissions required for their duties, here read-only SELECT access, which limits accidental or malicious changes. Normalisation, redundancy and two-phase commit deal with design or transaction coordination, not access control.

  1. ALeast privilegeCorrect
  2. BNormalisation
  3. CData redundancy
  4. DTwo-phase commit

Explanation

Least privilege means giving users only the minimum access needed for their job. Granting only SELECT limits the damage from error or misuse. Normalisation is a design technique to reduce redundancy, and two-phase commit coordinates distributed transactions; neither relates to access rights.

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