Section 3 Oracle Acad

30 Questions | Total Attempts: 751

SettingsSettingsSettings
Please wait...
Oracle Quizzes & Trivia

.


Questions and Answers
  • 1. 
    A new system would have a mixture of both Procedural and Structural Business Rules as part of the documentation of that new system.
    • A. 

      True

    • B. 

      False

  • 2. 
    A business rule such as "We only ship goods after customers have completely paid any outstanding balances on their account" is best enforced by:
    • A. 

      We need to trust our customers and we know they will pay some day.

    • B. 

      Hiring a programmer to create additional programming code to verify no goods are shipped until the account has been settled in full.

    • C. 

      Making the payment attribute optional.

    • D. 

      Making the payment attribute null.

  • 3. 
    Data modeling is performed for the following reasons:
    • A. 

      We do not need data models; we can just start coding right away.

    • B. 

      We draw an ERD solely to please the users; once completed, The ERD is never referred to again as it serves no purpose in the real world.

    • C. 

      It helps discussions and reviews.

    • D. 

      The ERD becomes a blueprint for designing the actual system.

  • 4. 
    Data models are drawn to show users the actual Data that their new system will contain; only Data listed on the Diagram can be entered into the Database.
    • A. 

      True

    • B. 

      False

  • 5. 
    An ERD is an example of a Physical Model.
    • A. 

      True

    • B. 

      False

  • 6. 
    Attributes have Instances.
    • A. 

      True

    • B. 

      False

  • 7. 
    To identify an attribute as part of a unique identifier on an ER diagram, the # symbol goes in front of it.
    • A. 

      True

    • B. 

      False

  • 8. 
    Which symbol is used to show that a particular attribute is mandatory ?
    • A. 

      #

    • B. 

      *

    • C. 

      &

    • D. 

      O

  • 9. 
    The "Other" subtype is mandatory.
    • A. 

      True

    • B. 

      False

  • 10. 
    All instances of the supertype must be an instance of one of the subtypes.
    • A. 

      True

    • B. 

      False

  • 11. 
    Entity Boxes are drawn  with 90 degree angles, also known as Hard Boxes.
    • A. 

      True

    • B. 

      False

  • 12. 
    Which of the following is true about subtypes ?
    • A. 

      One instance of a supertype may belong to 2 subtypes.

    • B. 

      Subtypes must be mutually exclusive.

    • C. 

      Subtypes should NOT be exhaustive.

    • D. 

      Subtypes must NOT be mutually exclusive.

  • 13. 
    The candidate UID that is chosen to identify an entity is called the Primary UID; other candidate UIDs are called Secondary UIDs.
    • A. 

      No, each Entity can only have one UID, the secondary one.

    • B. 

      Yes, this is the way UID's are named.

    • C. 

      No, after UIDs are first sorted, the first one is called Primary UID, the second is the Secondary UID, etc.

    • D. 

      No, it is not possible to have more than one UID for an Entity.

  • 14. 
    All entities must be given a new artificial UID.
    • A. 

      True

    • B. 

      False

  • 15. 
    There is no limit to how many columns that can make up an entity's UID.
    • A. 

      True

    • B. 

      False

  • 16. 
    Which of the following would be a logical constraint when modeling time for a City entity ?
    • A. 

      Daily traffic patterns must be monitored to determine how many law enforcement officers are needed.

    • B. 

      Cities may change their names and/or country association if the borders of a country change.

    • C. 

      If you are doing a system for any French City, you would need security clearance.

    • D. 

      People are born in the city and people die in the city.

  • 17. 
    If Audit trail attributes are added to an entity, they must be in the entities they are auditing.
    • A. 

      True

    • B. 

      False

  • 18. 
    According to 3rd Normal Form, an attribute must be dependent on its entity's entire unique identifier.
    • A. 

      True

    • B. 

      False

  • 19. 
    A table is in 3NF if it has met all database requirements for both 1NF and 2NF and transitive dependencies are eliminated.
    • A. 

      True

    • B. 

      False

  • 20. 
    When is an Entity in 2nd Normal Form ?
    • A. 

      When all non-UID attributes are dependent upon the entire UID.

    • B. 

      When attributes with repeating or multi-values are removed.

    • C. 

      When no attributes are mutually independent and all are fully dependent on the primary key.

    • D. 

      None of the them.

  • 21. 
    Matrix Diagrams show Optionality and Cardinality of the ERDs they document.
    • A. 

      True

    • B. 

      False

  • 22. 
    Relationship Names are optional.
    • A. 

      True

    • B. 

      False

  • 23. 
    Matrix Diagrams are used to verify that all relationships have been identified for an ERD.
    • A. 

      True

    • B. 

      False

  • 24. 
    Matrix Diagrams are developed before the ERD.
    • A. 

      True

    • B. 

      False

  • 25. 
    A non-transferable relationship means the detail can be changed to point to a new master.
    • A. 

      True

    • B. 

      False