1. Basic data management tasks
2. The database approach to data management
3. How do users access databases?
4. Hierarchical model
5. Relational algebra functions
6. Data currency is preserved in a centralized database by using a lockout procedure
7. Data concurrency is implemented using time stamping
8. A table is in first normal form when it is free of repeating group data
9. In a REA diagram each economic event is always linked to another economic event
10. REA diagram entities are arranged in constellations by entity class.
11. ER diagrams present a static picture of the underlying business phenomena
12. Events entity names in REA diagrams are in the verb form
13. The following events would be most likely to be modeled in a REA diagram:
|
|
customer inquires
|
|
|
sales to a customer
|
|
|
receiving cash
|
14. The following types of entities are included in REA diagrams:
|
|
support events
|
|
|
economic events
|
|
|
internal agents
|
15. The REA model requires that phenomena be characterized in a manner consistent with the development of a multiple user view.
16. In an REA model, events are described from the perspective of the organization
17. When assigning foreign keys in a 1:1 association: The primary key on the (1, 1) side of the relation should be embedded as the foreign key on the (0, 1) side.
18. Core applications are sales and distribution, business planning and shop floor control and logistics
19. Decision support systems, ad hoc analysis, and what-if analysis are usually part of an ERP's OLAP applications.
20. The data warehouse should be separate from the operational system.
21. Data cleansing is a process of transforming data into standard form.
22. Drill-down is a data-mining tool available to users of OLAP.
23. This is a bad question, so I'm straight out giving you the answer: Auditors of ERP systems may feel that the data warehouse is too clean and free from errors.
24. Most ERPs are based on client-server network models.
25. The setup of a data warehouse includes modeling the data, extracting data from operational databases and cleansing the data.
26. Implementing an ERP system has as much to do with changing the way an organization does business than it does with technology.
27. To take full advantage of the ERP process, reengineering will need to occur.
28. The big-bang approach to ERP implementation is generally riskier than the phased in approach.
29. Auditors of ERP systems are concerned that managers fail to exercise adequate care in assigning permissions.
30. Packet switching is used to establish temporary connections between network devices for the duration of a communication session.
31. In a ring topology all nodes are of equal status, nodes manage private programs and databases locally and shared resources are managed by a file server which is a node on the ring
32. A star topology is appropriate for a wide area network with a mainframe for a central computer
33. NNTP is used to connect to Usenet groups on the Internet
34. HTML is the document format used to produce Web pages.
35. A digital signature is derived from the digest of a document that has been encrypted with the sender's private key
36. Which of the following is a key feature of cloud computing?
|
a.
|
Acquisition of resources is rapid and infinitely scalable.
|
|
b.
|
Client firms can acquire IT resources from vendors on demand and as needed.
|
|
c.
|
Computing resources are pooled to meet the needs of multiple client firms.
|
|
d.
|
All of the above.
|
37. The intermediary in a smurf attack is also a victim.
38. If a chosen ERP cannot handle a specific company process bolt-on software may be available.
39. Modern managers need both financial and nonfinancial information that traditional GAAP-based accounting systems are incapable of providing.