Home » MCQs » DBMS MCQs » DBMS Architecture MCQs

By using three schemas, the database structure can be separated from the user's view. What's the reason behind the same?

17. By using three schemas, the database structure can be separated from the user's view. What's the reason behind the same?

1. The same data needs to be viewed differently by different users.
2. Data access needs may change over time for a particular user.
3. The same data should be available to all users based on their needs.
4. All of the above

Answer: D) All of the above

Explanation:

By using three schemas, the database structure can be separated from the user's view. The reason behind the same –

1. The same data needs to be viewed differently by different users.
2. Data access needs may change over time for a particular user.
3. The same data should be available to all users based on their needs.