Back to the 2021 paper

Unit 4 – Database Security

20212m

______________allows a system administrator to associate a function with a relation; the function returns a predicate that must be added to any query that uses the relation.

  • (i) OpenID
    (ii) Single-site system
    (iii) Security Assertion Markup Language (SAML)
    (iv) Virtual Private Database (VPD)
Worked SolutionAI Assisted

Answer: (iv) Virtual Private Database (VPD)

Explanation: VPD (Row Level Security, e.g., Oracle VPD) allows associating a function/policy with a table that appends a predicate (WHERE clause) to every query on that table for fine-grained access control. Example: function returns 'dept = USER_DEPT'. OpenID is authentication, SAML is SSO assertion language, Single-site is not relevant.

Similar questions

Free AppAndroid App

Coursify Android App

Generate AI courses, take quick quizzes between classes, and master complex engineering concepts on the go.