PLS 21 Midterm #2- STUDY GUIDE Qs

Database systems minimize ________. a. redundancy b. security c. integrity d. independence

A

A ________ is a group of eight ________. a. file; fields b. byte; bits c. bit; bytes d. field; files

B

Africa collaborated with ________ to stop the Ebola virus outbreak in 2013 and 2014. Amazon IBM Google Microsoft

B

Organizations typically invest in cloud-based ERP systems because they are _________ less error-prone less expensive more accessible more secure

B

With the ________ approach to on-premise ERP implementation, a company implements a standard ERP package using the package's built-in configuration options. as-is vanilla custom best-of-breed

B

________ is the cumulative store of subjective or experiential learning. Explicit knowledge Tacit knowledge Tacit information Explicit information

B

Considering the following tables, ________ is a primary key. Professor Table: Name Class Table: PID Student Table: ID Student Table: Expected Graduation Year

C

Data marts can be implemented ________ compared to data warehouses. at the same pace It depends on the situation. more quickly less quickly

C

Legacy systems were developed as _________. ERP Integrating systems Silos DSS

C

Most organizations design TPS to process transactions as soon as they occur. This is called _________. OLAP source data processing OLTP batch processing

C

The ________ process originates in the warehouse department and ends in the accounting department. marketing production procurement fulfillment

C

________ is an advantage of cloud-based ERP systems. Recovery Control Cost Security

C

________ is the correct evolution of POM planning. ERP ARP MRP MRP ARP ERP MRP MRP II ERP ERP MRP MRP II

C

________ refers to the maximum number of times an instance of one entity can be associated with an instance in the related entity. Modality Business rules Cardinality Data dictionary

C

You recently inherited an Alvin and The Chipmunks "A Chipmunk Christmas" record. Since you don't have a record player, you need to find a way to convert the record into a CD. This is an example of data ________. a. clickstreaming b. degradation c. scattering d. rot

D

ERP systems that include administrative, sales, marketing, and HR processes are referred to as _________. ERP II ERP III ERP I ERP IV

A

Jana is a mobile startup designed to ________. a. reward users with data in exchange for collecting their personal information when sampling apps b. offer free smartphones to people who make less than 20 cents an hour in China c. give app developers free access to other apps d. charge users less money to use mobile data than they have to pay their telecommunication company

A

Normalization is a method for analyzing and reducing a relational database to its most streamlined form to ensure ________ redundancy, ________ data integrity, and optimal processing performance. minimum; maximum maximum; maximum maximum; minimum minimum; minimum

A

SCM systems are ________ systems. interorganizational extraorganizational extraorganizational intraorganizational

A

Suppose you work for XYZ Corporation. You know you can contribute 6% of your salary to a 401K and the company will match that 100% after 6 years of service because it is in the employee handbook. This is an example of ________. explicit knowledge explicit information tacit information tacit knowledge

A

The fulfillment process originates in the ________ department and ends in the ________ department. sales; accounting warehouse; warehouse warehouse; accounting accounting; sales

A

You decide to purchase SAP but modify it to handle your specific business processes. This is an example of the ________ approach to ERP implementation. best-of-breed custom vanilla as-is

A

________ are designed to correct a lack of communication among _________. ERP; FAIS ERP; TPS FAIS; ERP FAIS; TPS

A

________ is an approach that integrates various automated factory systems. CIM TPS MRP CRM

A

________ is an extended ERP module. Supply chain management HR management Financial management Operations management

A

________ is part of the ________ process and occurs when the company is trying to increase its inventory. Make-to-stock; production Make-to-order; procurement Make-to-order; production Make-to-stock; procurement

A

________ is the most popular query language used for interacting with a database. SQL TPS RFID ETL

A

Databases ________ inconsistency; this means ________ a. minimize; the same data are stored in multiple locations b. minimize; various copies of the data do not agree c. maximize; various copies of the data do not agree d. maximize; the same data are stored in multiple locations

B

Knowledge management is a process that helps organizations manipulate important knowledge that comprises part of the organization's memory, usually in a(n) ________ format. semi-structured unstructured part-structured structured

B

________ is part of the ________ process and involves sending goods that are in the warehouse to customers. Configure-to-order; fulfillment Sell-from-stock; procurement Sell-from-stock; fulfillment Configure-to-order; procurement

C

A ________ generally describes an entity. a. file b. field c. byte d. record

D

A circle with a "chicken leg" to the entity represents the ________ cardinality symbol. mandatory single mandatory many optional single optional many

D

A transaction is any business event that generates ________ worthy of being captured and stored in a database. knowledge information wisdom data

D

A(n) ________ report summarizes the performance of critical activities. ad hoc comparative drill-down key indicator

D

All the information about you in your university's database is a(n) ________. database entity attribute instance

D

Data marts and data warehouses typically use ________. RFID ERP OLTP OLAP

D

Industry experts estimate that 80-90 percent of data in an organization is ________. structured semi-structured part-structured unstructured

D

Which of the following is NOT a problem associated with Big Data? Big Data changes. Big Data lacks quality. Big Data can come from untrusted sources. Big Data can be structured, unstructured, or semi-structured.

D

Your southern region is not doing very well. You want to know why, so you ask for a special report showing the numbers for the southern region compared to the northern, eastern, and western regions. This is a(n) ________ report. drill-down exception routine comparative

D