Exam

Question 1

Which of the following statements concerning transaction data are true?
1. Transaction data are big numbers
2. Transaction data change infrequently
3. Transaction data are a consequence of the execution of process steps
4. Transaction data represent entities such as customer and vendors

Answer 1

Transaction data are a consequence of the execution of process steps.

Question 2

Which of the following is not an example of an advantage to using the Web to access organizational databases?

Answer 2

It is clear and virus free

Question 3

2. What kind of society is being created by the growth in information industries?
   A. knowledge-dependent local society
   B. knowledge-independent local society
   C. knowledge-dependent global society
   D. knowledge-independent global society

Answer 3

Knowledge-dependent global society

Question 4

3. Why is the global economy becoming more integrated?
   A. international outsourcing
   B. the Internet
   C. relaxed borders in the European Union
   D. all on the list

Answer 4

All on the list

Question 5

4. Which trend has the following potential business impact? The time to get products and services to market is being shortened by technology.
   A. Pace of technological innovation is increasing.
   B. Time is becoming one of the world’s most precious commodities.
   C. The economy and society are dominated by technology.
   D. The global economy is becoming more integrated.

Answer 5

Pace of technological innovation is increasing.

Question 6

5. Which trend has the following potential business impact? Top managers must be computer-literate to retain their jobs and achieve success.
   A. The growth in information industries is creating a knowledge-dependent global society.
   B. The economy and society are dominated by technology.
   C. Pace of technological innovation is increasing.
   D. The global economy is becoming more integrated.

Answer 6

The growth in information industries is creating a knowledge-dependent global society.

Question 7

6. Shari is creating a process flow diagram of her company’s integrated business processes, after which of the following activities should she include a decision point? (2 correct answers)
   A. Create Purchase Order
   B. Create Sales Order
   C. Authorize Production
   D. Receive Shipment From Vendor

Answer 7

Create Sales Order/ Authorize Production

Question 8

7. Harry manages the warehouse and is delegating responsibilities to his employees on the show floor. Which of the following warehouse management steps are related to the procurement process? (2 correct answers)
   A. Create invoice
   B. Post goods issue
   C. Create outbound delivery
   D. Create transfer order
   E. Create transfer request

Answer 8

Create Transfer Order Create transfer Request

Question 9

8. Cathy is explaining where integration occurs between their basic business processes. Which of the following statements about an integrated process are TRUE? (3 correct answers)
   A. The process is triggered by a customer order.
   B. The fulfillment process is suspended when the needed raw materials are not available.
   C. The production process is suspended when the needed raw materials are not available.
   D. The production process continues when the finished products become available.
   E. The fulfillment process continues when the finished products become available.

Answer 9

The process is triggered by a customer order./ The production process is suspended when the needed raw materials are not available./ The fulfillment process continues when the finished products become available.

Question 10

What is the difference between an RFQ and an RFP?
1. The response to an RFQ is a big document requiring much more than just the price
2. The response to an RFP is a big document requiring much more than just the price
3. RFQ is usually for big, complex requirements
4. There is no difference between them. They are similar terms.

Answer 10

The response to an RFP is a big document requiring much more than just the price.

Question 11

What does the response to RFP consist of, and what is its business purpose?
1. You respond an RFP with an RFQ that gives the detailed price quotation
2. Response to RFP is the ‘Proposal’, a techno-commercial offer, that contains detailed Technical and detailed Commercial terms
3. You need not respond to an RFP. It is one of the document that you receive from a supplier
4. You respond to the RFP with the RFI document that gives the details of your requirements

Answer 11

Response to RFP is the ‘Proposal’, a techno-commercial offer, that contains detailed Technical and detailed Commercial terms.

Question 12

A Letter-of-credit is given by a business to their _____ to allow a business deal to happen.
1. The Bank
2. Customer, Sales department
3. Supplier, Sales or Accounting
4. To their Customer, Accounting department

Answer 12

Supplier, Sales or Accounting.

Question 13

Harry manages the warehouse and is delegating responsibilities to his employees on the show floor. Which 2 of the following warehouse management steps are part of the procurement process?
1. Create invoice
2. Post goods issue
3. Create outbound delivery
4. Create Transfer Order
5. Create Transfer Request

Answer 13

Create Transfer Order/ Create Transfer Request

Question 14

When Could You Expect an LOI (letter of intent)?
1. Before PO
2. Soon after the RFI
3. Before an RFP
4. After the LC
5. After a PO

Answer 14

Before PO

Question 15

RFI stands for?

Answer 15

Request for Information

Question 16

Invoice means?

Answer 16

A bill

Question 17

DO stands for?

Answer 17

Delivery Order

Question 18

Who makes the RFQ?
Remember: Every company buys raw material and sells finished products, so every company is a ‘Customer’ when buying and a ‘Supplier’ when selling. You need to spot the right role and the right department.

Answer 18

Customers Purchasing Department

Question 19

Who makes the GRN (Goods Receive Note)?

Answer 19

Customers Shipping Department

Question 20

When companies think about moving work to countries like China and India, they see two major issues or problems they may face. These are:
1. ease the burden on overworked internal application developers and lower costs.
2. increased need for communication and coordination.
3. lower costs and faster development time
4. faster development time and increased need for communication.

Answer 20

Increased need for communication

Question 21

A master data has all the following characteristics EXCEPT
1. it is stable
2. it is more Accurate
3. it is used for Validation
4. it represents events

Answer 21

It represents events

Question 22

Even the right answer to Challenge-3 has these 2 problems:
1. It is prone to errors that can send businesses into a chaos
2. Neither Excel nor Access can help: The problem is with the table design
3. Just move the right solution of Challenge-3 to MS Access and all problems are solved!

Answer 22

It is prone to errors that can send business into a chaos/ Neither Excel nor Access can help: The problem is with the table design

Question 23

Which relationship is a BAD relationship in Database design?
1. 1-to-many
2. Many-to-1
3. Many-and-many
4. Many-to-many

Answer 23

Many-to-Many

Question 24

A database key comprised of two or more attributes is called a(n):
1. Conjointed twins
2. Concatenated Primary key
3. Combination Primary key

Answer 24

Combination Primary key

Question 25

Which of the following illustrates the primary concepts of the relational database model?

Answer 25

Entities, attributes, keys, and relationships

Question 26

A(n) _____________ is a software application that manages the database and controls access to the data stored in the database.

Answer 26

database management system

Question 27

What are rules that help ensure the quality of information?

Answer 27

Integrity constraints

Question 28

A(n) _____________ is an organized collection of related data.

Answer 28

Database

Question 29

So, which of the following statements are true? (3 right answers) -Excel is totally useless if you have Access -Excel is a great solution to capture a continuous flow of repeating data -Excel is great for non-repeating data that needs to be analyzed in great depth -Excel is a great solution to build trust and allow user control -Access is great for capturing and supporting regular flow of business information such as customer orders, supplier orders, product flow, payroll processing, and such

Answer 29

-Excel is great for non-repeating data that needs to be analyzed in great depth -Excel is a great solution to build trust and allow user control -Access is great for capturing and supporting regular flow of business information such as customer orders, supplier orders, product flow, payroll processing, and such

Question 30

1. Which of the following is not a potential business impact from the world's population doubling in the next 40 years? A. The time to get products and services to market is being shortened by technology. B. Global agriculture will be required to supply as much food as has been produced during all of human history. C. Developed nations will find that retirees will have to remain on the job to remain competitive. D. Developed nations will begin to increase immigration limits.

Answer 30

The time to get products and services to market is being shortened by technology.

Question 31

9. In a manual, paper-based process, delays are caused due to which of the following? (2 correct answers) A. Increased inventories B. Increased cycle times C. Creating paperwork D. Reduced cycle times E. Sending paperwork

Answer 31

Creating paperwork/ Sending paperwork

Question 32

What is a CIO?

Answer 32

CIO stands for Chief Information Officer, they are senior executives that are responsible for all aspects of their companies information and technology systems.

Question 33

A proforma invoice is used to 1. Bill the customer for proforma supply of goods 2. Invoice your customer for the advance money they gave you 3. Let your customer know how your final bill would look like 4. Bill the customers for goods you have already provided 5. Bill the customers for the goods you are about to ship

Answer 33

Let your customer know how your final bill would look like

Question 34

A Purchase Requisition is created by the 1. Supplier, Sales 2. Customer, Purchasing department 3. Customer, end-user department 4. Supplier, Purchasing department

Answer 34

Customer, end-user department

Question 35

The Comparative statement is created by 1. Customer, Sales 2. Supplier, Purchasing 3. Customer, Purchasing 4. Supplier, Sales

Answer 35

Customer, Purchasing

Question 36

Shari is creating a process flow diagram of her company's integrated business processes, after which of the following 2 activities should she include a decision point? 1. Create Purchase Order 2. Create Sales Order 3. Authorize Production 4. Receive Shipment From Vendor

Answer 36

Create Sales Order/ Authorize Production

Question 37

Shari is creating a process flow diagram of her company's integrated business processes, after which of the following activities should she include a decision point? 1. Create Purchase Order 2. Receive Shipment from Vendor 3. Create Sales Order 4. Authorize Production

Answer 37

Create Sales Order/ Authorize Production

Question 38

Who receives the PO? Remember: Every company buys raw material and sells finished products, so every company is a 'Customer' when buying and a 'Supplier' when selling. You need to spot the right role and the right department. 1. Supplier, Sales dept 2. Supplier, all internal depts 3. Supplier, Purchasing dept 4. Customer, Sales dept 5. Customer, Purchasing dept

Answer 38

Supplier, Sales department

Question 39

PR stands for?

Answer 39

Purchase Requisition

Question 40

What is a DI?

Answer 40

It is the Shipping dept's instructions on how to delivery goods to the customer and includes transportation details such as the shipping route and number of shipments

Question 41

The nature of the Foreign Key is such that: (Choose 3) 1. In the table the Foreign Key is present, it will be 'Duplicates Okay' 2. This is a key that allows 2 tables to connect with each other, especially when there is nothing else in common. 3. A Foreign Key in one table is a Primary key in another table. 4. It is just another name for Primary Key.

Answer 41

In the table the Foreign Key is present, it will be 'Duplicates Okay'/ This is a key that allows 2 tables to connect with each other, especially when there is nothing else in common/ A Foreign Key in one table is a Primary key in another table.