ACC 306

Using the database depicted above, how many foreign keys are in the database? Select one: A. 3 B. 0 C. 5 D. 4

A. 3 (number of links)

Mara Kay is a system analyst for a national department store. She was tasked to identify previously unknown relationships in the company's sales data that can be used in future promotions. What technique would Mara most likely use? Select one: A. Data mining B. Data exploring C. Customer resource management D. Customer auditing

A. Data mining

Which statement is true regarding file systems? Select one: A. Multiple master files create problems with data consistency. B. Transaction files are similar to ledgers in a manual AIS. C. Transaction files are permanent. D. Individual records are never deleted in a master file.

A. Multiple master files create problems with data consistency

Suppose a relational database contained two linked tables. Assuming the organization wants the database to be normalized, which of the following items represents a problem to normalization? Select one: A. The database contains only one primary key. B. The database contains two foreign keys. C. The database contains only one foreign key. D. The database contains two primary keys.

A. The database contains only one primary key.

The ________ contains information about the structure of the database. Select one: A. data dictionary B. database management system C. data warehouse D. data definition language

A. data dictionary

Emma Kolb is a system analyst at a manufacturing company located in the Midwest. She has been asked to analyze the company's accounting information system and to recommend cost-effective improvements. After noting that the several key managers do not have access to the production and sales information, she recommends that they should be uploaded to the company's internal network and be made available for search. Implementation of her recommendation would benefit the company by contributing to Select one: A. increase data sharing. B. reduce data redundancy. C. data independence. D. data integration.

A. increase data sharing.

A low-level view of the database that describes how the data are actually stored and accessed is the Select one: A. internal-level schema. B. conceptual-level schema. C. subschema. D. external-level schema.

A. internal-level schema.

Using a file-oriented approach to data and information, data is maintained in Select one: A. many separate files. B. a centralized database. C. a decentralized database. D. many interconnected files.

A. many separate files.

Emma Kolb is a system analyst at a manufacturing company located in the Midwest. She has been asked to analyze the company's accounting information system and to recommend cost-effective improvements. After noting that the same production files have been saved and stored independently on several databases, she recommends that they be stored only once. Implementation of her recommendation would benefit the company by contributing to Select one: A. reduce data redundancy. B. data integration. C. data independence. D. increase data sharing.

A. reduce data redundancy.

The database design method in which a designer uses knowledge about business processes to create a diagram of the elements to be included in the database is called Select one: A. semantic data modeling. B. normalization. C. decentralization. D. geometric data modeling.

A. semantic data modeling.

Abby Burke has created custom statues made out of scrap metal for over ten years. Abby has kept detailed records of every statue she has ever created. For every sale, she obtains the customer's name and address, a description of the statue, and a picture of the statue sold to the customer. Her unique style has recently attracted the attention of several celebrities. Ready to take her business to the next level, Abby has hired you to construct an accounting information system, which she wants modeled after her paper records. As you look over her records, you realize that sometimes the same customer is recorded by a slightly different name. For example, Mike Mulligan bought a horse statue, M. Mulligan bought a bear statue, and Mike M. all seem to be the same person. This is an example of what type of problem in the existing records? Select one: A. update anomaly B. insert anomaly C. entity integrity D. referential integrity

A. update anomaly

If a national sales tax were implemented, which language would be used to add a new field in the sales table to track the sales tax due? Select one: A. Data Query Language B. Data Definition Language C. Data Update Language D. Data Manipulation Language

B. Data Definition Language

When the human resources manager wants to gather data about salary and start date by employees and by departments, the manager would use which language? Select one: A. Data Manipulation Language B. Data Query Language C. Data Report Language D. Data Definition Language

B. Data Query Language

Which is probably the most immediate and significant effect of database technology on accounting? Select one: A. Replacement of the double entry-system. B. Quicker access to and greater use of accounting information in decision-making. C. Elimination of traditional records such as journals and ledgers. D. Change in the nature of financial reporting.

B. Quicker access to and greater use of accounting information in decision-making.

Suppose a relational database contained two linked tables. Which of the following items is not necessarily present in the database? Select one: A. One foreign key B. Two foreign keys C. Two primary keys D. At least one column

B. Two foreign keys

Pat Owen is chair of the National Grizzly Society, which maintains a database of all grizzly bears within the United States. One table will store the name, birth date, and other characteristics of all of the grizzly bears that have been registered. Each grizzly bear is uniquely identified by a registration number. A second table will contain data that link each grizzly bear to its male and female parents by means of their registration numbers. The primary key in the second table is Select one: A. name. B. a combination of primary keys in the first table. C. birth date. D. the same as the primary key in the first table.

B. a combination of primary keys in the first table.

The use of a data warehouse in strategic decision making is often referred to as Select one: A. analytical modeling. B. business intelligence. C. data analysis. D. managerial accounting.

B. business intelligence.

An attribute in a table that serves as a unique identifier in another table and is used to link the two tables is a Select one: A. primary key. B. foreign key. C. relational key. D. linkage key.

B. foreign key.

Identify one potential outcome of the insert anomaly. Select one: A. inconsistent data B. inability to add new data C. unintentional loss of data D. None of these

B. inability to add new data

Emma Kolb is a system analyst at a manufacturing company located in the Midwest. She has been asked to analyze the company's accounting information system and to recommend cost-effective improvements. After noting that the production and sales departments use database systems that are entirely separated, she recommends that they be combined. Implementation of her recommendation would benefit the company by contributing to data Select one: A. qualifications. B. integration. C. redundancy. D. independence.

B. integration.

File-oriented approaches create problems for organizations because of Select one: A. a lack of sophisticated file maintenance software. B. multiple master files. C. multiple users. D. multiple transaction files.

B. multiple master files.

The technique of using queries to investigate hypothesized relationships among data is called Select one: A. business intelligence. B. online analytical processing. C. data mining. D. data analysis.

B. online analytical processing.

Which of the following would not be found in a data dictionary entry for a data item? Select one: A. field type B. physical location of the data C. records containing a specific data item D. source of the data item

B. physical location of the data

Tom Wilson is chairman of the Rare Car Club, where he maintains a database of registered rare cars and their history. One table will store the model, make, vehicle identification number, and other characteristics of all of the registered rare cars. Each rare car is uniquely identified by a registration number. A second table will contain data that link each rare car to its most recent estimated fair market value by means of their registration numbers. The primary key in the first table is Select one: A. make. B. registration number. C. vehicle identification number. D. model.

B. registration number.

Reports produced using the data dictionary could include all of the following except a list of Select one: A. programs where a data item is used. B. the schemas included in a database. C. outputs where a data element is used. D. synonyms for the data items in a particular file.

B. the schemas included in a database.

Databases were originally developed to address which problem? Select one: A. to decrease the costs associated with manual accounting systems B. to address the proliferation of master files C. to increase the speed that an organization could process transactions D. to replace the double entry-system

B. to address the proliferation of master files

A ________ is an abstract representation of a database's contents. Select one: A. physical view B. schema C. data dictionary D. logical data model

D. logical data model

Which statement below concerning the database management system (DBMS) is false? Select one: A. The DBMS uses special languages to perform specific functions. B. Users' requests for information are transmitted to the DBMS through application software. C. The DBMS automatically creates application software for users, based on data dictionary parameters. D. The DBMS automatically maintains the data dictionary.

C. The DBMS automatically creates application software for users, based on data dictionary parameters.

Which would not generally be considered a data dictionary output report? Select one: A. a list of all synonyms for the data elements in a particular file B. a list of all data elements used by a particular user C. a list of cash balances in the organization's bank accounts D. a list of all programs in which a data element is used

C. a list of cash balances in the organization's bank accounts

A row in a table that contains data about a specific item in a database table is call Select one: A. an attribute. B. a relational record. C. a tuple. D. a data model.

C. a tuple.

How do users retrieve data stored in a database? Select one: A. by performing a search B. by specifying the primary keys C. by executing a query D. by viewing the appropriate data tables

C. by executing a query

The combination of the database, the DBMS, and the application programs that access the database through the DBMS is referred to as the Select one: A. data warehouse. B. database management system. C. database system. D. database administrator.

C. database system.

The physical view of a database system refers to Select one: A. how master files store data values used by more than one application program. B. how a user or programmer conceptually organizes and understands the data. C. how and where the data are physically arranged and stored. D. how the DBMS accesses data for a certain application program.

C. how and where the data are physically arranged and stored.

A data warehouse Select one: A. increases the speed of transaction processing. B. stores transaction processing records in hard copy. C. is primarily used for analysis rather than transaction processing. D. replaces traditional transaction processing databases.

C. is primarily used for analysis rather than transaction processing

Which of the following would not be one of the well-structured tables in a well-designed relational database used to generate this sales invoice? Select one: A. Sales B. Customer C. Sales Order D. Customer Order

D. Customer Order

When the human resources manager wants to build a data dictionary, the manager would use which language? Select one: A. Data Manipulation Language B. Data Query Language C. Data Report Language D. Data Definition Language

D. Data Definition Language

________ is a feature in many database systems that simplifies the creation of reports by allowing users to specify the data elements desired and the format of the output. Select one: A. Report generator B. Report printer C. Report creator D. Report writer

D. Report writer

The document that shows the items stored in a file, including the order and length of the data fields and the type of data stored is called Select one: A. a logical layout. B. a data layout. C. a physical layout. D. a record layout.

D. a record layout.

Merlin Frodo has been doing custom piercings and tattoos for over thirty years. His home and place of business is a garage in the harbor district of Seattle, Washington. He keeps meticulous records of every job he has ever completed. These have been entered into a computerized accounting information system that his accountant refers to as a "data warehouse." Merlin is considering adding scarification to his service offerings and has asked his accountant to identify past customers who might be likely candidates for this service. Merlin wants his accountant to engage in Select one: A. customer auditing. B. customer resource management. C. enterprise resource planning. D. data mining.

D. data mining.

All of the following are benefits of the database approach except Select one: A. data integration and sharing. B. minimal data redundancy. C. cross-functional analysis and reporting. D. decentralized management of data.

D. decentralized management of data.

The problem of losing desired information from a database when an unwanted record is purged from the database is referred to as the ________ anomaly. Select one: A. purge B. erase C. integrity D. delete

D. delete

In a well-structured relational database, Select one: A. there must be at least two foreign keys. B. foreign keys cannot be null. C. one table must be related to all other tables. D. every column in a row must be single valued.

D. every column in a row must be single valued.

In the database design approach known as normalization, the first assumption made about data is Select one: A. the delete anomaly will not apply since all customer records will be maintained indefinitely. B. the data will not be maintained in 3NF tables. C. there is no redundancy in the data. D. everything is initially stored in one large table.

D. everything is initially stored in one large table.

Mary Lamb is an insurance sales representative. Her company has provided her with a laptop computer that uses wireless connectivity to access the accounting information system from virtually anywhere in the country. She has access to view customer and insurance product information. She also has access that allows her to enter and cancel customer orders. The permissions for Mary (and other sales reps) define a ________ in the company's database management system. Select one: A. physical view B. data dictionary C. conceptual-level schema D. external-level schema

D. external-level schema

Emma Kolb is a system analyst at a manufacturing company located in the Midwest. She has been asked to analyze the company's accounting information system and to recommend cost-effective improvements. After noting that the same production files have been saved and stored independently on several databases, she recommends that they be stored only once. Implementation of her recommendation would benefit the company by contributing to Select one: A. increase data sharing. B. data independence. C. data integration. D. reduce data redundancy.

D. reduce data redundancy