Multiple choice

1.One of the most important ways that ERPs benefit organizations and their business processes is:

• Current information is made available to all users involved in the activities and decisions associated with a company's business processes.
• Information is stored in many specialized, distributed databases that each serve separate business processes.
• Preventing external business partners from accessing the organization's data.
• Reducing the amount of time to complete business processes by eliminating all controls associated with the processes.

2.Which of the following about SQL isincorrect?

• SQL uses the PIVOT function to insert data.
• SQL is a language designed to query data in a relational database.
• SQL uses SELECT statement to tell the query which columns (or attributes) of a table should be included in the query.
• SQL is based on relational algebra and allows a user to query and update the database.

4.Which of the following statements about the requirements of table design isincorrect?

• Each attribute (column) of a record (row) must be single-valued.
• All other non-key attributes in a table must describe a characteristic of the class (table) identified by the foreign key.
• Each attribute in a table must have a unique name.
• Values of a specific attribute must be of the same type.

5.Which of the following isnotan application control when placing a purchase order?

• System provided purchase order number.
• System provided range and limit checks.
• System provided default values.
• System provided type image.

7.Which of the following best describes the purpose of an intermediate error event?

• Shows the interchange between two pools.
• Depicts the sequence of activities in one pool.
• Illustrates the process flow when an exception occurs.
• Contains a series of activities that are hidden from view.