Machine-translated by Google. Questions are authored in English.
Top

Discussion

Manager's salary details are to be hidden from Employee Table. This Technique is called as

  • A.Conceptual level Datahiding
  • B.Physical level Datahiding
  • C.External level Datahiding
  • D.Logical level Datahiding

Answer: C

Hiding the manager's salary details from the Employee table is done by giving users a view that leaves that column out, which is the external level of the three level architecture, so (C) is the answer. The external (view) level describes the part of the database that each user group sees, and hiding data from a group is done there. The conceptual (logical) level describes the whole database for the community, and the physical level describes how the data are stored on disk. Neither of those is where data are hidden from particular users, so (A), (B) and (D) are wrong. The hiding is the effect of an external schema, which is a view with limited columns.

No comment is present. Be the first to comment.
Loading…

Post your comment

Please log in or register to post a comment.