CAF-3 · Chapter 5 · Question 5 of 15
In a company's database, the HR department has a view showing employee salaries, while the Sales department has a view showing customer details but cannot see salaries. Which level of the DBMS architecture provides these customized views?
Test yourself: pick an answer
Reveal answer & explanation
Correct answer: C) External Level
Explanation
The External Level (or View Level) is the highest level of DBMS architecture. It provides customized views of the database to different users or departments based on their roles, restricting access to irrelevant data
More Types of DBMS MCQs
- Q7The IT department decides to re-index the database and move the data files to a new, faster SSD storage drive. This change does not affect…
- Q8The ability to modify the physical storage mechanisms (like changing hard drives or compressing data) without impacting the logical…
- Q9A database administrator adds a new column, "Customer_Age", to an existing table. This modification to the schema does not break the…
- Q10In an Entity-Relationship model, an attribute such as 'FullName' that can be further broken down into 'FirstName' and 'LastName' is…
- Q11A university database shows that one student can enroll in multiple courses, and each course can have multiple students enrolled in it…