Three levels in database system architecture quiz

Relational model and Normalization Quiz

1. The layout of the data within the disk file system is found at the logical/conceptual level. TRUE / FALSE?

TRUE
FALSE

2. There is exactly one schema at the conceptual level for a database. TRUE/FALSE?

TRUE
FALSE

3. There is exactly one schema at the external level of a database. TRUE/FALSE?

TRUE
FALSE

4. A user’s access to the database can be limited by the schema at the external level. TRUE/FALSE?

TRUE
FALSE

5. The indexing schemes for each table is found at the external level. TRUE/FALSE?

TRUE
FALSE

6. The mappings between the levels provides for program-data independence. TRUE/FALSE?

TRUE
FALSE

7. The mapping between the external and logical levels provides various views to the users. TRUE/FALSE?

TRUE
FALSE

8. The levels in the architecture in sequence is logical-external-physical. TRUE/FALSE?

TRUE
FALSE

9. A physical schema is typically derived from the logical schema. TRUE/FALSE?

TRUE
FALSE

10. An Entity-Relationship model will map most closely to the logical schema. TRUE/FALSE?

TRUE
FALSE

Score =

Correct answers: