Databases

Which of the following is an example of what an information policy could specify?

-A large corporation grants access to salary information to the direct supervisors of employees and to members of the Human Resources department who administer payroll. -A user agreement on a website indicates that it will store the browsing history linked to the IP address for an indefinite amount of time and reserves the right to sell that information to interested parties. -A health insurance company stores data that patients self-report as inputs on its website, but does not link that data with information about the patient's search history.

Which of the following sets of characteristics specifically apply to relational databases?

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

Which of the following tasks can businesses perform with the help of in-memory computing?

-Alerting online customers that the desired item is out of stock, before the order is placed -Mapping alternate driving routes to help truckers avoid bad weather and traffic jams -Predicting the impact of news on stock prices and conducting immediate transactions

What characteristics do entities in a database typically have?

-Often are represented by nouns -Define people or objects that store data

Why is it important for all organizations, no matter how small, to create and implement organizational information policies?

Organizational data are a critical asset; it is important to ensure its security.

In the relationship shown in the image, the Owners table is linked to the Pets table by a one-to-many relationship. This means that each entry in the OwnerID field can be linked to many ___.

Pets

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

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

Which of the following would be a reason why an organization would use web usage mining?

-An e-commerce business looking to improve the customer experience on its website to boost sales wants to know what types of sites users go to after visiting their website and putting items in their cart, but not completing a purchase. -An e-commerce business looking to improve the customer experience on its website to boost sales wants to know what types of sites users go to after visiting their website and putting items in their cart, but not completing a purchase.

Select the two statements that correctly explain the roles of data marts and data warehouses in a decision support system (DSS).

-Data marts are used to analyze recent data that a department needs for operational troubleshooting and management, because they collect and measure data specific to that area. -Data warehouses are used to analyze long-term, historical data for an organization's strategic purposes, because they store data from different time periods and subject areas.

Which of the following is a task that data administration would be responsible for?

-Deciding that the organization will begin collecting and storing users' locations upon the release of the next generation software for its mobile app. -Defining policies stating that employees may not share data with people who are not employees of the organization. -Determining that two-factor identification must be used to access data that the company has determined to be confidential.

Which of the following is an example of an organization analyzing predictive behavior with the goal of creating new offerings?

-Netflix tracks what users who viewed all three seasons of Stranger Things also had in their queues. -An in-home healthcare provider tracks the hospital readmission rates of elderly people who live alone after they received care for falling in their homes.

Which of the following are primary goals of database normalization?

-Reduce data redundancy -Maintain data consistency -Avoid anomalies during database operations

Which of the following statements correctly describes referential integrity?

-Referential integrity applies to data quality within the structure of a relational database. -For referential integrity to exist, data on both sides of the table relationship must be present.

From the following list, select all of the examples of a relationship that an entity-relationship diagram (ERD) could be used to describe.

-The courses a student is taking -The employees who report to a specific manager in an organizational chart -Products a customer has ordered

In which of the following scenarios is denormalization beneficial?

-Where data retrieval speed is prioritized -In data warehousing scenarios

Which of the following is an example of an advantage of being able to access a database via the web?

-Your company needs suppliers in all countries to be able to access your inventory database. -Your product is primarily sold in developing countries where most of your suppliers are small business owners who access the Internet via a mobile device instead of a computer. -Turnover among telephone customer service representatives at your company is high and they receive only brief training before they interact with customers. Reps need to be able to access your sales database to assist customers who call.

In analyzing transactions, Walmart discovered that many people who buy Children's Tylenol in their stores also buy orange juice in the same transaction. They used this information to discount Children's Tylenol but raised the price of orange juice during flu season. What is the name of the approach Walmart used to discover this information?

Big data

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

Data Type

Which of these steps in the data mining process most likely involves the actual "mining" or "Knowledge Discovery in Data"?

Data gathering and preparation

Which statement best summarizes how organizations use data warehouses?

Data warehouses are used to store data from multiple sources for collective analysis.

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 is not considered an entity in a university database?

Lecture Times

Which database design strategy is likely to be used where transaction integrity is critical?

Normalization

In the datasheet view of a relational database (such as Microsoft Access), a row of information is called a ___ .

Record

A link between tables in a relational database that defines how the data are related is called a _____.

Relationship

For which task is a data mart more useful or appropriate than a data warehouse?

Resolving a current problem with a specific type of inventory, purchase transaction, or supply chain

DBMS stands for Database Management

Systems

Which statement best summarizes how a data governance (DG) plan is created?

The plan is tailored to the organization's specific goals, objectives, and activities.

Where would you click to switch to the Design view?

View

A corporate sales organization is hosting its annual regional meeting. It needs to book a hotel within the region where attendees will stay for three days and two nights. The hotel must have: 30 standard hotel rooms for its sales reps, 5 suites for the regional managers, and 5 conference rooms to hold training sessions. There also must be two restaurants within walking distance of the hotel that can accommodate a dinner reservation for 40 people. Which web mining technique would the organization use to narrow down the choices of hotels to those that fit these parameters?

Web content mining

Data mining is best described as ______.

a research and analysis technique in which data analysts employ mathematical tools and artificial intelligence (AI) to search large volumes of data and discover less-obvious patterns and trends

Referential integrity states that structural relationships in relational databases must ______.

be consistent: a foreign key field that references a primary key field must agree with that primary key

Organizing data so that data are in simple tables without any redundancies is known as __________.

data normalization

To create a relationship between two tables, it is necessary to create a __________ key in one table that is the primary key of the other table.

foreign

Organizations perform data quality audits in order to ______.

gain an overall assessment of the strengths and weaknesses of their data

The primary purpose of a business intelligence (BI) system is to ______.

help a business make strategic decisions based on its own data

Businesses use business intelligence (BI) systems to ___.

help them make decisions that are informed by business data and facts

Businesses can use in-memory computing to conduct or support almost any task that ______.

involves the near-instantaneous processing and analysis of huge volumes of data

The Important goals of data governance (DG) are to ______.

protect data from risk, misuse, regulatory noncompliance, and quality and cost issues

Analytic platforms are designed to ______.

quickly gather and analyze specific organizational data to provide information that guides decision making

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

record