Management Information Systems Chapter 6 Foundations of Business Intelligence: Database and Information Management Multiple Choice

1. Which of the following is not one of the main problems with a traditional file environment?

• poor security
• program-data independence
• data inconsistency
• lack of flexibility in creating ad-hoc reports

2. Program-data dependence refers to the coupling of data stored in files and software programs that use this data such that changes in programs require changes to the data.

• True
• False

3. A DBMS reduces data redundancy and inconsistency by
   • utilizing a data dictionary.
   • uncoupling program and data.
   • minimizing isolated files with repeated data.
   • enforcing referential integrity.

4. Which of the following non-digital data storage items is most similar to a database?

• cash register receipt
• library card catalog
• list of sales totals on a spreadsheet
• doctor’s office invoice

5. 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.

• data independence
• batch processing
• data redundancy
• online processing

6. Duplicate data in multiple data files is called data ________.

• Partitions
• Independence
• Repetition
• redundancy

7. DBMSs typically include report-generating tools in order to

• retrieve and display data.
• perform predictive analysis.
• display data in an easier-to-read format.
• display data in graphs.

8. A DBMS makes the

• physical database available for different analytical views.
• logical database available for different physical views.
• logical database available for different analytical views.
• physical database available for different logical views.

9. A DBMS separates the logical and physical views of data.

• True
• False

10. The logical view

• shows how data are organized and structured on the storage media.
• allows the creation of supplementary reports.
• presents data as they would be perceived by end users.
• presents an entry screen to the user.

11. NoSQL technologies are used to manage sets of data that don’t require the flexibility of tables and relations.

• True
• False

12. DBMS for midrange computers include all of the following except

• Microsoft SQL Server.
• Microsoft Access.
• DB2
• Oracle

13. A data dictionary is a language associated with a database management system that end users and programmers use to manipulate data in the database.

• True
• False

14. The type of logical database model that treats data as if they were stored in two-dimensional tables is the

• mobile DBMS.
• hierarchical DBMS.
• non-relational DBMS.
• relational DBMS.

15. Oracle Database Lite is a(n)

• mainframe relational DBMS.
• DBMS for small handheld computing devices.
• DBMS for midrange computers.
• Internet DBMS.

16. Microsoft SQL Server is a(n)

• DBMS for small handheld computing devices.
• Internet DBMS.
• DBMS for midrange computers.
• desktop relational DBMS.

17. The data dictionary serves as an important data management tool by

• maintaining data in updated form.
• creating an inventory of the data elements contained in the database.
• presenting data as end users or business specialists would perceive them.
• assigning attributes to the data.

18. 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

• data definition diagram.
• entity-relationship diagram.
• data dictionary.
• relationship dictionary.

19. The specialized language programmers use to add and change data in the database is called

• a data definition language.
• structured query language.
• a data manipulation language.
• a data access language.

20. The most prominent data manipulation language today is

• Access
• Crystal Reports.
• DB2
• SQL

Is this the question you were looking for? If so, place your order here to get started!