Which of the following represents the three levels of database abstraction?

Prepare for the WGU ITEC2116 D426 Data Management - Foundations Exam with interactive quizzes and comprehensive study materials. Enhance your data management skills and boost your confidence for the exam.

The three levels of database abstraction are represented by the internal, external, and conceptual levels. The internal level defines how data is physically stored in the database, focusing on data structures and file organization. The conceptual level provides a community view of the whole database; it represents the logical structure of all the data in the database, abstracting the details of the physical storage. The external level deals with how individual users view the data, allowing for different representations and user interfaces tailored to specific needs.

Option A, which refers to the physical, logical, and view level, aligns closely with the general concept of database abstraction, but it uses different terminology. The physical level corresponds to the internal level's focus on storage, the logical level relates to how data is structured conceptually, and the view level pertains to how users interact with that structure.

The terminology in option D is the recognized standard in database systems for describing abstraction. Understanding these levels is essential for database design and management, as it helps in outlining the system's architecture while allowing for effective data manipulation and retrieval based on varying user requirements.

Subscribe

Get the latest from Examzify

You can unsubscribe at any time. Read our privacy policy