Which level of DBMS architecture is visible to end users and describes only the part of the database relevant to a specific user group?
The external level (or view level) describes individual user views, hiding internal complexity and unrelated database segments from end users.
Which component is NOT a part of the conceptual level in the three-level database architecture?
Physical storage paths, byte layouts, and compression details belong exclusively to the internal (physical) level, whereas conceptual schemas deal strictly with logical entities, relationships, and constraints.
The capacity to modify the physical schema without requiring a change to the conceptual schema is known as:
Physical Data Independence is the ability to change physical storage structures, access paths, or disk allocation without altering the conceptual schema or application programs. Therefore, none of the first three statements is correct.
The ability to alter the conceptual schema without requiring alterations to external schemas or user view application programs is called:
Logical Data Independence enables modifications to the conceptual schema (such as adding attributes or entity types) without affecting existing external views or user queries.
What is the overall structural design and description of a database called?
The database schema is the overall blueprint or structural description specified during database design, which rarely changes, whereas an instance is the actual data populated at a specific point in time.