Exercise #01 - This exercise reviews Chapter 00.

    Question 1
    Correct
    Mark 1.00 out of 1.00
    Not flaggedFlag question
    Question text
    A _ in different tables can be used to integrate the data in a database.
    Select one:
    a. table
    b. character
    c. key field
    d. record
    Feedback
    The correct answer is: key field

    Question 2
    Correct
    Mark 1.00 out of 1.00
    Not flaggedFlag question
    Question text
    Collectively, a person’s name, address, and age would be called a
    Select one:
    a. character.
    b. field.
    c. record.
    d. file.
    Feedback
    The correct answer is: record.

    Question 3
    Correct
    Mark 1.00 out of 1.00
    Not flaggedFlag question
    Question text
    If all the data in a database is not physically located in one place, it would be a(an)
    Select one:
    a. individual database.
    b. commercial database.
    c. distributed database.
    d. Web database.
    Feedback
    The correct answer is: distributed database.

    Question 4
    Correct
    Mark 1.00 out of 1.00
    Not flaggedFlag question
    Question text
    Information collected by an organization, from a variety of external and internal databases, is stored in a/ an
    Select one:
    a. company database.
    b. data warehouse.
    c. commercial database.
    d. company warehouse.
    Feedback
    The correct answer is: data warehouse.

    Question 5
    Correct
    Mark 1.00 out of 1.00
    FlaggedRemove flag
    Question text
    In _, the user must wait for the computer to scan several records one at a time, until the desired record is located.
    Select one:
    a. direct access tape
    b. sequential access storage
    c. sequential data access
    d. coordinated storage
    Feedback
    The correct answer is: sequential access storage

    Question 6
    Correct
    Mark 1.00 out of 1.00
    Not flaggedFlag question
    Question text
    Police officers, having the driver’s license plate number of a suspect, can trace his/her home address by using the
    Select one:
    a. multidimensional database.
    b. hierarchical database.
    c. Relational database.
    d. network database.
    Feedback
    The correct answer is: Relational database.

    Question 7
    Correct
    Mark 1.00 out of 1.00
    Not flaggedFlag question
    Question text
    If Mr. Smith’s bike has been sent to his new address, but the bill to his old one, it can most likely be attributed to a
    Select one:
    a. lack of data maintenance.
    b. lack of data administration.
    c. lack of data integrity.
    d. lack of data redundancy.
    Feedback
    The correct answer is: lack of data integrity.

    Question 8
    Correct
    Mark 1.00 out of 1.00
    Not flaggedFlag question
    Question text
    The data and the DBMS are stored either on the user’s hard-disk drive or on a LAN file server in these databases.
    Select one:
    a. Individual databases
    b. Company databases
    c. Commercial databases
    d. Web databases
    Feedback
    The correct answer is: Individual databases

    Question 9
    Correct
    Mark 1.00 out of 1.00
    Not flaggedFlag question
    Question text
    Which of the following is not an advantage of using a database?
    Select one:
    a. Security
    b. Integrity
    c. Reliability
    d. Sharing
    Feedback
    The correct answer is: Reliability

    Question 10
    Correct
    Mark 1.00 out of 1.00
    Not flaggedFlag question
    Question text
    Which view of data deals with how the data is actually formatted and located?
    Select one:
    a. Physical view
    b. Technical view
    c. Information view
    d. Logical view
    Feedback
    The correct answer is: Physical view

    Question 11
    Incorrect
    Mark 0.00 out of 1.00
    Not flaggedFlag question
    Question text
    Information resellers typically use a
    Select one:
    a. commercial database
    b. common database
    c. Web database
    d. individual database
    Feedback
    The correct answer is: Web database

    Question 12
    Correct
    Mark 1.00 out of 1.00
    Not flaggedFlag question
    Question text
    A credit card bill that is processed at one shot - say the end of the month - is an example of:
    Select one:
    a. consignment processing.
    b. group processing.
    c. real-time processing.
    d. batch processing.
    Feedback
    The correct answer is: batch processing.

    Question 13
    Correct
    Mark 1.00 out of 1.00
    Not flaggedFlag question
    Question text
    Data from two files could be related by combining all records with the same primary field.
    Select one:
    a. True
    b. False
    Feedback
    The correct answer is: True

    Question 14
    Incorrect
    Mark 0.00 out of 1.00
    Not flaggedFlag question
    Question text
    Some relations have no candidate key at all.
    Select one:
    a. False
    b. True
    Feedback
    The correct answer is: False

    Question 15
    Correct
    Mark 1.00 out of 1.00
    Not flaggedFlag question
    Question text
    In database systems, data redundancy results due to lack of data integrity.
    Select one:
    a. False
    b. True
    Feedback
    The correct answer is: True

    Question 16
    Correct
    Mark 1.00 out of 1.00
    Not flaggedFlag question
    Question text
    In order to create, modify, and gain access to a database, special software called the database management system is required.
    Select one:
    a. False
    b. True
    Feedback
    The correct answer is: True

    Question 17
    Correct
    Mark 1.00 out of 1.00
    Not flaggedFlag question
    Question text
    The logical view focuses on meanings and content of the data.
    Select one:
    a. False
    b. True
    Feedback
    The correct answer is: True

    Question 18
    Correct
    Mark 1.00 out of 1.00
    Not flaggedFlag question
    Question text
    The ATM works on the principle of real-time processing.
    Select one:
    a. True
    b. False
    Feedback
    The correct answer is: True

    Question 19
    Correct
    Mark 1.00 out of 1.00
    Not flaggedFlag question
    Question text
    A commercial database is generally an enormous database that an organization develops to cover particular subjects.
    Select one:
    a. True
    b. False
    Feedback
    The correct answer is: True

    Question 20
    Incorrect
    Mark 0.00 out of 1.00
    Not flaggedFlag question
    Question text
    In comparison with file systems, database systems can reduce the data redundancies.
    Select one:
    a. False
    b. True
    Feedback
    The correct answer is: True