An Informative Quiz On Database Management.

13 Questions | Total Attempts: 68

SettingsSettingsSettings
Please wait...
An Informative Quiz On Database Management.

.


Questions and Answers
  • 1. 
    What is known as a graphical technique for portraying a data base schema?
    • A. 

      Data modeling

    • B. 

      System Analysis

    • C. 

      Entity- relationship diagram

    • D. 

      DBMS

  • 2. 
    An ________ is anything about which the organization wants to collect and store information.
  • 3. 
    One of the basic type of Entities that have economic value to the organization is called a ?
    • A. 

      Agents

    • B. 

      Event

    • C. 

      Resource

    • D. 

      Diagram Variation

  • 4. 
    One of the basic types of Entities represent the people and organiations that participate in events and about whom information is desired for planning, control, and evaluation purposes. 
    • A. 

      Events

    • B. 

      Resources

    • C. 

      Agents

    • D. 

      Attribute

  • 5. 
    _______ are the various business activities about which management wants to collect information for planning or control purposes.
  • 6. 
    Every event entity must be linked to at least
    • A. 

      One resource entity, one other event entity , and at least two participating agents

    • B. 

      One event entity and at least two participating agents

    • C. 

      Two event entities and at least one participating agent

  • 7. 
    Accounts receivable would appear in an REA diagram as a example of which kind of entity?
    • A. 

      Resource

    • B. 

      Event

    • C. 

      Agent

    • D. 

      None

  • 8. 
    Which of the following is not likely to be depicted as an entity in the REA data model?
    • A. 

      Customers

    • B. 

      Invoices

    • C. 

      Sales

    • D. 

      Delivery trucks

  • 9. 
    In most cases, the relationship between agent entities and event entities is
    • A. 

      1:1

    • B. 

      1:N

    • C. 

      M:N

    • D. 

      0:N

  • 10. 
    Which of the following most accurately models the sales of low cost, mass produced items by a retail store.
    • A. 

      Sales = 0 to many inventory and inventory equals one to many sales

    • B. 

      Sale= 0 to many inventory and inventory equals 0 to many sales

    • C. 

      Sale= 1 to many inventory and inventory equals 0 to many sales

    • D. 

      Sale = o to many inventory and inventory equals 1 to many sales

  • 11. 
    Data modeling occurs during which stages of database design?
    • A. 

      System analysis and physical design

    • B. 

      System analysis and conceptual design

    • C. 

      Conceptual design and implementation and conversion

    • D. 

      Phsical design and implementation and conversion

  • 12. 
    Which of the following statements about the REA data model is true
    • A. 

      Every event must be linked to at least 2 agents

    • B. 

      Every resource must be linked to at least two agents

    • C. 

      Every agent must be linked to at least two events

Related Topics