Test Bank Ch04 - Chapter 4 MULTIPLE CHOICE 1. What is the...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
Chapter 4 MULTIPLE CHOICE 1. What is the most popular type of database? a) hierarchical b) relational c) object-oriented d) network 2. Using a file-oriented approach to data and information, data is maintained in a) a central database. b) many interconnected files. c) many separate files. d) a decentralized database. 3. File-oriented approaches create problems for organizations because of a) multiple transaction files. b) a lack of sophisticated file maintenance software. c) multiple users. d) multiple master files which may contain redundant data. 4. Which statement is true regarding file systems? a) Transaction files are similar to ledgers in a manual AIS. b) The proliferation of master files creates problems in the consistency of specific data stored in different files. c) Transaction files are permanent. d) Individual records are never deleted in a master file. 5. A set of interrelated, centrally coordinated files is called a) a database. b) a master file. c) a transaction file. d) a multiple-records grouping (MRG). 6. The software program that creates, manipulates, and accesses the database goes by the acronym a) DBMS. b) DBP. c) OS. d) DBA. 7. The ___________ acts as an interface between the database and the various application programs
Background image of page 1

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

View Full DocumentRight Arrow Icon
a) Data warehouse b) Database administrator c) Database management system d) Database system 8. The combination of the database, the DBMS, and the application programs that access the database through the DBMS is referred to as the a) Data warehouse b) Database administrator c) Database system d) Database manager 9. The person responsible for the database is the a) Data coordinator b) Database administrator c) Database manager d) Database master 10. All of the following are benefits of database technology except: a) Data integration and sharing b) Decentralized management of data c) Minimal data redundancy d) Reporting flexibility 11. 12. Separating the logical and physical views in a database allows the programmers to concentrate on coding the application logic a) by identifying physical location and layouts of various data items. b) since they do not have to focus on the physical location and layouts of various data items. c) by consolidating all data in one database. d) by providing pointers to data items regardless of physical location. 13. A database system separates the logical and physical view of data. Such separation facilitates the development of new applications since programmers can concentrate their efforts on coding application logic. The term physical view refers to a) how a user or programmer conceptually organizes and understands the data. b) how the DBMS accesses data for an certain application program. c)
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 22

Test Bank Ch04 - Chapter 4 MULTIPLE CHOICE 1. What is the...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online