MGT 268 Midterm Review
What is a logical data structure that details the relationship among data elements using graphics or pictures 1. Data model 2. Data mining tool 3. Data mart tool 4. Data element
1. Data model
What maintains information about various types of objects, events, people, and places? 1. Database 2. Data model 3. Data mining 4. Data intelligence
1. Database
What is a Proforma Invoice? 1. A document that shows the customer how the final Invoice might look like for the current order 2. A Professional Invoice that carries with it legal terms and conditions that need to be followed 3. A document that is nothing but the final Invoice but it is based on performance 4. This is an Invoice that is Proforma, that is, it comes before the shipping is done
1. A document that shows the customer how the final Invoice might look like for the current order
Which of the following is an attribute about a person? 1. All on the list 2. Name 3. SSN 4. Salary
1. All on the list
Who makes the RFQ? 1. Customer, Purchasing 2. Supplier, Purchasing 3. Supplier, Sales 4. Customer, Sales 5. Customer, any internal
1. Customer, Purchasing
Who receives the PL? 1. Customer, Shipping dept 2. Supplier, Shipping dept
1. Customer, Shipping dept
Who makes the GRN? 1. Customer, shipping 2. Supplier, shipping 3. Supplier, purchasing 4. Customer, purchasing
1. Customer, shipping
Drew is a customer service representative and stores all of his customer information in a database.In a relational database model, what is a person, place, thing, transaction, or event about which information is stored? 1. Entity 2. Relationships 3. Attribute 4. Foreign key
1. Entity
In the relational database model, what is a person, place, thing, transaction, or event about which information is stored? 1. Entity 2. Relationships 3. Attribute 4. Foreign Key
1. Entity
When an organization combines the Procurement, Fulfillment and Production processes sharing data across from a single database, this is called an: 1. Integrated process 2. Inter-company process 3. Intra-company process 4. Inter-department system
1. Integrated process
Within the beginning stage of the data warehouse models process, which of the following are included in the internal databases? 1. Marketing, sales, inventory, and billing 2. Data mart 1, data mart 2, data mart 3 3. Competitor and industry information, mailing lists, and stock market analysis 4. marketing information, and stock market analysis numbers
1. Marketing, sales, inventory, and billing
When considering a table in a Microsoft Access database, each "row: refers to a: 1. Record 2. File 3. Data dictionary 4. Template
1. Record
When considering data in a database entity, each row is a: 1. Record 2. Data dictionary 3. Template 4. File
1. Record
In a manual, paper-based process, delays are caused due to which of the following? 1. Sending paperwork 2. Reduced cycle times 3. Creating paperwork 4. Increased inventories 5. Increased cycle times
1. Sending paperwork 3. Creating paperwork
Which of the following asks users to write lines of code to answer questions against a database? 1. Structured query language 2. Relational query language 3. Structured elements 4. Data mining tools
1. Structured query language
Some of the serious business consequences that occur due to using low-quality information to make decisions include all of the following except: 1. Success of the organization depends on appreciating and leveraging the low-quality information 2. Inability to accurately track customers 3. Inability to identify selling opportunities 4. Lost revenue opportunities from marketing to nonexistent customers
1. Success of the organization depends on appreciating and leveraging the low-quality information
Who makes the RFP> 1. Supplier, sales 2. customer, any internal 3. customer, purchasing 4. supplier, purchasing
3. customer, purchasing
Cathy is explaining where integration occurs between their basic business processes. Which of the following statements about an integrated process are TRUE? 1. The fulfillment process continues when the finished products become available 2. The fulfillment process is suspended when the needed raw materials are not available 3. The production process is suspended when the need raw materials are not available 4. The process is triggered by a customer order 5. The production process continues when the finished products become available
1. The fulfillment process continues when the finished products become available 3. The production process is suspended when the need raw materials are not available 4. The process is triggered by a customer order
What is the business purpose of SO? Name any 3
1. Unique SO#: unique order identifier 2. Convert PO to your language, meter>feet 3. Uniform layout with info for each dept. 4. Have an execution plan (action plan) 5. Special notes for internal departments
A(n) _____________ is an organized collection of related data. 1. database 2. forum 3. table 4. DBA
1. database
Query by example: 1. is a technique that uses templates to retrieve and display data from a database 2. is a language for manipulating the contents of a database 3. is a technique to graphically display relationships among entities 4. is a technique to generate print-outs of customized database reports
1. is a technique that uses templates to retrieve and display data from a database
What is an SO? 1. it converts the PO for internal departments to understand and coordinate work 2. It is a document created to specify special order requirements 3. It is the sales officer who will be dealing with the order from the customer 4. An SO is made for internal records of the sales department
1. it converts the PO for internal departments to understand and coordinate work
The process of retrieving and displaying data from a database is called: 1. query 2. a removal 3. an extraction 4. a filtration
1. query
Who makes the PO? 1. Supplier, sales 2. Customer, sales 3. Supplier, purchasing 4. Customer, purchasing
4. Customer, purchasing
What is a PR? 1. A document from the purchasing dept specifying the products/ services needed from a supplier in a proposal 2. A document from any internal dept that informs the purchasing dept about their need of products/ services, requesting a purchase 3. A document made by the purchasing officer that lists the items they need to buy from the suppliers 4. A document from the customer requiring the suppliers to submit a proposal for a project
2. A document from any internal dept that informs the purchasing dept about their need of products/ services, requesting a purchase
When could you expect a PO? 1. Before RFP 2. After a PR 3. After LC 4. Before a PR
2. After a PR
When could you expect a PR? 1. After the LC 2. Before a PO 3. Soon after the RFI 4. Before an RFP 5. After a PO
2. Before a PO
What are rules that help ensure the quality of information? 1. Information integrity 2. Integrity constraints 3. Information quality 4. Information ethics
2. Integrity constraints
Which of the following focuses on how individual users logically access information to meet their own particular business needs? 1. Physical view 2. Logical view 3. Data mart view 4. Data view
2. Logical view
What is a collection of related data elements? 1. Field 2. Record 3. Key 4. Table
2. Record
Who receives the PO? 1. Customer, Sales Dept 2. Supplier, Purchasing Dept 3. Customer, Purchasing Dept 4. Supplier, all internal Dept
2. Supplier, Sales Dept
Who makes the Invoice document? 1. Customer, sales 2. Supplier, accounting 3. Customer, accounting 4. Supplier, purchasing
2. Supplier, accounting
Who makes the Proforma Invoice? 1. Customer, sales 2. Supplier, accounting 3. Supplier, purchasing 4. Customer, accounting 5. Customer, purchasing
2. Supplier, accounting
Who receives the SO? 1. Customer, all internal 2. Supplier, all internal 3. Supplier, sales 4. Customer, sales 5. Supplier, purchasing
2. Supplier, all internal
Spot the term that is NOT similar 1. Client 2. Vendor 3. Customer 4. Buyer
2. Vendor
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. Receive shipment from vendor 2. authorize production 3. create sales order 4. create purchase order
2. authorize production 3. create sales order
Which of the following creates, reads, updates, and deletes data in a database while controlling access and security? 1. database element 2. database management system 3. data governance 4. data file
2. database management system
What is composed of rows and columns that represent an entity? 1. field 2. table 3. key 4. record
2. table
What is an LC? 1. This is the list of creditors prepared by the Accounting dept to make sure the customers pay on time 2. This is the citation or penalty levied by the customer on the supplier for delayed delivery, as per terms of payment 3. A bank document from the customer that allows the supplier to take payment directly from the bank based on proof of shipment 4. This is a list of corrected items given by the supplier to the customer in cases where the PO had errors
3. A bank document from the customer that allows the supplier to take payment directly from the bank based on proof of shipment
Which of the following is correct in reference to a database? 1. A database can support only one logical view 2. A database can support many physical views 3. A database can support many logical views 4. A database can support up to 3 logical views
3. A database can support many logical views
When could you expect a DO? 1. Before the LC 2. Soon after the GRN 3. Before shipping 4. Soon after the RFI 5. Immediately after the BG
3. Before shipping
Which of the following will enforce business rules vital to an organization's success and often require more insight and knowledge than relational integrity constraints? 1. Quality business constraints 2. Critical web constraints 3. Business critical integrity constraints 4. Web integrity constraints
3. Business critical integrity constraints
Spot the term that is NOT similar 1. Vendor 2. Supplier 3. Buyer 4. Seller
3. Buyer
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? 1. Post goods issue 2. Create outbound delivery 3. Create transfer order 4. Create transfer request 5. Create invoice
3. Create transfer order 4. Create transfer request
Who makes the PR? 1. Supplier, and internal 2. Customer, purchasing 3. Customer, any internal 4. Supplier, purchasing 5. Supplier, any internal
3. Customer, any internal
Who makes the LOI? 1. Supplier, purchasing 2. Supplier, any internal 3. Customer, purchasing 4. Supplier, sales 5. Customer, sales
3. Customer, purchasing
What is a technique for document the entities and relationships in a database environment? 1. Relational database model 2. Database 3. Entity-relationship diagram 4. data model
3. Entity-relationship diagram
Which of the following is true in regards to the elimination of redundant data? 1. Uses additional hard disk space 2. Makes performing information updates harder 3. Improves information quality 4. All of the above
3. Improves information quality
Which of the following is a disadvantage of database-stored information? 1. Increased flexibility 2. Increased performance 3. Increased data redundancy 4. Increased data integrity
3. Increases data redundancy
What is an RFI? 1. It is the suppliers returning information to the customers about their products/ services that best match customer needs 2. It is a request from the customer for more instructions on how to use the product/ service that is being provided by the supplier 3. It is a request to the supplier for more information about products/ services to help the customer decide what products/ services best fit their needs 4. It is the customers returning information to the supplier about their specific needs and situation
3. It is a request to the supplier for more information about products/ services to help the customer decide what products/ services best fit their needs
Which of the following is not an example of an advantage to using the Web to access organizational databases? 1. Web browsers are much easier to use than a computer based database 2. The Web interface requires few or no changes to the database model 3. It is cleaner and virus-free 4. It costs less
3. It is cleaner and virus-free
What is a DO? 1. It is a customer order that has distinct characteristics that need a different business process than usual 2. It is the delivery offer made by various competing transporters to ship at the lowest possible price 3. It is the Accounting dept giving a go-ahead signal to the shipping dept to proceed with shipping out the goods 4. It is a special order from a regular customer that is routed directly to the shipping dept
3. It is the Accounting dept giving a go-ahead signal to the shipping dept to proceed with shipping out the goods
What is a DI? 1. This is the transporter telling the supplier about how they Intend to Deliver the goods, such as the transportation route and number of shipments 2. This is a shipping dept's master plan on how they intend to distribute the goods to the customers, including standard routes and number of shipments 3. 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 4. This is the information given by the customer on how the goods need to be shipped to them, including the shipping route and number of shipments preferred
3. 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
What is an LOI? 1. A bank document from the customer that allows the supplier to take payment directly from the bank based on proof of shipment 2. A document from the customer requiring the suppliers to submit a proposal for a project 3. It is the written purchasing decision that informs a Supplier about the customer's intent to give them the PO in a few days 4. This is a list of corrected items given by the supplier to the customer in cases where the PO had errors
3. It is the written purchasing decision that informs a Supplier about the customer's intent to give them the PO in a few days
What is the purpose of a PO? 1. It is a formal document that specifies which Purchasing Officer will deal with the order from the customer 2. It is a document from the customer to help create a formal agreement to purchase goods at specified terms and conditions. 3. It orders the supplier to supply goods. The supplier has to obey this order as it is a legal document. 4. It is nothing but the customer's shopping list of products and services, given to the supplier so they can do the necessary supply.
3. It orders the supplier to supply goods. The supplier has to obey this order as it is a legal document.
What is a PL? 1. It is a list of items that were purchased by the customer and gives the order details 2. This is the list of all the products that any customer can expect from the supplier 3. It shows what is packed in the in the box and which order is being fulfilled 4. This is the list of all the payment due from the customer along with the due dates
3. It shows what is packed in the in the box and which order is being fulfilled
Which is a BAD primary key? 1. Social Security # 2. SO #: On your own SOs 3. PO#: On your Customers PO 4. PO#: On POs to your supplier
3. PO#: On your Customers PO
What is the primary tool that retrieves information and helps users graphically design the answer to a question? 1. Data mining tools 2. Structured example language 3. Query-by-example tool 4. Relational query tool
3. Query-by example tool
Which of the following systems allow users to create, read, update, and delete data in a relational database? 1. Business intelligence system 2. Informational database system 3. Relational database management system 4. Data mining system
3. Relational database management system
Master Data has all of the following characteristics, EXCEPT: 1. Stable 2. More Accurate 3. Represents Events 4. Used for Validation
3. Represents events
What includes fixed data incapable of change in the event of a user action? 1. Content creator 2. Content editor 3. Static information 4. Dynamic information
3. Static information
Who makes the SO? 1. Customer, sales 2. Customer, purchasing 3. Supplier, sales 4. Supplier, purchasing
3. Supplier, sales
Spot the term that is NOT similar 1. Purchasing 2. Procurement 3. Vending 4. Buying
3. Vending
What is a foreign key? 1. A foreign key of one table that appears as an entity in another table and acts to provide a logical relationship between the two records 2. A table that uniquely identifies a given record in a field 3. A field that uniquely identifies a given record in a table 4. A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables
4. A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship between the two tables
A database maintains information on ___________. 1. Inventory 2. Transactions 3. Employees 4. All of the above
4. All of the above
Which of the following statements is accurate? 1. A typical business may have hundreds of business rules. 2. Each business rule will have entities and sometimes even attributes. 3. A correct business rule for one organization may not be correct for another organization. 4. All of the above
4. All of the above
Which of the following is a possible business rule? 1. A DVD title can have many copies 2. DVDs can be purchased by many customers 3. A customer can purchase many DVDs 4. All of these choices
4. All of these choices
When could you expect an LOI? 1. Before an RFP 2. Soon after the RFI 3. After the LC 4. Before a PO 5. After a PO
4. Before a PO
Which of the below is not an example of an advantage of using a relational database? 1. Increased information quality 2. Increased flexibility 3. Decreased information redundancy 4. Decreased information security
4. Decreased information security
What includes data that change based on user actions? 1. Content creator 2. Content editor 3. Static information 4. Dynamic information
4. Dynamic information
What is a characteristic of a table? 1. Key 2. Table 3. Record 4. Field
4. Field
PL stands for? 1. Product List 2. Payment List 3. Purchasing List 4. Packing List
4. Packing List
When could you expect a Proforma Invoice? 1. Soon after the RFI 2. Right before or after a PO 3. After the LC 4. Right before or after a PO 5. Soon after the shipment
4. Right before or after a PO
Paul works in a company where its workers complete separate functional tasks in their own departments without regard to the consequences for the other components of the process or areas in the organization.Which of the following terms reflects this situation? 1. ERP Effect 2. Cross-Functional 3. Enterprise systems 4. Silo effect
4. Silo effect
When could you expect an LC? 1. Soon after the shipment 2. After a PR 3. Before a RFP 4. Soon after a PO 5. Immediately after the RFP
4. Soon after a PO
Who makes the PL? 1. Supplier, purchasing 2. Customer, shipping 3. Customer, purchasing 4. Supplier, shipping
4. Supplier, shipping
What are the two different categories for information type? 1. Analytical and productive 2. Analytical and analysis 3. Transactional and productive 4. Transactional and analytical
4. Transactional and analytical
Which of the following is a type of attribute? 1. Null-valued attribute 2. Single-valued attribute 3. Multi-valued attribute 4. all of these
4. all of these
Which of the following represents a reason an organization might encounter low-quality information? 1. Online customers intentionally enter inaccurate information to protect their privacy. 2. Different systems have different information-entry standards and formats. 3. Third-party and external information contains inaccuracies and errors. 4. all of these
4. all of these
What is data redundancy? 1. Duplication of data 2. Storing the same data in multiple places 3. Storing duplicate data in multiple places 4. all on the list
4. all on the list
Who makes the DI? 1. Customer, sales 2. Supplier, any internal 3. Supplier, accounting 4. Customer, purchasing 5. Supplier, shipping
5. Supplier, shipping
Invoice means
A bill
PR stands for?
Purchase requisition
Who creates the PR?
Customer, end-user dept, not purchasing
DO stands for?
Delivery Order
DI stands for?
Delivery instructions
Letter of credit is given by a company to?
LC is given to supplier, sales or accounting
LC stands for?
Letter of Credit
LOI stands for?
Letter of Intent
What is the business process of LOI?
Promise the supplier that the PO will be sent to them
PO stands for?
Purchase Order
What documents precedes an RFQ? Who makes it?
RFI Customer-Purchasing/End user dept.
RFI stands for?
Request for Information
RFQ stands for?
Request for Quotation
RFP stands for?
Request for proposal
What does the response to RFP consist of and what is its business purpose?
Response to RFP is the 'proposal' it consists of the techno-commercial offer: - detailed technical - detailed commercial
So stands for?
Sales order
Who receives the RFP?
Supplier, Sales
Who receives the GRN?
Supplier, Shipping