Business Information Systems Test 2

Which of the following statements about the revenues of global e-commerce companies are correct?

Amazon has had revenues of over $280 billion, JPMorgan Chase has posted revenues of $209 billion

According to eMarketer, what are among the most popular B2C sites in the United States? More than one answer may be correct.

Amazon, HP

Describe how business-to-consumer (B2C) transactions work

Business-to-consumer (B2C) e-commerce is the selling of products and services to individual consumers.

Which of the following statements are correct?

The United Kingdom saw e-commerce sales totaling over $142 billion in 2019.

Which of these companies are leaders in the re-commerce market?

Yerdle Re-commerce, The RealReal, Re-maker

Using a Database Management System (DBMS) increases data security by using ________ so that only authorized users can access data.

access rules

Data governance policies help to ensure an organization's data is valid, understandable, complete, and ________.

accessible

Data integrity means the database is reliable, ________, and aligned to the goals of the organization.

accurate

A record is a ________ of related fields in a data file.

collection

The data mining process includes knowledge deployment, ________, ________, and ________

data dumping

A database management system (DBMS) is a computer program that is used to create, process, and administer a ________.

database

A dependent data mart is constructed from ________ warehouses and utilize a top-down approach where organizational data is stored in a centralized location. Specific data is extracted when an analysis is needed.

existing

Data transformation is the process of converting the _____ of data.

format

When multiple lists and data integrity. sources are maintained, information can become ________, leading to decreased data

inconsistent

Data centralization is critical for increasing data ________.

integrity

An online photo printing company can temporarily lose its e-commerce ubiquity if

its website crashes due to a coding error or attack by hackers.

A database relationship is a(n) ________ between tables that define how the data are related.

link

Relational databases use ________ called relationships between tables.

links

Traditional file systems use ________, files, and documents.

paper

A ________ is also known as a question. A request for information from a database.

query

A common SQL term used in queries is FROM. FROM allows the user to choose the _____ of the database in which the query is located.

table

A query can filter data based on specific ________ also known as ________.

tables, reports

When selecting the right data, it is important to be aware of the source of the data. For example, data that is sold by an entity that didn't actually collect the data is considered ______ data.

third-party

The essential RDBMS functions; create, read, update, and delete data is collectively referred to as which acronym?

CRUD

Referential integrity is the ________ and ________ of data within a table relationship in a database.

Development, relationship

Of the following statements, choose the ones that correctly apply to issues in m-commerce.

Ethical issues include keeping product listings accurate, following online selling laws, and maintaining web accessibility.

In order to be considered open data, databases must provide access rights so that they can be

Redistributed

Common database field names for a Members table would include which fields?

ShortText

Commonly used techniques to gain information in web mining include ________, ________,and ________.

WEM

Built on real-time geodata and information provided from wireless mobile devices, ________ are widely used in m-commerce.

location-based services (LBS)

E-commerce transactions that are executed using wireless mobile devices are known as

m-commerce.

Qualitative data that is not categorized is called nominal data. Qualitative data that is categorized(ranked, for example) is considered _____ data.

ordinal

E-commerce ________ includes creating marketing messages that contain the individual's name, appeal to his/her interests, and take their purchase behavior into account.

personalization

When data is anonymized, the PII is eliminated or encrypted. PII includes names, Social Security numbers, addresses, and more and stands for ______ identifiable information.

personally

The organizations likely to benefit the most from the global reach of e-commerce are those that

previously depended on foot traffic into one physical store to sell their products.

A ________ key must contain a unique value.

primary

To set a primary key field in a database table, you must click the ________ key button.

primary

SQL, usually pronounced "sequel," is quite useful when working with large data sets. The Q in SQL stands for

query

Collections of related fields in a database are referred to as

records

OLAP is used to support businesses in a wide range of areas including ________.

software downloads

Business-to-government (B2G) transactions often are executed according to guidelines and specifications included in a legal contract. B2G contracts are often executed at which levels of government? More than one answer may be correct.

state, local, and individual level

SQL allows users to isolate specific information contained in a database, as well as to aid in the selection, creation, addition, and extraction of data from a database. SQL stands for ______ query language.

structured

E-commerce ________ is the ability of an organization to create a strong presence among consumers in many places, with minimal time constraints, to sell them products and services.

ubiquity

________ involves identifying errors in data sets and removing/correcting these errors to ensure the data is accurate.

Data scrubbing

SoSQL (non-relational databases) are also useful for querying the data generated by ________ sites, ________ apps, and other emerging digital content sources.

Google, Amazon

To remain relevant in today's e-commerce landscape, many businesses use progressive ________ applications to undertake m-commerce.

web

It is especially important for startup companies to create and follow a well-designed e-commerce strategy. Which of the following is the first phase in a well-designed strategy?

web planning

One of the ways web mining improves web experiences is through site visibility. Site visibility includes how and ________ the website appears when queries are executed in a search engine.

when

One of the ________ of data warehouses is their ability to provide access and analysis of information from a variety of subject areas.

advantages

Someone who possesses the knowledge of processing software, business strategy, and analytical skill to deliver data and reports that guide management and executives as they create well informeddecision making is known as a data

analyst

The Foreign Key is a ________ field between tables that is not the primary key.

common

Online marketplaces where one consumer sells to another consumer are called

consumer-to-consumer (C2C).

The key goals of data governance include rules for data use, requirement compliance, high-quality data, and _________.

cost reduction

Saraiya runs a small café. She would like to start placing small ad buys on social media and hires an analytics firm to determine which platforms she should advertise on. What type of cost would this be considered?

customer acquisition cost

A cloud database infrastructure integrates computer hardware and operating system in an internet-based ________.

datacenter

Data redundancy is the ________ of data.

duplication

Common issues that e-commerce businesses face include

threats to customer data, unstable customer loyalty.

M-commerce is a subset of

traditional e-commerce.

Which of the following are areas that are covered on an e-commerce presence map? More than one answer may be selected.

type of presence, the platform, the activity

Online content that has been created and posted by unpaid contributors such as customers or fans of a product or service is referred to as

user-generated

It is especially important for startup companies to create and follow a well-designed e-commerce strategy. Which of the following is the last phase in a well-designed strategy?

mobile platform planning and implementation

A cost-benefit analysis is a useful tool used to analyze the costs associated with implementing a project or set of activities and the benefits that can be achieved as a result of the implementation. Which of the following would be considered benefits when conducting a cost-benefit analysis? More than one answer may be selected.

potential return on investment, potential costs averted, need for additional staff