MIS Chapter 6

  1. In a student​ database, a row that describes the top​ student, including his or her​ LastName, FirstName, and​ StudentNumber, is an example of​ a(n) ______________.

    A. group

    B. record

    C. file

    D. field

    E. attribute
    record
  2. In a student​ database, a column called LastName would be an example of​ a(n) _____________.

    A. attribute

    B. relationship

    C. file

    D. record

    E. entity
    attribute
  3. In a student​ database, a collection of related attributes such as​ LastName, FirstName, and​ Student# creates​ a(n) _______________.

    A. entity

    B. relationship

    C. file

    D. record

    E. bit
    entity
  4. A​ ________ in a database represents a single character such as a letter or number.

    A. bit

    B. megabit

    C. kilobyte

    D. file

    E. byte
    byte
  5. _______________ databases are by far the most popular type of database on the market today.

    A. Meta

    B. Flat

    C.​ Object-oriented

    D.​ Class-oriented

    E. Relational
    Relational
  6. A(n) __________ key uniquely identifies a row or record in a table.

    A. primary

    B. domestic

    C. secondary

    D. foreign

    E. initial
    primary
  7. Which of the following is a popular way to describe relationships​ (i.e., one-to-one,​ one-to-many) in a relational​ database?

    A. Data descriptor method

    B. Process model

    C.Entity-relationship diagram

    D. Task model

    E. Data flow diagram
    Entity-relationship diagram
  8. Relational databases enforce​ ______________ integrity to​ ensure, for​ instance, that a teacher​ can't be assigned to a CLASS table unless the teacher already exists in the TEACHER table.

    A. referential

    B. secondary

    C. task model

    D. ethical

    E. data flow
    referential
  9. Relational tables need to be​ ______________ to help avoid duplicate data.

    A. ethically analyzed

    B. entitled

    C. normalized

    D. relationally modeled

    E. task modeled
    normalized
  10. A​ ________ is represented by a 0 or 1.

    A. byte

    B. kilobyte

    C. megabit

    D. file

    E. bit
    bit
  11. If you need a DBMS for large commercial use on a​ mainframe, which of the following is a viable​ option?

    A. Microsoft Access

    B. Microsoft SQL Server

    C. Microsoft Excel

    D. Microsoft Explorer

    E. Microsoft Project
    Microsoft SQL Server
  12. The data​ _______________ language allows you to retrieve information from the database​ (i.e., using the​ SELECT, FROM, WHERE​ commands).

    A. creation

    B. ask

    C. manipulation

    D. definition

    E. question
    manipulation
  13. What is the most popular data manipulation language and method to​ "question" a​ database?

    A. Standard Query Process

    B. Structured Query Language

    C. Data Definition Language

    D. Simple Question Language

    E. Structured Question Language
    Structured Query Language
  14. The most common use of​ non-relational database management systems is for managing​ ________.

    A. small retail stores

    B. text data only

    C. smaller data sets

    D. extremely large data sets

    E. lists of university students
    extremely large data sets
  15. Microsoft Azure SQL is an example of a​ _________________ database.

    A. cloud

    B. network

    C. flat

    D. text

    E. local
    cloud
  16. The​ "3V's" used to characterize big data include​ volume, variety, and​ _______.
    A. vastness

    B. vigor

    C. veracity

    D. velocity

    E. value
    velocity
  17. Which statement about big data is​ FALSE?

    A. Big data can be processed with traditional techniques.

    B. Big data data sets are at least a petabyte in size.

    C. Big data has a variety of data with structured data and​ free-form text and logs.

    D. Big data can consist of multimedia files like​ graphics, audio, and video.

    E. Big data is generated rapidly.
    Big data can be processed with traditional techniques
  18. Which of the following is NOT a function of a data​ warehouse?

    A. Organize and relate data

    B. Filter data

    C. Cleanse data

    D. Catalog data

    E. Obtain data
    Filter data
  19. Which of the following involves searching for patterns and relationships among​ data?

    A. Data processing

    B. Knowledge management

    C. Data mining

    D. Data marting

    E. Data warehousing
    Data mining
  20. A method that allows complex business calculations to be performed on very large data sets in seconds is termed​ __________.

    A. big data computing

    B. disk-based computing

    C. analytic computing

    D. power computing

    E. in-memory computing
    in-memory computing
  21. Which tool enables users to view the same data in different ways using multiple​ dimensions?

    A. OLAP

    B. OLTP

    C. SQL

    D. Hadoop

    E. Clustering
    OLAP
  22. Which of the following statements about Hadoop is​ FALSE?

    A. Hadoop enables distributed parallel processing of huge amounts of data across inexpensive computers.

    B. Hadoop combines results into a smaller data set that is easier to analyze.

    C. Hadoop is an open source software framework.

    D. Hadoop breaks a big data problem down into​ sub-problems.

    E. Hadoop extracts data from multiple tables that have a relationship.
    Hadoop extracts data from multiple tables that have a relationship.
  23. The special organizational function whose responsibilities include the technical and operational aspects of managing​ data, including physical database design and​ maintenance, is called​ ________.

    A. data administration

    B. data mining

    C. information policy administration

    D. data auditing

    E. database administration
    database administration
  24. What is the first step in effectively managing data for a​ firm?

    A. Audit the data quality

    B. Back up the data

    C. Normalize the data before importing to a database

    D. Specify the information policy

    E. Cleanse the data before importing it to any database
    Specify the information policy
  25. Which of the following does NOT need to be addressed in an​ organization's information​ policy?
    A. What the relationships inside the data are

    B. Who is responsible for updating and maintaining the information

    C. Procedures and accountabilities around managing data resources

    D. Which users and organizational units can share information

    E. Where information can be distributed
    What the relationships inside the data are
Author
jbz345
ID
341182
Card Set
MIS Chapter 6
Description
MIS Chapter 6
Updated