Question 1

In database terminology, a record represents:
A) a list of data, arranged in columns and rows.
B) each category of data contained in a row.
C) a single instance of whatever the table keeps track of.
D) a field or combination of fields used to uniquely identify a file.
E) one or more keys that relate separate tables in a database.

Accepted Answer

A record in a database represents a single instance of whatever the table keeps track of. It is a complete set of information about one particular item, entity, event, or concept that is stored in a table. Each record is usually made up of several related values or fields that are organized into columns or fields in the table. The values in a record describe the attributes or characteristics of the entity being represented, and each field has a specific data type and size that defines the type of data it can contain. Therefore, Option C is the correct choice.

Question 2

One of the factors that complicates the elimination of legacy systems is the:
A) costs associated with breaking extended vendor or outsourcer agreements.
B) low market value for outdated hardware and software.
C) absence of regulatory mechanisms to handle the efficient disposal of legacy systems.
D) unavailability of suitable data porting methods to offset data redundancy.
E) frequency at which technology improves as per Moore's law.

Accepted Answer

Breaking extended vendor or outsourcer agreements can result in significant costs and legal issues, making it difficult to eliminate legacy systems.

Question 3

Describe "database," "DBMS," and "SQL."

Accepted Answer

The answer of Describe "database," "DBMS," and "SQL."...

Question 4

_____ are the most common standard for expressing databases, whereby tables (files) are related based on common keys.

Accepted Answer

The answer of _____ are the most common standard for...

Question 5

A _____ is a system that provides rewards and usage incentives, typically in exchange for a method that provides a more detailed tracking and recording of consumer activity.
A) sugging report
B) canned report
C) dashboard
D) legacy system
E) loyalty card

Accepted Answer

A loyalty card system provides rewards and usage incentives to customers in exchange for tracking and recording their purchasing activity, allowing businesses to gain valuable insights into consumer behavior.

Question 6

Firms that collect and resell data are known as:
A) data harvesters.
B) data mongers.
C) knowledge consultancies.
D) data miners.
E) data aggregators.

Accepted Answer

The term commonly used for firms that collect and resell data is "data aggregators." Other choices such as data harvesters, data mongers, and data miners may be used colloquially, but they are not standard industry terms. Knowledge consultancies may deal with data, but their focus is typically on providing strategic advice rather than gathering and disseminating data.

Question 7

In database systems, a row is also known as a _____.
A) table
B) column
C) key
D) record
E) field

Accepted Answer

A row in a database system is also called a record. It refers to a complete set of information about a specific entity or object, such as a customer, product, or transaction. Each record contains different fields or attributes that store various pieces of data, such as a name, address, phone number, or order date. The term "table" refers to the entire collection of records, and a column contains one specific type of data across all records, such as a price or quantity. A key is a field or set of fields that uniquely identifies each record in a table.

Question 8

Enterprise software tends to be less integrated and standardized than the prior era of proprietary systems that many firms developed themselves.

Accepted Answer

Enterprise software is actually more integrated and standardized than the prior era of proprietary systems. This is because enterprise software is designed to work together and often follows industry standards, while proprietary systems were developed in-house and may not have been designed to work with other systems.

Question 9

Systems that record a transaction (some form of business-related exchange), such as a cash register sale, ATM withdrawal, or product return are referred to as _____.

Accepted Answer

The answer of Systems that record a transaction (some form...

Question 10

_____ is a language used to create and manipulate databases.

Accepted Answer

The answer of _____ is a language used to create...

Question 11

Any data-centric effort should involve input not only from business and technical staff, but from the firm's legal team, as well.

Accepted Answer

The legal team can provide valuable input on data privacy regulations, data usage agreements, and potential legal risks related to the handling of data. It is important to have their input in any data-centric effort to ensure compliance with legal requirements and reduce the risk of legal issues arising in the future.

Question 12

_____ refers to a job title focused on directing, performing, or overseeing activities associated with a database or set of databases.

Accepted Answer

The answer of _____ refers to a job title focused...

Question 13

Briefly describe the different sources of enterprise data for firms.

Accepted Answer

The answer of Briefly describe the different sources of enterprise...

Question 14

Data obtained from outside sources, when combined with a firm's internal data assets, can give the firm a competitive edge.

Accepted Answer

By combining external data with a firm's internal data assets, the firm can gain insights and knowledge that may not have been possible with just internal data. This can lead to better decision-making, improved customer experiences, and ultimately a competitive advantage.

Question 15

_____ is the term used to describe some form of business exchange.

Accepted Answer

The answer of _____ is the term used to describe...

Question 16

If a customer pays a retailer in cash, he is likely to remain a mystery to the retailer because his name is not attached to the money. Retailers can tie the customer to cash transactions and track the customer's activity if they can convince the customer to use a _____.
A) transaction processing systems
B) point-of-sale terminals
C) data cubes
D) dashboards
E) loyalty cards

Accepted Answer

Loyalty cards are a way for retailers to tie cash transactions to individual customers and track their activity. Customers are often incentivized to use loyalty cards by receiving discounts or other benefits.

Question 17

_____ is a class of computer software that seeks to reproduce or mimic human thought, decision making, or brain functions.
A) Biometrics
B) Artificial intelligence
C) Android
D) Legacy software
E) Intranet

Accepted Answer

The class of computer software that seeks to reproduce or mimic human thought, decision making, or brain functions is Artificial Intelligence (AI). Biometrics refers to the measurement and analysis of unique physical or behavioral characteristics of an individual. Android is a mobile operating system. Legacy software refers to outdated or obsolete software that is no longer being actively maintained or updated. Intranet refers to a private network used within an organization.

Question 18

In database systems, a _____ defines the data that a table can hold.
A) row
B) key
C) record
D) file
E) field

Accepted Answer

A field defines a specific piece of data that can be stored in a table's columns. Each column in a table represents a different field.

Question 19

_____ refer to older information systems that are often incompatible with other systems, technologies, and ways of conducting business.
A) Data aggregator systems
B) Loyalty card systems
C) Legacy systems
D) Transaction systems
E) Mnemonic systems

Accepted Answer

Legacy systems are older information systems that may not be compatible with newer technologies and business practices.

Question 20

Turning data into useable information is hindered by transactional databases that are set up to be simultaneously accessed for reporting and analysis.

Accepted Answer

The answer of Turning data into useable information is hindered...

Quiz 12: The Data Asset: Databases, Business Intelligence, Big Data, and Competitive Advantage

In database terminology, a record represents:

One of the factors that complicates the elimination of legacy systems is the:

Describe "database," "DBMS," and "SQL."

_____ are the most common standard for expressing databases, whereby tables (files) are related based on common keys.

A _____ is a system that provides rewards and usage incentives, typically in exchange for a method that provides a more detailed tracking and recording of consumer activity.

Firms that collect and resell data are known as:

In database systems, a row is also known as a _____.

Enterprise software tends to be less integrated and standardized than the prior era of proprietary systems that many firms developed themselves.

Systems that record a transaction (some form of business-related exchange), such as a cash register sale, ATM withdrawal, or product return are referred to as _____.

_____ is a language used to create and manipulate databases.

Any data-centric effort should involve input not only from business and technical staff, but from the firm's legal team, as well.

_____ refers to a job title focused on directing, performing, or overseeing activities associated with a database or set of databases.

Briefly describe the different sources of enterprise data for firms.

Data obtained from outside sources, when combined with a firm's internal data assets, can give the firm a competitive edge.

_____ is the term used to describe some form of business exchange.

If a customer pays a retailer in cash, he is likely to remain a mystery to the retailer because his name is not attached to the money. Retailers can tie the customer to cash transactions and track the customer's activity if they can convince the customer to use a _____.

_____ is a class of computer software that seeks to reproduce or mimic human thought, decision making, or brain functions.

In database systems, a _____ defines the data that a table can hold.

_____ refer to older information systems that are often incompatible with other systems, technologies, and ways of conducting business.

Turning data into useable information is hindered by transactional databases that are set up to be simultaneously accessed for reporting and analysis.