ACCOUNTING
End Of Chapter 11 Review (Topic 10)

End Of Chapter 11 Review (Topic 10) - Chapter 11 Databases...

Info icon This preview shows pages 1–5. Sign up to view the full content.

1 | P a g e Chapter 11: Databases TRUE/FALSE 1. The simplest model for storing data is the flat file. ANS: T PTS: 1 REF: 614 2. In a fixed-length field, when the data entered is shorter than the allocated field length, blank spaces automatically fill the field. ANS: T PTS: 1 REF: 615 3. A record contains the smallest unit of meaningful information. ANS: F PTS: 1 REF: 615 4. In the accompanying figure, the relationship shown in the bottom row is a many-to-many relationship. ANS: F PTS: 1 REF: 616 5. In the accompanying figure, the relationship shown in the top row is a one-to-many relationship. ANS: T PTS: 1 REF: 616 6. A relational database stores data in a collection of related tables. ANS: T PTS: 1 REF: 618 7. Modern database software is designed to support data dependence. ANS: F PTS: 1 REF: 624
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

2 | P a g e 8. XML documents are not optimized for many operations you would customarily associate with databases, such as fast sorts, searches, and updates. ANS: T PTS: 1 REF: 631 9. If a name field contains an entire name, it is difficult to individually manipulate the first name, last name, and middle initial. ANS: T PTS: 1 REF: 633 10. The logical data type is used for true/false or yes/no data. ANS: T PTS: 1 REF: 634 11. The hyperlink data type is used to store data that can have one of two values. ANS: F PTS: 1 REF: 635 12. Sorted tables typically produce slower queries and updates than unsorted tables. ANS: F PTS: 1 REF: 639 13. Queries within an unsorted database are slow because each record must be looked at sequentially. ANS: T PTS: 1 REF: 639 14. An index has no bearing on the physical sequence of records on disk. ANS: T PTS: 1 REF: 640 15. Database tables should be indexed by any field or fields that are commonly used as search fields. ANS: T PTS: 1 REF: 640 16. The accompanying figure shows an example of a SQL query. ANS: T PTS: 1 REF: 652 17. The average American is in less than 10 commercial databases. ANS: F PTS: 1 REF: 653
Image of page 2
3 | P a g e 18. An encrypted database can be queried quickly. ANS: F PTS: 1 REF: 654 19. User privileges delineate which fields and records a particular user is allowed to access. ANS: F PTS: 1 REF: 655 20. The United States has some of the strongest privacy regulations in the developed world. ANS: F PTS: 1 REF: 656 MODIFIED TRUE/FALSE 1. In a flat file, each row in the table is a field. _________________________ ANS: F, record PTS: 1 REF: 614 2. In the accompanying figure, the middle row shows a relationship where one album contains many songs, and one song may appear on many albums. _________________________ ANS: T PTS: 1 REF: 616 3. In database jargon, a(n) relationship is an association between data that is stored in different record types. _________________________ ANS: T PTS: 1 REF: 616 4. In a(n) relational database, relationships are specified by joining common data stored in the fields of records in different tables. _________________________ ANS: T PTS: 1 REF: 618
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

4 | P a g e 5. Poorly designed custom database software can result in data independence . _________________________ ANS: F, dependence PTS: 1 REF: 624 6. The term XML refers to software that is designed to manage data stored in a database.
Image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern