Sfsu: Isys 363 - Chapter 5

55 Questions  I  By TheSwede
Please take the quiz to rate it.

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

  
Changes are done, please start the quiz.


Questions and Answers

Removing question excerpt is a premium feature

Upgrade and get a lot more done!
  • 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.


  • 26. 
    The project 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. 

      Organizes elements into segments.

    • D. 

      Identifies the table from which the columns will be selected.


  • 27. 
    The specialized language programmers use to add and change data in the database is called :
    • A. 

      Data dictionary language.

    • B. 

      Data manipulation language.

    • C. 

      Structured Query Language.

    • D. 

      Data definition language.


  • 28. 
    The most prominent data manipulation language today is:
    • A. 

      Access.

    • B. 

      DB2

    • C. 

      SQL.

    • D. 

      Crystal Reports


  • 29. 
    The data dictionary serves as an important data management tool by:
    • A. 

      Assigning attributes to the data.

    • B. 

      Creating an inventory of data contained in the database.

    • C. 

      Presenting data as end users or business specialists would perceive them.

    • D. 

      Maintaining data in updated form.


  • 30. 
    An automated or manual file that stores information about data elements and data characteristics such as usage, physical representation, ownership, authorization, and security is the:
    • A. 

      Data dictionary.

    • B. 

      Data definition diagram

    • C. 

      Entity-relationship diagram

    • D. 

      Relationship dictionary


  • 31. 
    DBMS’s typically include report-generating tools in order to:
    • A. 

      Retrieve and display data.

    • B. 

      Display data in an easier-to-read format.

    • C. 

      Display data in graphs.

    • D. 

      Perform predictive analysis.


  • 32. 
    The type of database management approach that can handle multimedia is the:
    • A. 

      Hierarchical DBMS.

    • B. 

      Relational DBMS.

    • C. 

      Network DBMS.

    • D. 

      Object-oriented DBMS.


  • 33. 
    Which of the following database types is useful for storing Java applets as well as handling large numbers of transactions?
    • A. 

      Relational DBMS

    • B. 

      Hierarchical DBMS

    • C. 

      Object-relational DBMS

    • D. 

      OODBMS


  • 34. 
    A data warehouse is composed of:
    • A. 

      Historical data

    • B. 

      Current data

    • C. 

      Internal and external data sources.

    • D. 

      Historic and current internal data


  • 35. 
    A data mart usually can be constructed more rapidly and at lower cost than a data warehouse because:
    • A. 

      A data mart typically focuses on a single subject area or line of business.

    • B. 

      All the information is historical.

    • C. 

      A data mart uses a Web interface

    • D. 

      All of the information belongs to a single company.


  • 36. 
    Tools for consolidating, analyzing, and providing access to vast amounts of data to help users make better business decisions are known as:
    • A. 

      DSS

    • B. 

      Business intelligence

    • C. 

      OLP

    • D. 

      Data mining


  • 37. 
    The tool that enables users to view the same data in different ways using multiple dimensions is:
    • A. 

      Predictive analysis

    • B. 

      SQL

    • C. 

      OLAP

    • D. 

      Data mining


  • 38. 
    OLAP Is a tool for enabling:
    • A. 

      Users to obtain online answers to ad hoc questions in a rapid amount of time.

    • B. 

      Users to view both logical and physical views of data.

    • C. 

      Programmers to quickly diagram data relationships.

    • D. 

      Programmers to normalize data.


  • 39. 
    Data mining is a tool for allowing users to:
    • A. 

      Quickly compare transaction data gathered over many years.

    • B. 

      Find hidden relationships in data.

    • C. 

      Obtain online answers to ad hoc questions in a rapid amount of time.

    • D. 

      Summarize massive amounts of data into much smaller, traditional reports.


  • 40. 
    In terms of the data relationships found by data mining, associations refers to:
    • A. 

      Events linked over time.

    • B. 

      Patterns that describe a group to which an item belongs.

    • C. 

      Occurrences linked to a single event.

    • D. 

      Undiscovered groupings.


  • 41. 
    An alternative to using application server software for interfacing between a Web server and back-end databases is:
    • A. 

      CGI.

    • B. 

      HTML.

    • C. 

      Java.

    • D. 

      SQL.


  • 42. 
    The confusion created by __________________ makes it difficult for companies to create customer relationship management, supply chain management, or enterprise systems that integrate data from different sources.
    • A. 

      Batch processing

    • B. 

      Data redundancy

    • C. 

      Data independence

    • D. 

      Online processing


  • 43. 
    Detecting and correcting data in a database or file that are incorrect, incomplete, improperly formatted, or redundant is called:
    • A. 

      Data auditing.

    • B. 

      Defragmentation

    • C. 

      Data scrubbing

    • D. 

      Data optimization


  • 44. 
    What is the first step you should take in managing data for a firm?
    • A. 

      Identify the data needed to run the business

    • B. 

      Cleanse the data before importing it to any database

    • C. 

      Normalize the data before importing to a database

    • D. 

      Audit your data quality


  • 45. 
    Which of the following would you use to find out which Web sites with content related to database design were the most often linked to by other Web sites?
    • A. 

      Web server mining

    • B. 

      Web structure mining

    • C. 

      Web usage mining

    • D. 

      Web content mining


  • 46. 
    Businesses use ________ tools to search and analyze unstructured data sets, such as e-mails and memos.
    • A. 

      OODBMS

    • B. 

      Text mining

    • C. 

      OLAP

    • D. 

      Web mining


  • 47. 
    Which of the following statements about data warehouses is not true?
    • A. 

      They store supply data to be used across the enterprise for management analysis and decision making.

    • B. 

      They may include data from Web site transactions.

    • C. 

      Data warehouse systems provide a range of ad hoc and standardized query tools, analytical tools, and graphical reporting facilities.

    • D. 

      Data warehouse systems provide easy-to-use tools for managers to easily update data.


  • 48. 
    Which of the following is not a typical feature of DBMS?
    • A. 

      Data manipulation language

    • B. 

      Report generation tools

    • C. 

      Data dictionary

    • D. 

      Query wizard tool


  • 49. 
    Which of the following would you use to find patterns in user interaction data recorded by Web servers?
    • A. 

      Web usage mining

    • B. 

      Web server mining

    • C. 

      Web structure mining

    • D. 

      Web content mining


  • 50. 
    HP's Neoview product is a(n):
    • A. 

      Superior data cleansing and scrubbing software.

    • B. 

      OLAP tool for working with multiple data marts.

    • C. 

      Hybrid relational-OODBMS.

    • D. 

      All-inclusive data warehouse software.


  • 51. 
    MySQL is a(n):
    • A. 

      DBMS for small handheld computing devices.

    • B. 

      Popular open-source DBMS.

    • C. 

      Mainframe relational DBMS.

    • D. 

      DBMS for desktop systems.


  • 52. 
    Which of the following best illustrates the relationship between entities and attributes?
    • A. 

      The entity CUSTOMER with the attribute PRODUCT

    • B. 

      The entity PRODUCT with the attribute CUSTOMER

    • C. 

      The entity CUSTOMER with the attribute ADDRESS

    • D. 

      The entity PRODUCT with the attribute PURCHASE


  • 53. 
    Why is the inclusion of DNA from people who commit misdemeanors seen as controversial?
    • A. 

      This is a privacy violation

    • B. 

      This creates large backlogs of DNA samples to process

    • C. 

      DNA is not helpful in protecting the innocent.

    • D. 

      It exposes them to risks they would not otherwise face, such as mistakes in DNA collection and wrongful conviction


  • 54. 
    Which of the following is not a true statement about MDM?
    • A. 

      Its goal is to ensure a company is not using multiple versions of the same data.

    • B. 

      It is a multi-step process that includes business process analysis.

    • C. 

      It is a quality-of-data concept that is used to identify a company's most important data.

    • D. 

      Its goal is to create a single, authenticated master file for the company's data.


  • 55. 
    In terms of the data relationships found by data mining, sequences refers to:
    • A. 

      Events linked over time

    • B. 

      Patterns that describe a group to which an item belongs.

    • C. 

      Occurrences linked to a single event.

    • D. 

      Undiscovered groupings.


Back to top

Removing ad is a premium feature

Upgrade and get a lot more done!
Take Another Quiz
We have sent an email with your new password.