Thursday, 2 April 2015

DBMS Basics and ER Model Quiz 6

Entity-Relationship Modeling Quiz 1


1. According to the levels of data abstraction, the schema at the intermediate level is called
    Logical schema
    Physical schema
    Subschema
    Conceptual schema

2. It is an abstraction through which relationships are treated as higher level entities
    Generalization
    Specialization
    Aggregation
    Inheritance

3. ___________ creates the metadata.
    DML compiler
    DML pre-processor
    DDL interpreter
    Query interpreter

4. When an E-R diagram is mapped to tables, the representation of which of the followig is redundant?
    Weak entity sets
    Weak relationship sets
    Strong entity sets
    Strong relationship sets

5. In an ER diagram, Y is the dominant entity and X is a subordinate entity. Then which of the following is incorrect?
    Operationally, if X is deleted, so is Y
    Operationally, if Y is deleted, so is X
    Existence is dependent on Y
    Operationally, if X is deleted, and remains the same

6. Which of the following can be considered as one of the reasons to model data?
    Understand each user’s perspective of data
    Understand the data itself irrespective of the physical representation
    Understand the use of data across application areas
    All of the above

7. In an ER Diagram, the concept total participation is represented by which of the following components?
    Dashed lines between entity set and relationship set
    Double lines between entity set and relationship set
    Single line between entity set and relationship set
    Solid line between entity set and relationship set

8. Relations (tables) that are produced by proper application of ER model will always be in
    1NF
    2NF
    3NF
    BCNF

9. "Manager salary details are hidden from the employee". Which of the following you can relate to this statement?
    External level data hiding
    Physical level data hiding
    Conceptual level data hiding
    None of the above

10. Which of the following two files are used during the operation of the DBMS?
    Query languages and utilities
    DML and query language
    Data dictionary and transaction log
    Data dictionary and query language

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...