Database Management Systems
Content
TEST BANK CHAPTER 4: DATABASE MANAGEMENT SYSTEMS
Multiple Choice 1. An organized collection of related data is a a) database. b) database management system. c) metadata file. d) data retrieval system. Ans: a Level: easy
2. hich of the follo!ing comprises programs to store" retrieve" and other!ise manage a computerized database and to provide interfaces to application programs and to non# programming users$ a) database b) database management system c) data retrieval system d) computer file Ans: b Level: easy
%. &he data's physical organization and representation on the storage medium is determined by the a) programmer. b) data administrator. c) database. d) ()M*. Ans: d Level: intermediate
TEST BANK • CHAPTER 4 40 +. ,n regard to data" users and programmers see !hich of the follo!ing types of vie!s$ a.) physical b) logical c) schema d) metadata Ans: b Level: intermediate
-. Metadata a) have no management purpose. b) are large amounts of physical data. c) are data about data. d) should not be included in a ()M*. Ans: c Level: intermediate
.. &he part of a database that holds its metadata is the a) subschema. b) data dictionary. c) logical vie!. d) transaction processor. Ans: b Level: easy
/. hich of the follo!ing in not one of the eight functions of a ()M* described in your te0t$ a) *toring and retrieving data b) Managing metadata c) Maintaining the data dictionary d) 1roviding transaction atomicity Ans: c Level: intermediate
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 41 2. hich of the follo!ing is not one of the eight functions of a ()M* described in your te0t$ a) 3nforcing business rules b) 1roviding authorization and security services c) 1roviding bac4up and recovery services d) 5educing the need for storage space Ans: d Level: intermediate
6. &he concept that a transaction cannot be split into smaller parts is a) atomicity b) autonomy c) anonymity d) augmentation Ans: a Level: easy
17. An enterprise#!ide database" containing summarized and aggregate data" designed to support business intelligence and management decision ma4ing rather than operational needs is a a) database management system b) data mining house c) data !arehouse d) data mart Ans: c Level: easy
11. A database" containing summarized and aggregate data" designed to support business intelligence and management decision ma4ing needs for a single department or division rather than the entire organization is a a) database management system. b) data mining house. c) data !arehouse. d) data mart. Ans: d Level: easy
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 42 12. hich of the follo!ing types of soft!are is designed to ease the development of dynamic eb pages$ a) transaction processing soft!are b) content management soft!are c) application development soft!are d) database development soft!are Ans: b Level: easy
1%. hich of the follo!ing statements about data elements is correct$ a) An attribute is part of a field" !hich is a group of data about similar things. b) A record contains files" also 4no!n as attributes. c) A file contains records" and each record contains fields. d) 5ecords contain files and tuples. Ans: c Level: intermediate
1+. (ata about one particular customer" such as name" address" phone number" and customer ,( !ould be found in a a) record b) attribute c) field d) attribute Ans: a Level: intermediate
1-. (ata about one of the characteristics of a record" such as a phone number" !ould be found in a a) record b) tuple c) file d) field Ans: d Level: intermediate
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 43 1.. 8o! an organization distributes data and database processing physically among the computers in a net!or4 refers to a) net!or4 architecture. b) decentralized architecture. c) distribution architecture. d) centralized architecture. Ans: c Level: intermediate
1/. hich of the follo!ing architectures involves no data sharing$ a) decentralized architecture b) centralized architecture c.) client9server architecture d) distributed architecture Ans: a Level: intermediate
12. hich of the follo!ing architectures has a single ()M* running on single computer and maintaining data centrally$ a) decentralized architecture b) client9server architecture c) centralized architecture d) distributed architecture Ans: c Level: intermediate
16. hich of the follo!ing architectures distributes both data and processing$ a) client9server architecture b) centralized architecture c) distributed architecture d) decentralized architecture Ans: c Level: intermediate
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 44 27. hich of the follo!ing statements about mi0ed architectures is most accurate$ a) ,n practice" mi0ed architectures are rarely used in companies. b) Mi0ed architectures are common" but a client9server architecture is rarely used by a company that also uses centralized architectures. c) Mi0ed architectures are common" but a decentralized architecture is rarely used by a company that also uses client9server architectures. d) A company !ith multiple sites might use a centralized architecture at one site to consolidate processing !hile using a client9server architecture at another site to distribute processing. Ans: d Level: advanced
21. (ifferent ()M*s treat the relationships among the elements of data differently. &heir approaches fall into a fe! broad categories" 4no!n as a) database architectures b) database models c) data !arehouses d) data mining services Ans: b Level: easy
22. hich database model is derived from ob:ect#oriented programming$ a) relational model b) ob:ect model c) ;ML model d) net!or4 model Ans: b Level: easy
2%. hich database model uses tables to represent files !ith ro!s called tuples and columns called attributes$ a) relational model b) ob:ect model c) hierarchical model d) net!or4 model Ans: a Level: easy
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 45 2+. hich database model builds a tighter lin4age <called a set) bet!een element of data" such as bet!een customers and sales representatives$ a) relational model b) ob:ect model c) ;ML model d) net!or4 model Ans: d Level: easy
2-. hich database model is a precursor to the net!or4 model" as a net!or4 model !ith additional restrictions$ a) relational model b) ob:ect model c) hierarchical model d) net!or4 model Ans: c Level: easy
2.. hich of the follo!ing statements regarding managing data is correct$ a) A database administrator ensures the integrity of the data resource" !hile a data administrator oversees the overall performance and integrity of a ()M*. b) A data administrator ensures the integrity of the data resource" !hile a database administrator oversees the overall performance and integrity of a ()M*. c) &he data administrator regularly bac4s up the databases and recovers them after system crashes. d) &he database administrator establishes security and sets up appropriate access controls. Ans: b Level: advanced
2/. hich of the follo!ing is not a responsibility of the data administrator$ a) minimize the redundancy of data by 4eeping centralized documentation of all data elements b) help businesses establish rules regarding data formats and relationships c) establish the security of data and set up appropriate access controls d) build inde0es to speed fre=uently performed =ueries Ans: d Level: advanced
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 46 22. >ey re=uirements for data in a database are that they must be a) se=uential and accessible b) organized and related c) accessible and manageable d) organized and se=uential Ans: b Level: intermediate
26. hich of the follo!ing statements regarding databases is correct$ a) (atabases must be computerized. b) Any collection of computer files constitutes a database. c) Many companies 4eep both computerized and non#computerized databases. d) Computerized databases are also 4no!n as manual databases. Ans: c Level: intermediate
%7. ?sing a ()M*" the programmer specifies a) ho! the data !ill be stored on dis4. b) ho! the data !ill be inde0ed. c) !hether the data !ill be compressed. d) !hat data to store and retrieve. Ans: d Level: intermediate
%1. hich of the follo!ing types of information provided by a database !ould managers not find useful$ a) (o the sales figures represent units or dollars$ b) ill zip codes display as five or nine digits$ c) Are foreign sales converted at the time of the sale$ d) Are returns subtracted from sales or 4ept as a separate entry$ Ans: b Level: intermediate
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 47 %2. hich of the follo!ing is an e0ample of the use of subschemas$ a) or4ers in shipping might see only a shipping address instead of a billing address. b) All customers must be assigned a sales representative. c) A student must be listed in the *tudent &able before she can be enrolled in a course. d) ,nvoice number must be si0 digits in length. Ans: a Level: advanced
%%. hich of the follo!ing allo! ()M*s to chec4 for data entry errors$ a) inde0es b) metadata c) =ueries d) physical vie!s Ans: b Level: intermediate
%+. hich of the follo!ing describes the proper management of simultaneous attempts to update a database by multiple users or multiple soft!are programs$ a) transaction processing b) atomicity c) data independence d) concurrency control Ans: d Level: intermediate
%-. hich of the follo!ing products can soft!are developers use to enforce transaction atomicity$ a) transaction processing monitor b) transaction processing inde0 c) atomicity controller d) atomicity processor Ans: a Level: intermediate
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 48 %.. hich of the follo!ing is not a reason ()M*s provide bac4up and recovery services$ a) Many databases are much too large to be bac4ed up as normal files. b) &raditional bac4ups might ta4e several hours. c) ?sers need to use and change databases !hile they are being bac4ed up. d) Most companies do not have enough storage to bac4up a comple0 database. Ans: d Level: intermediate
%/. A feasible alternative to providing managers !ith sensitive data" such as salary data" is a) to not allo! managers to access that data in any form. b) provide managers !ith aggregate or summarized salary data. c) to have database administrators provide managers !ith the data they re=uest. d) to not include that data in the database" since access to certain data cannot be limited. Ans: b Level: advanced
%2. Assume a business rule states that all customers must be assigned a sales representative" and a sales representative !ith customers leaves the company and should be deleted from the ()M*. hich of the follo!ing is most li4ely to happen$ a) &he sales representative cannot be deleted" since he is assigned to customers. b) &he sales representative can be deleted" but all his customers !ill also be deleted. c) 3ach of his customers should be assigned a ne! sales representative before he is deleted. d) &he sales representative's customers !ill temporarily not be assigned a sales representative until a ne! one is hired. Ans: c Level: advanced
%6. According to your te0t" three typical uses of database management systems include: a) supporting application soft!are" !arehousing data" and serving dynamic eb pages. b) supporting application soft!are" !arehousing data" and retrieving files. c) !arehousing data" serving dynamic eb pages" and inde0ing data. d) providing data independence" serving dynamic eb pages" and inde0ing data. Ans: a Level: advanced
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 49 +7. )usiness applications don't have to anticipate every conceivable use of the data they collect because a) programmers are readily available to ma4e changes in the ()M* as necessary. b) users !ill ma4e ad:ustments to the data they enter to fit !ithin the re=uirements of the database. c) all users should be e0perienced computer programmers. d) a ()M* allo!s users to retrieve data easily from a database !ithout any programming. Ans: d Level: advanced
+1. hich standard allo!s application programs to access databases through a ()M* in a uniform !ay$ a) ?niform ()M* standard b) @pen (atabase Connectivity <@()C) standard c) ;ML database standard d) 30tract &ransform Load <3&L) standard Ans: b Level: advanced
+2. &he process of identifying and formalizing the relationship among the elements of data that !ill form an organization's database is a) database management b) data manipulation c) data design d) record management Ans: c Level: intermediate
+%. hich of the follo!ing models offers a pictorial !ay of sho!ing the interrelationships among various types of data$ a) Aet!or4 Model b) 8ierarchical Model c) (ata 3lement Model d) 3ntity#5elationship Model Ans: d Level: intermediate
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 50 ++. &he primary advantage of the client9server architecture is that a) a single program accepts the input of many users and sends output to them accordingly. b) it offload the application programs and many of the functions of the ()M* from the server. c) the absence of central planning gives users freedom to develop applications that meet their needs. d) net!or4 traffic is reduced by 4eeping data closer to !here they are needed. Ans: b Level: advanced
+-. &he term used for storing the same data in t!o or more locations is a) replication. b) duplication. c) decentralized. d) net!or4 oriented. Ans: a Level: intermediate
+.. ,n the relational model" ho! are t!o tables lin4ed$ a) )y lin4ing them through an inde0 b) )y storing the tables in ad:acent sectors on the physical storage medium c) )y including identifying data from one table in the other table d) )y duplicating the data on t!o or more servers Ans: c Level: advanced
+/. &he attribute or attributes that uni=uely identify a ro! in a table are the a) normalization 4ey b) candidate 4ey c) foreign 4ey d) primary 4ey Ans: d Level: intermediate
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 51 +2. ,n the ob:ect model" ob:ects such as pictures" signatures" or sound recordings are stored on a) dedicated serves. b) universal servers. c) centralized servers. d) ;ML servers. Ans: b Level: intermediate
+6. &he increasing availability of personal computers has caused users !ho aren't computer professionals to insist on the ability to access data !ithout programming. &his factor e0plains the popularity of !hich database model$ a) relational model b) net!or4 model c) hierarchical model d) ;ML model Ans: a Level: advanced
-7. hich of the follo!ing is not a !ay in !hich the database administrator can improve performance of the ()M*$ a) &he ()A can build inde0es into the database. b) &he ()A can change the amount of cache storage and !or4ing memory available to the database. c) &he ()A can modify the data design through denormalization. d) &he ()A can increase the amount of storage space on the net!or4 servers. Ans: d Level: advanced
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
Multiple Choice 1. An organized collection of related data is a a) database. b) database management system. c) metadata file. d) data retrieval system. Ans: a Level: easy
2. hich of the follo!ing comprises programs to store" retrieve" and other!ise manage a computerized database and to provide interfaces to application programs and to non# programming users$ a) database b) database management system c) data retrieval system d) computer file Ans: b Level: easy
%. &he data's physical organization and representation on the storage medium is determined by the a) programmer. b) data administrator. c) database. d) ()M*. Ans: d Level: intermediate
TEST BANK • CHAPTER 4 40 +. ,n regard to data" users and programmers see !hich of the follo!ing types of vie!s$ a.) physical b) logical c) schema d) metadata Ans: b Level: intermediate
-. Metadata a) have no management purpose. b) are large amounts of physical data. c) are data about data. d) should not be included in a ()M*. Ans: c Level: intermediate
.. &he part of a database that holds its metadata is the a) subschema. b) data dictionary. c) logical vie!. d) transaction processor. Ans: b Level: easy
/. hich of the follo!ing in not one of the eight functions of a ()M* described in your te0t$ a) *toring and retrieving data b) Managing metadata c) Maintaining the data dictionary d) 1roviding transaction atomicity Ans: c Level: intermediate
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 41 2. hich of the follo!ing is not one of the eight functions of a ()M* described in your te0t$ a) 3nforcing business rules b) 1roviding authorization and security services c) 1roviding bac4up and recovery services d) 5educing the need for storage space Ans: d Level: intermediate
6. &he concept that a transaction cannot be split into smaller parts is a) atomicity b) autonomy c) anonymity d) augmentation Ans: a Level: easy
17. An enterprise#!ide database" containing summarized and aggregate data" designed to support business intelligence and management decision ma4ing rather than operational needs is a a) database management system b) data mining house c) data !arehouse d) data mart Ans: c Level: easy
11. A database" containing summarized and aggregate data" designed to support business intelligence and management decision ma4ing needs for a single department or division rather than the entire organization is a a) database management system. b) data mining house. c) data !arehouse. d) data mart. Ans: d Level: easy
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 42 12. hich of the follo!ing types of soft!are is designed to ease the development of dynamic eb pages$ a) transaction processing soft!are b) content management soft!are c) application development soft!are d) database development soft!are Ans: b Level: easy
1%. hich of the follo!ing statements about data elements is correct$ a) An attribute is part of a field" !hich is a group of data about similar things. b) A record contains files" also 4no!n as attributes. c) A file contains records" and each record contains fields. d) 5ecords contain files and tuples. Ans: c Level: intermediate
1+. (ata about one particular customer" such as name" address" phone number" and customer ,( !ould be found in a a) record b) attribute c) field d) attribute Ans: a Level: intermediate
1-. (ata about one of the characteristics of a record" such as a phone number" !ould be found in a a) record b) tuple c) file d) field Ans: d Level: intermediate
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 43 1.. 8o! an organization distributes data and database processing physically among the computers in a net!or4 refers to a) net!or4 architecture. b) decentralized architecture. c) distribution architecture. d) centralized architecture. Ans: c Level: intermediate
1/. hich of the follo!ing architectures involves no data sharing$ a) decentralized architecture b) centralized architecture c.) client9server architecture d) distributed architecture Ans: a Level: intermediate
12. hich of the follo!ing architectures has a single ()M* running on single computer and maintaining data centrally$ a) decentralized architecture b) client9server architecture c) centralized architecture d) distributed architecture Ans: c Level: intermediate
16. hich of the follo!ing architectures distributes both data and processing$ a) client9server architecture b) centralized architecture c) distributed architecture d) decentralized architecture Ans: c Level: intermediate
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 44 27. hich of the follo!ing statements about mi0ed architectures is most accurate$ a) ,n practice" mi0ed architectures are rarely used in companies. b) Mi0ed architectures are common" but a client9server architecture is rarely used by a company that also uses centralized architectures. c) Mi0ed architectures are common" but a decentralized architecture is rarely used by a company that also uses client9server architectures. d) A company !ith multiple sites might use a centralized architecture at one site to consolidate processing !hile using a client9server architecture at another site to distribute processing. Ans: d Level: advanced
21. (ifferent ()M*s treat the relationships among the elements of data differently. &heir approaches fall into a fe! broad categories" 4no!n as a) database architectures b) database models c) data !arehouses d) data mining services Ans: b Level: easy
22. hich database model is derived from ob:ect#oriented programming$ a) relational model b) ob:ect model c) ;ML model d) net!or4 model Ans: b Level: easy
2%. hich database model uses tables to represent files !ith ro!s called tuples and columns called attributes$ a) relational model b) ob:ect model c) hierarchical model d) net!or4 model Ans: a Level: easy
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 45 2+. hich database model builds a tighter lin4age <called a set) bet!een element of data" such as bet!een customers and sales representatives$ a) relational model b) ob:ect model c) ;ML model d) net!or4 model Ans: d Level: easy
2-. hich database model is a precursor to the net!or4 model" as a net!or4 model !ith additional restrictions$ a) relational model b) ob:ect model c) hierarchical model d) net!or4 model Ans: c Level: easy
2.. hich of the follo!ing statements regarding managing data is correct$ a) A database administrator ensures the integrity of the data resource" !hile a data administrator oversees the overall performance and integrity of a ()M*. b) A data administrator ensures the integrity of the data resource" !hile a database administrator oversees the overall performance and integrity of a ()M*. c) &he data administrator regularly bac4s up the databases and recovers them after system crashes. d) &he database administrator establishes security and sets up appropriate access controls. Ans: b Level: advanced
2/. hich of the follo!ing is not a responsibility of the data administrator$ a) minimize the redundancy of data by 4eeping centralized documentation of all data elements b) help businesses establish rules regarding data formats and relationships c) establish the security of data and set up appropriate access controls d) build inde0es to speed fre=uently performed =ueries Ans: d Level: advanced
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 46 22. >ey re=uirements for data in a database are that they must be a) se=uential and accessible b) organized and related c) accessible and manageable d) organized and se=uential Ans: b Level: intermediate
26. hich of the follo!ing statements regarding databases is correct$ a) (atabases must be computerized. b) Any collection of computer files constitutes a database. c) Many companies 4eep both computerized and non#computerized databases. d) Computerized databases are also 4no!n as manual databases. Ans: c Level: intermediate
%7. ?sing a ()M*" the programmer specifies a) ho! the data !ill be stored on dis4. b) ho! the data !ill be inde0ed. c) !hether the data !ill be compressed. d) !hat data to store and retrieve. Ans: d Level: intermediate
%1. hich of the follo!ing types of information provided by a database !ould managers not find useful$ a) (o the sales figures represent units or dollars$ b) ill zip codes display as five or nine digits$ c) Are foreign sales converted at the time of the sale$ d) Are returns subtracted from sales or 4ept as a separate entry$ Ans: b Level: intermediate
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 47 %2. hich of the follo!ing is an e0ample of the use of subschemas$ a) or4ers in shipping might see only a shipping address instead of a billing address. b) All customers must be assigned a sales representative. c) A student must be listed in the *tudent &able before she can be enrolled in a course. d) ,nvoice number must be si0 digits in length. Ans: a Level: advanced
%%. hich of the follo!ing allo! ()M*s to chec4 for data entry errors$ a) inde0es b) metadata c) =ueries d) physical vie!s Ans: b Level: intermediate
%+. hich of the follo!ing describes the proper management of simultaneous attempts to update a database by multiple users or multiple soft!are programs$ a) transaction processing b) atomicity c) data independence d) concurrency control Ans: d Level: intermediate
%-. hich of the follo!ing products can soft!are developers use to enforce transaction atomicity$ a) transaction processing monitor b) transaction processing inde0 c) atomicity controller d) atomicity processor Ans: a Level: intermediate
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 48 %.. hich of the follo!ing is not a reason ()M*s provide bac4up and recovery services$ a) Many databases are much too large to be bac4ed up as normal files. b) &raditional bac4ups might ta4e several hours. c) ?sers need to use and change databases !hile they are being bac4ed up. d) Most companies do not have enough storage to bac4up a comple0 database. Ans: d Level: intermediate
%/. A feasible alternative to providing managers !ith sensitive data" such as salary data" is a) to not allo! managers to access that data in any form. b) provide managers !ith aggregate or summarized salary data. c) to have database administrators provide managers !ith the data they re=uest. d) to not include that data in the database" since access to certain data cannot be limited. Ans: b Level: advanced
%2. Assume a business rule states that all customers must be assigned a sales representative" and a sales representative !ith customers leaves the company and should be deleted from the ()M*. hich of the follo!ing is most li4ely to happen$ a) &he sales representative cannot be deleted" since he is assigned to customers. b) &he sales representative can be deleted" but all his customers !ill also be deleted. c) 3ach of his customers should be assigned a ne! sales representative before he is deleted. d) &he sales representative's customers !ill temporarily not be assigned a sales representative until a ne! one is hired. Ans: c Level: advanced
%6. According to your te0t" three typical uses of database management systems include: a) supporting application soft!are" !arehousing data" and serving dynamic eb pages. b) supporting application soft!are" !arehousing data" and retrieving files. c) !arehousing data" serving dynamic eb pages" and inde0ing data. d) providing data independence" serving dynamic eb pages" and inde0ing data. Ans: a Level: advanced
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 49 +7. )usiness applications don't have to anticipate every conceivable use of the data they collect because a) programmers are readily available to ma4e changes in the ()M* as necessary. b) users !ill ma4e ad:ustments to the data they enter to fit !ithin the re=uirements of the database. c) all users should be e0perienced computer programmers. d) a ()M* allo!s users to retrieve data easily from a database !ithout any programming. Ans: d Level: advanced
+1. hich standard allo!s application programs to access databases through a ()M* in a uniform !ay$ a) ?niform ()M* standard b) @pen (atabase Connectivity <@()C) standard c) ;ML database standard d) 30tract &ransform Load <3&L) standard Ans: b Level: advanced
+2. &he process of identifying and formalizing the relationship among the elements of data that !ill form an organization's database is a) database management b) data manipulation c) data design d) record management Ans: c Level: intermediate
+%. hich of the follo!ing models offers a pictorial !ay of sho!ing the interrelationships among various types of data$ a) Aet!or4 Model b) 8ierarchical Model c) (ata 3lement Model d) 3ntity#5elationship Model Ans: d Level: intermediate
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 50 ++. &he primary advantage of the client9server architecture is that a) a single program accepts the input of many users and sends output to them accordingly. b) it offload the application programs and many of the functions of the ()M* from the server. c) the absence of central planning gives users freedom to develop applications that meet their needs. d) net!or4 traffic is reduced by 4eeping data closer to !here they are needed. Ans: b Level: advanced
+-. &he term used for storing the same data in t!o or more locations is a) replication. b) duplication. c) decentralized. d) net!or4 oriented. Ans: a Level: intermediate
+.. ,n the relational model" ho! are t!o tables lin4ed$ a) )y lin4ing them through an inde0 b) )y storing the tables in ad:acent sectors on the physical storage medium c) )y including identifying data from one table in the other table d) )y duplicating the data on t!o or more servers Ans: c Level: advanced
+/. &he attribute or attributes that uni=uely identify a ro! in a table are the a) normalization 4ey b) candidate 4ey c) foreign 4ey d) primary 4ey Ans: d Level: intermediate
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
TEST BANK • CHAPTER 4 51 +2. ,n the ob:ect model" ob:ects such as pictures" signatures" or sound recordings are stored on a) dedicated serves. b) universal servers. c) centralized servers. d) ;ML servers. Ans: b Level: intermediate
+6. &he increasing availability of personal computers has caused users !ho aren't computer professionals to insist on the ability to access data !ithout programming. &his factor e0plains the popularity of !hich database model$ a) relational model b) net!or4 model c) hierarchical model d) ;ML model Ans: a Level: advanced
-7. hich of the follo!ing is not a !ay in !hich the database administrator can improve performance of the ()M*$ a) &he ()A can build inde0es into the database. b) &he ()A can change the amount of cache storage and !or4ing memory available to the database. c) &he ()A can modify the data design through denormalization. d) &he ()A can increase the amount of storage space on the net!or4 servers. Ans: d Level: advanced
GORDON • INFORMATION SYSTEMS, A MANAGEMENT APPROACH
