Saturday, 27 June 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:

No comments:

Post a Comment

SQL exercises for beginners one

SQL Exercises for Beginners / Simple SQL Exercises with Answers / Solved SQL exercises / SQL solved exercises with simple conditions / So...