MIS 304 KC Test 2

b. false

A column is a collection of related attributes about a single instance of an entity a. true b. false

e. Row; table

An "Instance" of a person matches a _______ whereas a "collection" of people matches a ________. a. Column; table b. Row; field c. Column; field d. Table; key e. Row; table

d. increases with the number of users in the network

The Network Effect refers to the notion that the value of a network a. Decreases with the number of users in the network b. Is only measurable on social networks like Facebook, Twitter, and LinkedIn c. Is driven by how new it is (newer networks are more valuable) d. Increases with the number of users in the network

b. none of the other options is correct

You want to sell a textbook from last semester online. Which e-commerce business model does this fall under? a. B2B b. None of the other options is correct c. B2C d. A2B e. G2C

e. virtual team

________ are comprised of members from different geographic areas assembled as needed to collaborate on a certain project. a. Work groups b. Non-core teams c. Command groups d. Correct Response e. Virtual teams f. Task force

d. scheduled reports

________ are produced at predefined intervals to support routine decisions. a. exception reports b. key-indicator reports c. security reports d. scheduled reports e. drill-down reports

c. slicers

to create an excel dashboard with dynamic filtering capability, you will likely use a. TRIM () b. RIGHT () c. slicers d. analytics e. none of the above

b. report

A(n) ________ is a compilation of data from a database that is organized and produced in printed format. a. field b. report c. form d. attribute e. entity

b. retrieve results from a database

A query is used to _____________ a. prevent illegal or illogical entries from entering the database b. retrieve results from a database c. add primary key constraints to a table d. all of the above e. none of the other options are correcr

b. false

BestBuy is an example of a "Brick and Mortar" only business a. true b. false

c. search engine optimization

Companies use ________ in an attempt to move up their Web sites in the organic search engine results. a. search engine keyword insertion b. search-oriented architecture c. search engine optimization d. search engine image protection e. domain stacking

c. all of the other options are correct

How does amazon use databases on their website? a. Provide product recommendations b. Advertising c. All of the other options are correct d. Populate review data e. Welcome the users

d. the database does not need to be changed if a change is made to an application

In a database management system (DBMS), data are kept separate from the applications' programming code. This means that ________. a. an application's programming code needs to be updated continuously to keep up with the database b. an application cannot be changed without making changes to the database c. the database needs to be changed when a change is made to an application d. the database does not need to be changed if a change is made to an application e. an application needs to be changed when the database is changed

e. None of the other options are correct

In context of BI, "slicing and dicing" refers to analysis using a. OLTP b. Primary key c. Foreign Key d. Clustering e. None of the other options is correct

e. none of the other options is correct

In context of BI, "slicing and dicing" refers to analysis using a. OLTP b. Primary key c. Foreign Key d. Clustering e. None of the other options is correct

a. true

Many companies have not been able to realize the full potential of a virtual world environment beyond just providing virtual showcases for their products. a. True b. False

a. monitor online consumer sentiment

Nestle's Digital Acceleration Team (DAT) was created to a. monitor online consumer sentiment b. All of the other options are correct c. respond to security breaches d. explore new product development e. develop new viral advertising campaigns

e. dictionary

Once the data model is created, the format of the data is documented in a data ________. a. Incorrect Response b. entry c. domain e. dictionary f. warehouse g. mart

c. confidence of the person asking questions

Similar to the Phone Fraud video, why do people give up their passwords in the Kimmel video? a. Two-factor authentication b. Know the person well and trust them c. Confidence of the person asking questions d. All of the other options are correct e. Viral social media effect

b. functional convenience

Recommender systems and search capability of a website fall under which of the following categories? a. structural firmness b. functional convenience c. disintermediation capacity d. representational delight e. cost compliance

e. operational

Responding to threats and opportunities and continuous planning are based on analyzing internal data primarily from the ________ level of an organization. a. executive b. business c. strategic d. tactical e. operational

e. structural firmness

Security and performance of a website fall under which of the following categories? a. cost compliance b. representational delight c. functional convenience d. disintermediation capacity e. structural firmness

a. true

Social media is a classification of Web 2.0 applications. a. True b. False

b. false

The primary use of online transaction processing (OLTP) systems is to define a set of reachable and exploitable vulnerabilities present in a database. a. True b. False

e. groupware

The term ________ refers to a class of software that enables people to work together more effectively. a. firmware b. malware c. spyware d. mashup e. groupware

d. all of the above

Virtual Teams can benefit from a. Video conferencing b. Synchronous communication c. Asynchronous communication d. All of the above e. Video conferencing + Synchronous communication

d. representational delight

Visual appeal of a website falls under which of the following categories? a. functional convenience b. structural firmness c. Correct Response d. representational delight e. cost compliance f. disintermediation capacity

a. true

Walmart is an example of a "Click and Mortar" business a. True b. False

b. false

Web 1.0 applications allow people to collaborate and share information online. a. True b. False

b. false

Web 2.0 is functionally the same as web 1.0. The 2.0 just means there are bug fixes a. true b. false

a. attribute

When we consider entities as tables, each column is a(n) ________. a. attribute b. applet c. Incorrect Response d. query e. record f. form

d. record

When we consider entities as tables, each row is a ________. a. form b. bot c. field d. record e. query

d. blogs

Which of the following Web 2.0 applications has been classified as the "amateurization" of journalism? a. chat rooms b. instant messaging c. message boards d. blogs e. discussion forums

c. organizational conflict

Which of the following is a risk associated with a database approach? a. program-data independence b. minimal data redundancy c. organizational conflict d. enforcement of standards e. reduced program maintenance

e. email

Which of the following is an example of asynchronous communication? a. electronic meeting support systems b. online chat c. shared whiteboards d. videoconferencing e. e-mail

b. videoconferencing

Which of the following is an example of synchronous communication? a. online reviews b. videoconferencing c. work flow automation systems d. e-mail e. bulletin board systems

b. they answer unplanned information requests to support a non-routine decision

Which of the following statements is true about ad hoc queries? a. They provide a summary of critical information on a recurring schedule. b. They answer unplanned information requests to support a non-routine decision. c. They help analyze why a key indicator is not at an appropriate level or why an exception occurred. d. They are produced at predefined intervals to support routine decisions. e. They highlight situations that are out of the normal range.

d. the videos are shocking

Why Is Blendtec Successful in their Marketing Videos? a. Focus on big surprises and do not make sequels b. The videos are serious and focus on drama rather than humor c. The videos/ads end with a clear call to action (i.e., how to buy) d. The videos are shocking

b. the videos are shocking

Why is Blendtec successful in their marketing videos? a. focus on big surprises and do not make sequels b. the videos are shocking c. the videos are serious and focus on drama rather than humor

a. Microsoft Outlook

________ is an example of an electronic communication tool. a. Microsoft Outlook b. Apple FaceTime c. Google Talk d. Google Docs e. Incorrect Response f. MS SharePoint

b. apple facetime

________ is an example of an electronic conferencing tool. a. MS SharePoint b. Apple FaceTime c. Google Docs d. Wikipedia e. MS Outlook

c. crowdsourcing

_____________ is used in order to have small, well-defined tasks performed by a scalable ad hoc workforce for everyday people. a. insourcing b. nearshoring c. crowdsourcing d. disinntermediation e. none of the above

c. OLTP

_______________ systems are designed to handle multiple concurrent transactions from customers a. product allocation b. yield optimization management c. OLTP d. viral marketing e. none of the other options are correct

b. false

it is impossible for a database to consist of only a single file or table a. true b. false