Computer Test

In order to gain market share, the firm must differentiate itself from

, its competitors its competitors

Which statement explains the difference between a database and a database management system (DBMS)?

A DBMS is a software program designed to organize and administer databases.

For the past 10 years, a restaurant has been running a customer loyalty program, rewarding customers with discounts and treats. Records of these rewards have been kept in odd notes and multiple spreadsheets used in different ways by various employees who have come and gone over the years. Because of this, some customers are not getting their rewards, while others are receiving rewards they have not earned. Overall, the restaurant is losing money and business with this program. How can a database management system (DBMS) help with this problem?

A DBMS will help the owners manage the data they already have to run their customer loyalty program more efficiently.

If an increase in price results in a relatively large decrease in demand for the product, the firm cannot easily increase its profit margin. This demonstrates which of Porter's 5 forces?

Customers

What element of a database field specifies the data in a field such as text, numeric, or date/time?

Data Type

Which of the following sets of characteristics specifically apply to relational databases? More than one answer may be correct.

Data tables in a relational database are linked by the fields they have in common. A relational database organizes data in tables composed of records or objects (the rows), and fields (the columns).

Which statement most accurately describes the value of data integrity to an organization?

Databases and database management system (DBMS) with a high level of data integrity enable more efficient data maintenance in support of organizational goals.

Which statement best explains why traditional file systems have certain issues?

Each file is independent of another file in a traditional system.

Which of the following are examples of data objects that a relational database management system (RDBMS) may include? More than one answer may be correct.

Names of customers and records of when merchandise was returned Addresses of the company's wholesalers and the number of items in a company's inventory

Which of the following statements describe the capabilities of relational database management system (RDBMS)? More than one answer may be correct.

RDBMS have features that support the quality and security of data. RDBMS allow users to view, add, revise, and remove data.

Your college has a database with a Students table. Which two of the following could be a primary key in the table?

Student number Social Security Number

Apple uses Corning's glass products for all its devices, such as the Gorilla Glass 6 used in the iPhone 11 series. To ensure that it continue to have a strong relationship with this glass industry leader, Apple has invested nearly $500 million toward Corning's advanced glass research division. By building up this relationship, Apple seeks to maintain some control over which of Porter's 5 forces?

Suppliers

A mid-sized independent hardware store has recently merged with a large national chain. The local owners have long used a reliable database to manage inventory. Their database has been essential in balancing orders for seasonal merchandise with the problem of limited shelf space. The merger will soon entail managing many more types of data, as the national chain has approved lists of suppliers, precise requirements for recording transactions, specific human resources procedures, and more. Which statement best summarizes what the local managers will be able to do for the first time when they start using the parent company's database management system (DBMS)?

The managers will be able to create, edit, and store data in a secure manner across all data types required by the parent company.

Attributes that allow firms to provide goods and services with higher perceived values than their competitors are referred to as competitive

advantages

Database management system (DBMS) make it easier to secure data and information because they ______.

allow for the creation of access constraints

Management Information Systems allow managers to build upon an organization's existing strengths to create

competitive advantages competitive advantages

The ability for a firm to enjoy significant profit margins decreases as the number of offering essentially the same products or services increases.

competitors or rivals

Data integrity is increased when ______.

data are centralized

How quickly consumer demand changes with a change in price is referred to as

elasticity

In 1979, Professor Michael E. Porter published "How Competitive Forces Shape Strategy" in the Harvard Business Review. In this paper, he described factors that impact businesses. The became known as Porter's forces.

five

A database management system (DBMS) is a computer program that is used to ______.

help organize the data found in a database

According to Professor Porter, a business must differentiate itself from its competitors. One method is to encourage customers to believe that an organization provides higher quality goods or better service, then the organization can charge a premium, or gain market share, or (ideally) both. For example, by placing a swoop icon on a sweatshirt, Nike is able to charge a higher price. This methodology is called ___.

monopolistic competition

In contrast to computerized systems, traditional file management systems can create issues with ______.

organization, repetition, and lack of consistency

In a relational database, an important field that contains a unique value that identifies each record as individual is the.....key

primary

In a relational database, such as Microsoft Access, a collection of related fields in a data file is called a

record

Walmart uses economies of to pressure suppliers to lower their prices, allowing Walmart to offer lower prices to its customers and decrease competition.

scale

A relational database management system (RDBMS) is a type of DBMS whose primary function is to ______.

show how data are connected through relationships

The primary characteristic of a relational database is that it ______.

stores and allows access to data objects that are related to one another

Coca-Cola and PepsiCo dominate the soft drink market. However, during the 2000s, many customers switched from soft drinks to water, causing Coca-Cola and PepsiCo to develop Dasani and Aquafina. The ability of customers to switch from one product to an alternate product illustrates what Porter called the strength of __.

substitutes

Porter's 5 Forces include existing competitors, new competitors, and which 3 of the following?

suppliers customers substitutes

During the 1950s, the United Auto Workers union (UAW) exercised considerable control over the labor ___. This meant that automobile manufacturers had little control over labor costs.

supply

When a large number of buyers seek to purchase a firm's products even when prices increase, Porter's force of customers can be said to have ___. This tends to strengthen the firm's profitability.

weakened