Databases

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 are examples of data objects that a relational database management system (RDBMS) may include?

Addresses of the company's wholesalers and the number of items in a company's inventory

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 Predicting the impact of news on stock prices and conducting immediate transactions Mapping alternate driving routes to help truckers avoid bad weather and traffic jams

How are data marts different from data warehouses?

Data marts focus on an individual department or business function and manage less data than a data warehouse.

Which of the following statements correctly describes referential integrity?

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

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.

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

allow for the creation of access constraints

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

data normalization

web contact mining

extraction of information from web pages and documents

Organizations use data warehouses mainly to ______.

facilitate the analysis of data from multiple sources

The four steps in a data quality audit are ______.

assessment, design, transformation, and monitoring

Which of the following is an example of why a database should be accessible through the web?

A small distributor with limited staffing wants customers to be able to track the status of their orders without having to contact a customer service representative. A company has recently scaled its operations so that it competes internationally and needs business partners all over the world to have access to its database. A large portion of a company's workforce are contract workers who work offsite, using their own devices to complete their work.

Which of the following tasks are NoSQL databases designed to do?

Analyze nonstructured data Create queries from the data created from web apps Manage large datasets across different platforms

Relational database management systems (RDBMS) have a variety of tools that can be used to execute/run queries. One of these query tools is the ability to execute/run action queries. Which of the following are common types of action queries?

Append query Delete query Update query

Examples of data errors data scrubbing can resolve include:

Incorrect names and addresses Elimination of duplicate database records Misspellings in the data

What term describes the process organizations use to discover meaningful relationships and patterns among the data sets it has collected?

data mining

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

help a business make strategic decisions based on its own data

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

help organize the data found in a database

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

organization, repetition, and lack of consistency

A database provides the capability of conducting searches or asking questions. A question or search for information in a database is called a

query

To display or distribute information from a database, programmers or database administrators create ___.

reports

Why must database administrators (DBA) be trained or experienced in using an organization's specific database platform?

They must troubleshoot or solve problems with the database when necessary.

Data integrity is increased when ______.

data are centralized

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

relationship

Which of the following is a task that an SQL statement would be expected to perform?

retrieve data

The detection of errors in data sets and the correction/removal of of these mistakes to ensure an organization's data are valid is referred to as data _____ or data cleansing.

scrubbing

Where could you click to switch to the Design view?

view