Question 1

In a database, the template for a record is referred to as a record ______.​

Accepted Answer

type​

Question 2

__________ is a data analysis technique used by decision makers to quickly get answers to complex queries that encompass multiple factors, such as locations, revenue, time periods, and employee status.​
A)​SQL
B)​OLAP
C)NoSQL​
D)​TPS

Accepted Answer

OLAP (Online Analytical Processing) enables decision makers to analyze multidimensional data from different perspectives quickly. It can retrieve and display data in the form of hierarchical structures, such as trees or cubes, and helps decision-makers with a better understanding of their organizations' performance by allowing them to slice and dice data along different dimensions easily. SQL (Structured Query Language) is a language used for managing and querying relational databases, whereas NoSQL is a database management system that does not rely explicitly on a relational data model. TPS (Transaction Processing System) is a system that processes day-to-day transactions of an organization.

Question 3

Which of the following is not one of the main activities associated with operational databases?​
A)​Collect, store, and view data
B)​Update and find data
C)​organizing and distributing data
D)​providing an executive dashboard for decision makers

Accepted Answer

Providing an executive dashboard for decision makers is more associated with a business intelligence system rather than an operational database. The main activities associated with operational databases include collecting, storing, viewing, updating, finding, organizing, and distributing data to support day-to-day business operations.

Question 4

Access to databases is usually open to anyone within an organization or business.​

Accepted Answer

Access to databases is typically restricted and granted only to authorized personnel within an organization or business, in order to maintain confidentiality and protect sensitive information.

Question 5

A(n) __________ file consists of a single, two-dimensional table of data elements.​

Accepted Answer

The answer of A(n) __________ file consists of a single,...

Question 6

A(n) _________ database is used to collect data that will be used for spotting trends that offer insights for tactical and strategic business decisions.​
A)​relational
B)​operational
C)​analytical
D)​non relational

Accepted Answer

Analytical databases are specifically designed to collect and analyze large amounts of data from various sources in order to identify patterns and trends. This enables businesses to make informed strategic decisions and gain insights into customer behavior, market trends, and other critical factors that impact their operations. Relational databases, on the other hand, are focused on managing structured data and supporting day-to-day business operations, while operational databases are used to manage transactional data in real-time. Non-relational databases are typically used for storing unstructured or semi-structured data, such as social media posts or sensor readings.

Question 7

A(n) ___________ file uses a uniform format to store data for each person or thing in the file.​

Accepted Answer

The answer of A(n) ___________ file uses a uniform format...

Question 8

Data _________ refers to computer algorithms that analyze information to discover previously unknown and useful information, including relationships and patterns.​
A)​analytics
B)OLAP​
C)mining​
D)​model

Accepted Answer

Data mining is the process of using computer algorithms to extract useful information and knowledge from large sets of data. It involves the application of various analytical techniques to uncover hidden patterns, relationships, and insights that can be used to make better decisions. OLAP and analytics are related to data processing and analysis, but they do not focus specifically on discovering previously unknown and useful information like data mining does. A model is a simplified representation of a system or process used to facilitate understanding or prediction. While models can be used in data mining, the term itself does not refer specifically to the process of discovering new information from data.

Question 9

It is not possible to extract analytical data from operational databases.​

Accepted Answer

It is possible to extract analytical data from operational databases using data warehousing and data mining techniques. However, it is not advisable to perform complex analytical queries on operational databases as it can slow down the system and affect day-to-day operations.

Question 10

A record that contains data is referred to as a record ________.​
A)​occurrence
B)type​
C)​template
D)file​

Accepted Answer

A record occurrence refers to a specific instance of data within a database or record file. It is a single set of related data values that correspond to a unique identifier or key within the file. The other choices are not accurate definitions of a record that contains data.

Question 11

Decision makers can access analytical databases using an executive __________.​

Accepted Answer

The answer of Decision makers can access analytical databases using...

Question 12

A(n) _________ database is used to collect, modify, and maintain data on a daily basis.​
A)​non relational
B)​operational
C)​relational
D)​analytical

Accepted Answer

Operational databases are designed to manage day-to-day operations of an organization, such as transactions, processing, and querying of data in real-time. They are optimized for speed, reliability, and availability, and are typically used by employees across departments and functions to access and update data as needed. Relational databases are also commonly used for operational purposes, but not all operational databases are necessarily relational. Non-relational databases, also known as NoSQL databases, are often used for analytical purposes, such as data warehousing and business intelligence. Analytical databases are designed to support complex data analysis and reporting, rather than daily operations.

Question 13

One of the ways that databases are classified is by their structure.​

Accepted Answer

Databases can be classified based on their structure, such as hierarchical, network, relational, or object-oriented.

Question 14

A filing cabinet full of folders and papers would be classified as a structured file because every document has a unique structure.​

Accepted Answer

A filing cabinet full of folders and papers is considered unstructured data because it does not follow a specific, predefined data model and is not easily searchable or organized in a structured database format.

Question 15

In a database, a(n) ____________  refers to a collection of data fields.​

Accepted Answer

The answer of In a database, a(n) ____________  refers to...

Question 16

In its broadest definition, a ____________ is a collection of information.​

Accepted Answer

The answer of In its broadest definition, a ____________ is...

Question 17

The underlying structure of a database is referred to as a database _________.​

Accepted Answer

The answer of The underlying structure of a database is...

Question 18

Rather than deleting old data, it can be moved to a data __________.​

Accepted Answer

The answer of Rather than deleting old data, it can...

Question 19

__________ refers to a branch of data mining that analyzes current and historical data to predict future trends.​
A)​Predictive analytics
B)​OLAP
C)​Data warehouse
D)​TPS

Accepted Answer

Predictive analytics is exactly what is being described in the question, analyzing past data to predict future trends. OLAP and data warehouse are related to storing and accessing large sets of data, while TPS (transaction processing system) is used to process and store everyday transactions.

Question 20

​In a database, a(n) __________ contains the smallest unit of meaningful information
A)​record
B)field​
C)​table
D)​model

Accepted Answer

A field contains the smallest unit of meaningful information in a database. It represents an individual item within a record, such as a person's name or address. Records are made up of multiple fields, and tables are made up of multiple records. A model is a representation of the structure of the database.

Quiz 10: Data Management

In a database, the template for a record is referred to as a record ______.​

__________ is a data analysis technique used by decision makers to quickly get answers to complex queries that encompass multiple factors, such as locations, revenue, time periods, and employee status.​

Which of the following is not one of the main activities associated with operational databases?​

Access to databases is usually open to anyone within an organization or business.​

A(n) __________ file consists of a single, two-dimensional table of data elements.​

A(n) _________ database is used to collect data that will be used for spotting trends that offer insights for tactical and strategic business decisions.​

A(n) ___________ file uses a uniform format to store data for each person or thing in the file.​

Data _________ refers to computer algorithms that analyze information to discover previously unknown and useful information, including relationships and patterns.​

It is not possible to extract analytical data from operational databases.​

A record that contains data is referred to as a record ________.​

Decision makers can access analytical databases using an executive __________.​

A(n) _________ database is used to collect, modify, and maintain data on a daily basis.​

One of the ways that databases are classified is by their structure.​

A filing cabinet full of folders and papers would be classified as a structured file because every document has a unique structure.​

In a database, a(n) ____________ refers to a collection of data fields.​

In its broadest definition, a ____________ is a collection of information.​

The underlying structure of a database is referred to as a database _________.​

Rather than deleting old data, it can be moved to a data __________.​

__________ refers to a branch of data mining that analyzes current and historical data to predict future trends.​

​In a database, a(n) __________ contains the smallest unit of meaningful information

In a database, the template for a record is referred to as a record ______.

__________ is a data analysis technique used by decision makers to quickly get answers to complex queries that encompass multiple factors, such as locations, revenue, time periods, and employee status.

Which of the following is not one of the main activities associated with operational databases?

Access to databases is usually open to anyone within an organization or business.

A(n) __________ file consists of a single, two-dimensional table of data elements.

A(n) _________ database is used to collect data that will be used for spotting trends that offer insights for tactical and strategic business decisions.

A(n) ___________ file uses a uniform format to store data for each person or thing in the file.

Data _________ refers to computer algorithms that analyze information to discover previously unknown and useful information, including relationships and patterns.

It is not possible to extract analytical data from operational databases.

A record that contains data is referred to as a record ________.

Decision makers can access analytical databases using an executive __________.

A(n) _________ database is used to collect, modify, and maintain data on a daily basis.

One of the ways that databases are classified is by their structure.

A filing cabinet full of folders and papers would be classified as a structured file because every document has a unique structure.

In a database, a(n) ____________ refers to a collection of data fields.

In its broadest definition, a ____________ is a collection of information.

The underlying structure of a database is referred to as a database _________.

Rather than deleting old data, it can be moved to a data __________.

__________ refers to a branch of data mining that analyzes current and historical data to predict future trends.

In a database, a(n) __________ contains the smallest unit of meaningful information