Acct 451 Exam #3
Data concurrency a. occurs when a deadlock is triggered b. is a security issue in partitioned databases c. may result in data lockout d. is implemented using timestamping
is implemented using timestamping
Which of the following is usually not part of an ERP's OLAP applications? a. logistics b. what-if analysis c. ad hoc analysis d. decision support systems
logistics
Data currency is preserved in a centralized database by a. replicating the database b. using a lockout procedure c. partitioning the database d. implementing concurrency controls
using a lockout procedure
Which method does not manage or control data collisions that might occur on a network? a. polling b. token passing c. carrier sensing d. multiplexing
multiplexing
Which of the following associations would most likely describe the relationship between an internal agent and an economic event? a. 1:M b. 1:1 c. 0:M d. none of the above
1:M
Which statement is least accurate? a. Implementing an ERP system has as much to do with changing the way an organization does business as it does with technology. b. To take full advantage of the ERP process, reengineering will need to occur. c. A common reason for ERP failure is that the ERP does not support one or more important business processes of the organization. d. The big bang approach to ERP implementation is generally riskier than the phased-in approach.
A common reason for ERP failure is that the ERP does not support one or more important business processes of the organization.
Which of the following is a reason that data warehouses are created and maintained separately from operational databases? a. A separate centralized data warehouse is an effective means of collecting data from diverse sources. b. No ERP system incorporates data warehousing capability. c. Audit controls require that data for management analysis be kept separate from transaction data. d. The data is used in different ways that requires it to be physically separate.
A separate centralized data warehouse is an effective means of collecting data from diverse sources.
Which of the following is not a risk associated with ERP implementation? a. opposition to changes in the business culture b. choosing the wrong ERP c. choosing the wrong consultant d. All of these are risks associated with ERP implementations.
All of these are risks associated with ERP implementations
Which one of the following statements is correct? a. Web browsers cannot function without cookies. b. Cookies always contain encrypted data. c. Cookies contain the URLs of sites visited by the user. d. Cookies are text files and never contain encrypted data.
Cookies contain the URLs of sites visited by the user
Which statement is true? a. ERPs are infinitely scalable. b. Performance problems usually stem from technical problems, not business process reengineering. c. ERP systems can be modified using bolt-on software. d. The higher-end ERP can handle any problems an organization can have.
ERP systems can be modified using bolt-on software
Which of the following statements is not true? a. In three-tier client server architecture, one tier is for user presentations, one is for database and applications, and the third is for Internet access. b. Client computers are responsible for presenting data to the user and passing user input back to the server. c. The database and application functions are separate in the three-tier model. d. In a typical two-tier client server system, the server handles both application and database duties.
In three-tier client server architecture, one tier is for user presentations, one is for database and applications, and the third is for Internet access
A message that is made to look as though it is coming from a trusted source but is not is called a. URL masquerading b. a denial of service attack c. Internet protocol spoofing d. digital signature forging
Internet protocol spoofing
Which of the following statements is least likely to be true about a data warehouse? a. It may be deployed by organizations that have not implemented an ERP. b. It is constructed for quick searching and ad hoc queries. c. It contains data that are normally extracted periodically from the operating databases. d. It was an original part of all ERP systems.
It was an original part of all ERP systems.
Which of the following associations requires a separate link table? a. 1:1 b. 1:M c. M:M d. none of the above
M:M
Which statements about data warehousing is not correct? a. Drill-down is a data-mining tool available to users of OLAP. b. Data cleansing is a process of transforming data into standard form. c. The data warehouse should be separate from the operational system. d. Normalization is a requirement of databases included in a data warehouse.
Normalization is a requirement of databases included in a data warehouse.
Which of the following is usually not part of an ERP's core applications? a. OLTP applications b. business planning applications c. sales and distribution applications d. OLAP applications
OLAP Applications
Which of the following statements is correct? a. The REA model requires that phenomena be characterized in a manner consistent with the development of a multiple user view. b. The REA model requires that phenomena be characterized in a manner consistent with the development of a unique user view. c. The REA model requires that phenomena be characterized in a manner consistent with the development of a single user view. d. The REA model requires that phenomena be characterized in a manner consistent with the development of a selected user view.
The REA model requires that phenomena be characterized in a manner consistent with the development of a multiple user view
Which of the following are characteristics of internal agents? a. They participate in economic events, but do not assume control of the resources. b. They are employees of the company whose system is being modeled. c. They participate in economic events, but not in support events. d. All of the above.
They are employees of the company whose system is being modeled.
Which statement about ERP installation is least accurate? a. The phased-in approach is more suited to diversified businesses. b. ERP fails because some important business process is not supported. c. When a business is diversified, little is gained from ERP installation. d. For the ERP to be successful, process reengineering must occur.
When a business is diversified, little is gained from ERP installation
A data mart is a. a data warehouse created for a single function or department b. an enterprise resource planning system c. a database that provides data to an organization's customers d. another name for a data warehouse
a data warehouse created for a single function or department
Closed database architecture is a. a data warehouse control that prevents unclean data from entering the warehouse b. a limitation inherent in traditional information systems that prevents data sharing c. a control technique intended to prevent unauthorized access from trading partners d. a database structure that many of the leading ERPs use to support OLTP applications
a limitation inherent in traditional information systems that prevents data sharing
Which statement is not true? REA resources are: a. under the control of agents b. scarce c. assets d. affected by support events
affected by support events
The 'A' in REA stands for
agents
Which of the following is a level of the database that is defined by the data definition language? a. user view b. schema c. internal view d. all are levels or views of the database
all are levels or views of the database
Core applications are a. sales and distribution b. business planning c. shop floor control and logistics d. all of the above
all of the above
Protocols a. facilitate the physical connection between the network devices b. synchronize the transfer of data between physical devices c. provide a basis for error checking and measuring network performance d. all of the above
all of the above
The setup of a data warehouse includes a. modeling the data b. extracting data from operational databases c. cleansing the data d. all of the above
all of the above
Which of the following is true? a. REA diagram entities are arranged in constellations by entity class. b. ER diagrams present a static picture of the underlying business phenomena. c. Events entity names in REA diagrams are in the verb form. d. All of the above are true statements.
all of the above are true statements
Auditors of ERP systems a. are concerned that managers fail to exercise adequate care in assigning permissions b. need not review access levels granted to users because these are determined when the system is configured and never change c. need not be concerned about segregation of duties because these systems possess strong computer controls d. focus on output controls such as independent verification to reconcile batch totals
are concerned that managers fail to exercise adequate care in assigning permissions
The big bang method a. is more ambitious than the phased-in method b. has been associated with many failures c. both a. and b. d. neither a. nor b.
both a and b
Users access the database a. by constantly interacting with systems programmers b. all of the above c. by developing operating software d. by direct query
by direct query
All of the following are examples of economic events except a. shipping product to a customer b. checking a customer's credit prior to processing a sales order c. receiving raw materials from a supplier d. disbursing cash for inventories received
checking a customer's credit prior to processing a sales order
Most ERPs are based on which network model? a. peer to peer b. client-server c. ring topology d. bus topology
client-server
Which term is not associated with the relational database model? a. tuple b. attribute c. collision d. relation
collision
What control maintains complete, current, and consistent data at all information processing units? a. gateway control b. concurrency control c. replication control d. deadlock control
concurrency control
Data warehousing processes do not include a. transforming data b. extracting data c. modeling data d. condensing data
condensing data
Which procedure will prevent two end users from accessing the same data element at the same time? a. data redundancy b. none of the above c. data replication d. data lockout
data lockout
All of the following are elements of the DBMS which facilitate user access to the database except a. data definition language b. data access language c. data manipulation language d. query language
data access language
In the relational database model a. data is represented as a tree structure b. the user perceives that files are linked using pointers c. relationships are explicit d. data is represented on two-dimensional tables
data is represented on two-dimensional tables
The task of searching the database to locate a stored record for processing is called a. data attribution b. data deletion c. data retrieval d. data storage
data retrieval
The advantages of a partitioned database include all of the following except a. user control is enhanced b. response time is improved c. data transmission volume is increased d. risk of destruction of entire database is reduced
data transmission volume is increased
All of the following are advantages of a partitioned database except a. increased user control by having the data stored locally b. deadlocks are eliminated c. partitioning can reduce losses in case of disaster d. transaction processing response time is improved
deadlocks are eliminated
A user view a. is the logical abstract structure of the database b. specifies the relationship of data elements in the database c. defines how a particular user sees the database d. presents the physical arrangement of records in a database for a particular user
defines how a particular user sees the database
A digital signature is a. derived from the digest of a document that has been encrypted with the sender's private key b. the encrypted mathematical value of the message sender's name c. a tool that allows digital messages to be sent over analog telephone lines d. the computed digest of the sender's digital certificate
derived from the digest of a document that has been encrypted with the sender's private key
The data manipulation language a. transfers data to the buffer area for manipulation b. enables application programs to interact with and manipulate the database c. defines the database to the database management system d. describes every data element in the database
enables application programs to interact with and manipulate the database
The 'E' in REA stands for
events
When developing an REA model: a. link tables are explicitly depicted b. the same resource is both increased and decreased by the duality association c. events are organized in sequence of occurrence d. accounting artifacts are represented as support events
events are organized in sequence of occurrence
The events depicted on an REA diagram are transformed into computer processes while the resources and agents become relational database tables
false
Legacy systems are a. old manual systems that are still in place b. advanced systems without a data warehouse c. stable database systems after debugging d. flat file mainframe systems developed before client-server computing became standard
flat file mainframe systems developed before client-server computing became standard
A star topology is appropriate a. for centralized databases only b. for environments where network nodes routinely communicate with each other c. when the central database does not have to be concurrent with the nodes d. for a wide area network with a mainframe for a central computer
for a wide area network with a mainframe for a central computer
A table is in second normal form when it is a. free of insert anomalies b. free of partial dependencies c. free of repeating group data d. free of transitive dependencies
free of partial dependencies
A table is in first normal form when it is a. free of update anomalies b. free of repeating group data c. free of partial dependencies d. free of transitive dependencies
free of repeating group data
A table is in third normal form when it is a. free of partial dependencies b. free of deletion anomalies c. free of transitive dependencies d. free of repeating group data
free of transitive dependencies
Online transaction processing programs a. are available in two models—two-tier and three-tier b. allow users to analyze complex data relationships c. are bolt-on programs used with commercially available ERPs d. handle large numbers of relatively simple transactions
handle large numbers of relatively simple transactions
Goals of ERP include all of the following except a. reduced production time b. increased production c. improved customer service d. improvements of legacy systems
improvements of legacy systems
In a star topology, when the central site fails a. individual workstations can communicate with each other b. individual workstations cannot function locally and cannot communicate with other workstations c. the functions of the central site are taken over by a designated workstation d. individual workstations can function locally but cannot communicate with other workstations
individual workstations can function locally but cannot communicate with other workstations
What do you call a system of computers that connects the internal users of an organization that is distributed over a wide geographic area? a. multidrop network b. LAN c. intranet d. decentralized network
intranet
Which of the following tables would most likely have a composite key? a. Cash b. Ship Product c. Take Order d. Inventory Ship Link
inventory ship link
IP spoofing a. is a temporary phenomenon that disrupts transaction processing and resolves itself when the primary computer completes processing its transaction and releases the IP address needed by other users b. combines the messages of multiple users into a "spoofing packet" where the IP addresses are interchanged and the messages are then distributed randomly among the targeted users c. is a form of masquerading to gain unauthorized access to a web server d. is used to establish temporary connections between network devices with different IP addresses for the duration of a communication session
is a form of masquerading to gain unauthorized access to a web server
A virtual private network a. defines the path to a facility or file on the web b. is a private network within a public network c. is an Internet facility that links user sites locally and around the world
is a private network within a public network
The big bang approach
is more ambitious and risky than the phased-in approach
Which of the following statements is correct about TCP/IP? a. It controls web browsers that access the Internet. b. It is the basic protocol that permits communication between Internet sites. c. It is a low-level encryption scheme used to secure transmissions in HTTP format. d. It is the file format used to produce web pages.
is the basic protocol that permits communication between Internet sites
An IP address a. is represented by a 64-bit data packet b. is the address of the protocol rules and standards that govern the design of Internet hardware and software c. is the unique address that every computer node and host attached to the Internet must have d. defines the path to a facility or file on the web
is the unique address that every computer node and host attached to the Internet must have
NNTP a. is the document format used to produce web pages b. is used to connect to Usenet groups on the Internet c. controls web browsers that access the web d. is used to transfer text files, programs, spreadsheets, and databases across the Internet
is used to connect to Usenet groups on the Internet
Packet switching a. is used to establish temporary connections between network devices for the duration of a communication session. b. combines the messages of multiple users into one packet for transmission. At the receiving end, the packet is disassembled into the individual messages and distributed to the intended users. c. is a denial of service technique that disassembles various incoming messages to targeted users into small packages and then reassembles them in random order to create a garbled message. d. is a method for partitioning a database into packets for easy access where no identifiable primary user exists in the organization.
is used to establish temporary connections between network devices for the duration of a communication session
Each of the following is a relational algebra function except a. restrict b. join c. link d. project
link
In a REA diagram each economic event is always
linked to another economic event
Supply chain management software a. is typically under the control of external partners in the chain b. links all of the partners in the chain, including vendors, carriers, third-party firms, and information systems providers c. cannot be integrated into an overall ERP d. none of the above
links all of the partners in the chain, including vendors, carriers, third-party firms, and information systems providers
The deletion anomaly in unnormalized databases a. may result in the loss of important data b. is easily detected by users c. requires the user to perform excessive updates d. complicates adding records to the database
may result in the loss of important data
A distributed denial of service (DDoS) attack a. may take the form of either a SYN flood or smurf attack b. is more intensive that a DoS attack because it emanates from single source c. is so named because it effects many victims simultaneously, which are distributed across the Internet d. turns the target victims' computers into zombies that are unable to access the Internet
may take the form of either a SYN flood or smurf attack
To physically connect a workstation to a LAN requires a a. bridge b. multiplexer c. file server d. network interface card
network interface card
The concept of duality means that a REA diagram must consist of: a. two events, one of them economic and the other support b. two agents, one of them internal and the other external c. two resources, one increased and the other decreased by the same event d. none of the above
none of the above
Entities are a. data that describe the characteristics of properties of resources b. nouns that are depicted by rectangles on an entity relationship diagram c. sets of data needed to make a decision d. associations among elements
nouns that are depicted by rectangles on an entity relationship diagram
The update anomaly in unnormalized databases a. may result in the loss of important data b. often results in excessive record insertions c. complicates adding records to the database d. occurs because of data redundancy
occurs because of data redundancy
In the relational database model all of the following are true except a. data can be extracted from specified rows from specified tables b. only one-to-many relationships can be supported c. a new table can be built by joining two tables d. data is presented to users as tables
only one-to-many relationships can be supported
An example of a distributed database is a. partitioned database b. centralized database c. networked database d. all are examples of distributed databases
partitioned database
This class of cloud computing enables client firms to develop and deploy onto the cloud infrastructure consumer-generated applications using facilities provided by the vendor. a. infrastructure-as-a-service b. platform-as-a-service c. computing-as-a-service d. software-as-a-service
platform-as-a-service
Which of the following events would be least likely to be modeled in a REA diagram? a. customer inquiries b. receiving cash c. sales to a customer d. posting accounts payable
posting accounts payable
Which of the following is not an example of an economic event? a. Prepare cash disbursements voucher b. Receive goods c. Ship goods d. Get employee time
prepare cash disbursement voucher
The client-server topology a. functions only with a ring and bus topology b. reduces the number of records that must be locked by having the file server perform record searches c. increases the amount of data that is transmitted between the central file and the network node d. eliminates the need for nodes to communicate with each other
reduces the number of records that must be locked by having the file server perform record searches
Extracting data for a data warehouse a. cannot be done from flat files b. should only involve active files c. requires that the files be out of service d. all of the above
requires that the files be out of service
Which statement is not correct? A query language like SQL a. requires user familiarity with COBOL b. is written in a fourth-generation language c. reduces reliance on programmers d. allows users to retrieve and modify data
requires user familiarity with COBOL
The 'R' in REA stands for
resources
Which topology has a large central computer with direct connections to a periphery of smaller computers? Also in this topology, the central computer manages and controls data communications among the network nodes. a. ring topology b. bus topology c. client/server topology d. star topology
star topology
Data cleansing involves all of the following except a. filtering out or repairing invalid data b. transforming data into standard business terms c. summarizing data for ease of extraction d. formatting data from legacy systems
summarizing data for ease of extraction
Which statement is false? a. The DBMS is special software that is programmed to know which data elements each user is authorized to access. b. The DBMS does not control access to the database. c. During processing, the DBMS periodically makes backup copies of the physical database. d. User programs send requests for data to the DBMS.
the DBMS does not control access to the database
In an REA model, events are described from the perspective of a. the user b. the organization c. the designer d. the customer
the organization
The primary difference between a LAN and a WAN is a. the type of workstation used b. the geographical area covered by the network c. the transmission technology used d. the size of the company
the geographical area covered by the network
Which characteristic is not associated with the database approach to data management? a. the ability to control access to the data b. constant production of backups c. the inability to determine what data is available d. the ability to process data without the help of a programmer
the inability to determine what data is available
A description of the physical arrangement of records in the database is a. the subschema b. the external view c. the conceptual view d. the internal view
the internal view
When assigning foreign keys in a 1:1 association, a. the primary key of each table should be embedded as a foreign key in the related table b. the primary key on the (0,1) side of the relation should be embedded as the foreign key on the (1,1) side c. the primary key on the (1,1) side of the relation should be embedded as the foreign key on the (0,1) side d. none of the above is true
the primary key on the (1,1) side of the relation should be embedded as the foreign key on the (0,1) side
When assigning foreign keys in a 1:M association, a. the primary key of each table should be embedded as a foreign key in the related table b. the primary key on the (0,M) side of the relation should be embedded as the foreign key on the (1,1) side c. the primary key on the (1,1) side of the relation should be embedded as the foreign key on the (0,M) side d. none of the above is true
the primary key on the (1,1) side of the relation should be embedded as the foreign key on the (0,M) side
Which of the following may provide many distinct views of the database? a. the schema b. the internal view c. the user view d. the conceptual view
the user view
In a hierarchical model a. the way to access data is by following a predefined data path b. links between related records are implicit c. a member (child) record may have more than one owner (parent) d. an owner (parent) record may own just one member (child) record
the way to access data is by following a predefined data path
A replicated database is appropriate when a. there is no risk of the deadlock phenomenon b. there is minimal data sharing among information processing units c. most data sharing consists of read-write transactions d. there exists a high degree of data sharing and no primary user
there exists a high degree of data sharing and no primary user
Which duty is not the responsibility of the database administrator? a. to implement security controls b. to design application programs c. to develop and maintain the data dictionary d. to design the subschema
to design application programs
Modern managers need both financial and nonfinancial information that traditional GAAP-based accounting systems are incapable of providing.
true
The formal name for a row in the physical database table is
tuple
Task-data dependency is a. another term for data redundancy b. user's inability to obtain additional information as needs change c. none of the above d. failure to update the files of all users affected by a change
user's inability to obtain additional information as needs change
REA diagrams include all of the following entities except a. economic events b. users c. support events d. internal agents
users
