TOPICS (Click to Navigate)

Pages

Saturday, June 27, 2015

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:

1 comment:

  1. great quiz sir...helped in getting more conceptual clarity regarding the topic

    ReplyDelete