Concepts of Database Management, Pratt - Complete test bank - exam questions - quizzes (updated 2022)

Chapter 1: Introduction to Database Management




TRUE/FALSE



1. Redundancy wastes space because you are storing the same data in more than one place.


ANS: T PTS: 1 REF: 2



2. A spreadsheet’s data-sharing features allows multiple employees to update data in one
spreadsheet at the same time.


ANS: F PTS: 1 REF: 2-3



3. An attribute is a characteristic or property of an entity.


ANS: T PTS: 1 REF: 4



4. A relationship is an association between attributes.


ANS: F PTS: 1 REF: 5



5. A database will not only hold information about multiple types of entities, but also information
about the relationships among these multiple entities.


ANS: T PTS: 1 REF: 5



6. In a database, each entity has its own table.


ANS: T PTS: 1 REF: 5

, 7. The attributes of an entity become the rows in the table


ANS: F PTS: 1 REF: 5



8. In an entity-relationship (E-R) diagram, rectangles represent entities and lines represent
relationships between connected entities.


ANS: T PTS: 1 REF: 9



9. Programs created with Visual Basic, Java, Perl, PHP, or C++ can access the database directly,
rather than having to access it through the DBMS.


ANS: F PTS: 1 REF: 10



10. Sharing data is one advantage of database processing.


ANS: T PTS: 1 REF: 12



11. Eliminating redundancy is always possible when using a database approach.


ANS: F PTS: 1 REF: 13



12. A database cannot be password protected to prevent unauthorized users from accessing the data.


ANS: F PTS: 1 REF: 13



13. There is a greater impact of failure in a nondatabase, file-oriented system.


ANS: F PTS: 1 REF: 14

, 14. A good DBMS provides integrity constraints, which are features that let you change the structure
of the database without changing the programs that access the database.


ANS: F PTS: 1 REF: 14



15. To support all the complex functions that it provides to users, a DBMS must store data in
multiple files.


ANS: F PTS: 1 REF: 14




MULTIPLE CHOICE



1. Storing the same data in more than one place is called ____.

a. data independence c. redundancy

b. data integrity d. security


ANS: C PTS: 1 REF: 2



2. A(n) ____ is a person, place, object, event, or idea for which you want to store and process data.

a. attribute c. entity

b. DBMS d. DBA


ANS: C PTS: 1 REF: 4



3. A(n) ____ is a characteristic or property of an entity.

a. attribute c. datapoint

b. constraint d. record

, ANS: A PTS: 1 REF: 4



4. A(n) ____ is the computer counterpart to an ordinary paper file you might keep in a file cabinet
or an accounting ledger.

a. spreadsheet c. data file

b. database d. attribute


ANS: C PTS: 1 REF: 5



5. The ____ of an entity become the columns in the database table.

a. E-R diagrams c. data files

b. tuples d. attributes


ANS: D PTS: 1 REF: 5



6. An association between entities is known as a(n) ____.

a. integrity constraint c. database

b. relationship d. data file


ANS: B PTS: 1 REF: 5



7. A visual way to represent a database is with a(n) ____.

a. spreadsheet c. DBA

b. DBMS d. entity-relationship diagram


ANS: D PTS: 1 REF: 9