MIS 301 Exam 2 study set

Which of the following is not an aggregate function in SQL?

-Count
-Ave
-Sum
-Min
Click the card to flip 👆
1 / 15
Terms in this set (15)
Which of the following is not an aggregate function in SQL?

-Count
-Ave
-Sum
-Min
2
Customers who owned Nintendo's 8-bit video game console were unable to play the same games on the firm's new 16-bit Super Nintendo system. There was little incentive for existing Nintendo fans to stick with the firm. In this case, Nintendo's new offering suffered from a lack of:

-Backward compatibility
-Staying power
-Effective Pricing
-Network effects
-Switching costs
1
Social networks are a hothouse for "__________" media, where enthusiast-consumers can help spread the word about products and services.

-Owned
-Earned
-Mainstream
-Paid
2
The wisdom of crowds concept is based on the belief a group of experts is always correct in its assessment of a problem.

-True
-False
2
Viral promotion involves:

-Offering rebates and incentives to customers for adopting a product or service
-Paying celebrities to use a product visibly to lure customers into unwittingly buying the product
-Paying celebrities to use a product visibly to lure customers into unwittingly buying the product
-None of the listed
4
A prediction market involves:

-Polling a diverse crowd and aggregating opinions to form a forecast of an eventual outcome
-Making calculated estimates on the prices of goods and services based on the speculation of a group of experts
-Leveraging customers to virally promote a firm's products or services
-Aggregating the opinions of a specialized group of experts who analyze a problem and suggest solutions
1
A firm can spend no money and time, yet expect to enhance its offerings by:

-Outsourcing critical processes to third parties
-Going public through an initial public stock offering
-Adopting an envelopment strategy
-Allowing other firms to contribute to its platform
4
The video game console market offers important lessons for the strategist. The video game console market is a network market in which Sony's Playstation 2 dominated over Microsoft's Xbox offering. This has been possible due to:

-The low pricing of Xbox which eroded users' confidence in the product
-Game developers favoring PS2 for its larger user base obtained because the PS2 was launched months before the Xbox
-The straddling strategy adopted by Microsoft to expand in both video game and DVD player markets
-The presence of several cheap, rival imitations which ate into Xbox's market share
2
Which statement best describes the relationship between network effects and innovation?

-More often than not, network effects limit innovation
-More often than not, network effects foster innovation
-Network effects decrease innovation within a standard but increase the number of innovative offerings that compete against a strongly established standard
-Network effects increase innovation within a standard but decrease the number of innovative offerings that compete against a strongly established standard
-Network effects and innovation do not affect one another
4
A blue ocean strategy often works best when combined with operational effectiveness

-True
-False
2
Two distinctly separate markets are said to undergo convergence when they: -Are characterized by many buyers, but a single, dominant seller -Offer products and services designed to target a specific industry -Begin to offer similar features and capabilities -Are dominated by a small group of powerful sellers -Derive most of their value from two distinct categories of participants3A professional or student looking for guidance with a programming problem is likely to best be served by posting questions to: -Snapchat -Twitter -Orkut -Stack Overflow -Whatsapp4Which of the following factors is responsible for enabling the advance of Moore's Law? -With the exponential growth in information technology-enabled businesses, the demand for computers makes Moore's Law possible -The distance between pathways inside silicon chips gets smaller with each successive generation -The availability of better cooling technologies ensures chips can continue growing smaller and more power-efficient -Silicon is commonly available in the form of sand or silicon dioxide, which helps keep the costs of chip production low2Electronic waste is expected to decrease with the rise of living standards worldwide -True -False2Bitcoin transactions are recorded in a public ledger known as blocks -True -False2