Question 1
Which of the following best describes the primary purpose of a Database Management System (DBMS)?
A DBMS provides facilities for defining database structures, storing data, querying it, controlling access, and managing transactions.
Which of the following best describes the primary purpose of a Database Management System (DBMS)?
A DBMS provides facilities for defining database structures, storing data, querying it, controlling access, and managing transactions.
Which data abstraction level describes how the data is physically stored on storage devices?
The internal (physical) level describes storage structures, file organization, indexes, and access paths.
A user's view of only the required portion of a database is described at which level?
The external level defines user-specific views and hides database details that are irrelevant to a particular user.
Which schema describes the overall logical structure of the entire database?
The conceptual schema describes entities, relationships, and constraints for the whole database without physical storage details.
Which type of data independence allows changes to the conceptual schema without requiring changes to external schemas?
Logical data independence separates external views and application programs from changes to the conceptual schema.