An Informative Quiz On Database Management.

13 Questions | Total Attempts: 82

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

Do you know anything about database management? Would you like to try this quiz? Databases are an organized collection of information that is typically stored electronically, and there are many types of database management systems. These include hierarchical databases, network databases, object-oriented databases, graph databases, ER model databases, document databases, and NoSQL databases. If you want to put your knowledge of database management to the test, this quiz can be useful.


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
Back to Top Back to top