Sfsu: Isys 363 - Chapter 5

55 Questions | Total Attempts: 214

SettingsSettingsSettings
Please wait...
University Quizzes & Trivia

Multiple choice and true/false questions from chapter 5 in Essentials of Management Information System, 9 ed. , by Laudon & Laudon.


Questions and Answers
  • 1. 
    An example of a pre-digital database is:
    • A. 

      A library’s card-catalog.

    • B. 

      A cash register receipt.

    • C. 

      A doctor’s office invoice.

    • D. 

      A list of sales totals on a spreadsheet.

  • 2. 
    The type of logical database model that treats data as if they were stored in twodimensional tables is the:
    • A. 

      OODBMS.

    • B. 

      Pre-digital DBMS.

    • C. 

      Relational DBMS.

    • D. 

      Hierarchical DBMS.

  • 3. 
    What are the relationships that the relational database is named for?
    • A. 

      Relationship between rows and columns

    • B. 

      Relationships between entities

    • C. 

      Relationships between tables

    • D. 

      Relationships between databases

  • 4. 
    A characteristic or quality describing an entity is called a(n):
    • A. 

      Field.

    • B. 

      Tuple.

    • C. 

      Key field.

    • D. 

      Attribute.

  • 5. 
    The most basic business database is comprised of:
    • A. 

      Three tables: a table for customers, a table for suppliers and parts, and a table for sales.

    • B. 

      Four tables: a table for customers, a table for suppliers, a table for parts, and a table for sales.

    • C. 

      Four tables: a table for customers, a table for employees, a table for suppliers and parts, a table for sales.

    • D. 

      Five tables: a table for customers, a table for employees, a table for suppliers, a table for parts, and a table for sales.

  • 6. 
    In a table for customers, the information about a single customer would reside in a single:
    • A. 

      Field.

    • B. 

      Row.

    • C. 

      Column.

    • D. 

      Table.

  • 7. 
    In a relational database, a record is called a(n):
    • A. 

      Tuple.

    • B. 

      Row.

    • C. 

      Entity.

    • D. 

      Field.

  • 8. 
    A field identified in a table as holding the unique identifier of the table’s records is called the:
    • A. 

      Primary key.

    • B. 

      Key field.

    • C. 

      Primary field.

    • D. 

      Unique ID.

  • 9. 
    A field identified in a record as holding the unique identifier for that record is called the:
    • A. 

      Primary key.

    • B. 

      Key field.

    • C. 

      Primary field.

    • D. 

      Unique ID.

  • 10. 
    Duplicate data in multiple data files is:
    • A. 

      Data redundancy.

    • B. 

      Data multiplication.

    • C. 

      Data independence.

    • D. 

      Typical of a relational model.

  • 11. 
    A schematic of the entire database that describes the relationships in a database is called a:
    • A. 

      Data dictionary.

    • B. 

      Intersection relationship diagram.

    • C. 

      Entity-relationship diagram.

    • D. 

      Data definition diagram.

  • 12. 
    A one-to-one relationship between two entities is symbolized in a diagram by a:
    • A. 

      Line that ends in two short marks.

    • B. 

      Line that ends in one short mark.

    • C. 

      Line that ends with a crow’s foot.

    • D. 

      Line that ends with a crow’s foot topped by a short mark.

  • 13. 
    A one-to-many relationship between two entities is symbolized in a diagram by a:
    • A. 

      Line that ends in two short marks.

    • B. 

      Line that ends in one short mark.

    • C. 

      Line that ends with a crow’s foot.

    • D. 

      Line that ends with a crow’s foot topped by a short mark.

  • 14. 
    A table that links two tables that have a many-to-many relationship is called a:
    • A. 

      Derived table.

    • B. 

      Intersection relation.

    • C. 

      Foreign table.

    • D. 

      Entity-relationship table.

  • 15. 
    The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called:
    • A. 

      Normalization.

    • B. 

      Data scrubbing.

    • C. 

      Data cleansing.

    • D. 

      Data administration.

  • 16. 
    A DBMS makes the:
    • A. 

      Physical database available for different logical views.

    • B. 

      Logical database available for different analytical views.

    • C. 

      Physical database available for different analytical views.

    • D. 

      Relational database available for different analytical views.

  • 17. 
    The logical view of a database:
    • A. 

      Shows how data are organized and structured on the storage media.

    • B. 

      Presents an entry screen to the user.

    • C. 

      Allows the creation of supplementary reports.

    • D. 

      Presents data as they would be perceived by end users.

  • 18. 
    DBMS for midrange computers include all of the following EXCEPT:
    • A. 

      DB2.

    • B. 

      Oracle.

    • C. 

      Microsoft SQL Server.

    • D. 

      Microsoft Access.

  • 19. 
    Oracle Database Lite is a(n):
    • A. 

      DBMS for small handheld computing devices.

    • B. 

      Internet DBMS.

    • C. 

      Mainframe relational DBMS.

    • D. 

      DBMS for midrange computers.

  • 20. 
    Access is a:
    • A. 

      DBMS for small handheld computing devices.

    • B. 

      Mainframe relational DBMS.

    • C. 

      DBMS for midrange computers.

    • D. 

      Desktop relational DBMS.

  • 21. 
    DB2 is a(n):
    • A. 

      DBMS for small handheld computing devices.

    • B. 

      Internet DBMS.

    • C. 

      Mainframe relational DBMS.

    • D. 

      DBMS for desktop computers.

  • 22. 
    Microsoft SQL Server is a(n):
    • A. 

      DBMS for small handheld computing devices.

    • B. 

      Internet DBMS.

    • C. 

      Desktop relational DBMS.

    • D. 

      DBMS for midrange computers.

  • 23. 
    In a relational database, the three basic operations used to develop useful sets of data are:
    • A. 

      Select, project, and where.

    • B. 

      Select, join, and where.

    • C. 

      Select, project, and join.

    • D. 

      Select, from, and join.

  • 24. 
    The select operation:
    • A. 

      Combines relational tables to provide the user with more information than is otherwise available.

    • B. 

      Creates a subset consisting of columns in a table.

    • C. 

      Identifies the table from which the columns will be selected.

    • D. 

      Creates a subset consisting of all records in the file that meets stated criteria.

  • 25. 
    The join operation:
    • A. 

      Combines relational tables to provide the user with more information than is otherwise available.

    • B. 

      Identifies the table from which the columns will be selected.

    • C. 

      Creates a subset consisting of columns in a table.

    • D. 

      Organizes elements into segments.