Question 1

Which of the following tasks is the typically a primary responsibility of a database administrator?
A) developing the data dictionary
B) data entry
C) monitoring a help line
D) hiring and training the users

Accepted Answer

Developing the data dictionary is typically a primary responsibility of a database administrator. This involves designing, creating, and maintaining a centralized database that contains metadata and other relevant information about the organization's data. Data entry, monitoring a help line, and hiring/training users may be tasks assigned to other roles in the organization.

Question 2

A replicated database is a database that holds a duplicate set of frequently used data.

Accepted Answer

A replicated database is designed to hold a copy of frequently accessed data in multiple locations to provide faster access and increased availability.

Question 3

Industrial databases are large databases that function as the cornerstone of information systems in businesses and enterprises.

Accepted Answer

Industrial databases are indeed large databases that serve as the foundation for information systems in businesses and enterprises. These databases store and manage vast amounts of data and facilitate the efficient analysis and use of this data for various business purposes.

Question 4

The output of data mining in a business setting is sometimes called ____.
A) relational data
B) business intelligence
C) a dataset
D) dynamic data

Accepted Answer

The output of data mining in a business setting is often referred to as business intelligence, as it provides valuable insights and knowledge that can be used to make informed business decisions. Relational data refers to data organized in tables with predefined relationships, a dataset is a collection of data, and dynamic data refers to data that changes frequently. None of these terms specifically describe the output of data mining in a business setting.

Question 5

Distributed databases connect data at different locations using ____ networks.
A) QBE
B) telecommunications
C) bus
D) DSL

Accepted Answer

Distributed databases use telecommunications networks to connect data at different locations, allowing for data to be easily accessed and shared between multiple locations. QBE is a query language, bus is a type of computer architecture, and DSL is a type of internet connection, none of which are directly related to the networking of distributed databases.

Question 6

Installation and the ongoing maintenance of software in a database system are the job of the database ____.
A) application
B) structure
C) administrator
D) management system

Accepted Answer

The database administrator is responsible for the installation and ongoing maintenance of software in a database system. They are in charge of managing the database's performance, security, and availability. They also monitor the system to ensure it is functioning correctly and perform backups to protect the data. The application, structure, and management system may all play a role in database operations but are not specifically responsible for software installation and maintenance.

Question 7

A database administrator is part of a team that also includes those who program and use databases.

Accepted Answer

A database administrator typically works with other roles involved in managing and utilizing databases, such as developers, analysts, and end-users. Therefore, they are part of a team that includes those who program and use databases.

Question 8

A data center is used by large organizations to store older archived data that is no longer needed on a day-to-day basis.

Accepted Answer

A data center is used to house computer systems and associated components, such as telecommunications and storage systems, and is used for the day-to-day operations of an organization, not just for storing archived data.

Question 9

As data centers continue to grow in size to multi-acre facilities,the number of employees required to run them also grows proportionally.

Accepted Answer

Despite the growth in size of data centers, advancements in automation and remote management technologies have allowed them to be operated with relatively fewer employees, focusing more on efficiency and less on proportional staff increases.

Question 10

A data ____ is a small data warehouse that is developed for a specific person or purpose.
A) capsule
B) mini
C) mart
D) center

Accepted Answer

A data mart is a small data warehouse that is designed for a specific department, function, or purpose. It typically only contains a subset of data from the larger data warehouse and is optimized for the specific needs of the users who access it.

Question 11

The process of extracting information from a data warehouse or data mart is called ____.
A) data querying
B) data mining
C) data extrication
D) data verification

Accepted Answer

The process of extracting information from a data warehouse or data mart is called data mining. Data querying refers to retrieving specific data from a database using query languages such as SQL. Data extrication and data verification are not commonly used terms in the context of data management.

Question 12

A distributed database is also known as a ____ database.
A) replicated
B) virtualized
C) rendered
D) concatenated

Accepted Answer

The answer of A distributed database is also known as...

Question 13

A data mine is a large database that holds information to analyze pricing trends.

Accepted Answer

A data mine is a large database that holds a variety of data, not just pricing trends. It can hold information on customer behavior, sales figures, and more for analysis and decision-making.

Question 14

A distributed database takes available data stored in a single location and distributes it to many locations.

Accepted Answer

A distributed database takes data that is stored in multiple locations and distributes it in a way that makes it look like a united database. It does not take available data stored in a single location and distribute it to many locations.

Question 15

On Amazon.com,when the customer is ready to make a purchase,the database ____ manages the entire process.
A) table
B) administrator
C) report
D) management system

Accepted Answer

The management system, specifically a transaction management system, is responsible for managing the entire purchase process on Amazon.com. It handles tasks such as updating inventory, processing payments, and tracking orders. Tables and reports are components of the database but do not manage the process, and an administrator is a human role rather than a technology system.

Question 16

Data mining is used to generate business intelligence.

Accepted Answer

Data mining involves analyzing large amounts of data to identify patterns and insights that can inform business decisions and strategies, making it a valuable tool for generating business intelligence.

Question 17

A ____ is a skilled and trained computer professional who directs all activities related to an organization's database.
A) Data Supervisor (DS)
B) Database Administrator (DBA)
C) SQL Manager
D) Data Miner (DMA)

Accepted Answer

The correct term for a skilled and trained computer professional who directs all activities related to an organization's database is a Database Administrator (DBA). Data Supervisor (DS) and SQL Manager are not commonly used terms for this role. A Data Miner (DMA) is someone who uses statistical and mathematical techniques to analyze large datasets, which is a different job function.

Question 18

A data mine is a climate-controlled building or set of buildings that house servers that store and deliver mission-critical information and services.

Accepted Answer

A data mine is actually a process of analyzing large amounts of data to discover patterns and relationships, while a climate-controlled building that houses servers is typically referred to as a data center.

Question 19

A data center that is run and managed in an automated fashion while being monitored remotely is referred to as a ____ environment.
A) cyborg
B) lights out
C) starship
D) satellite

Accepted Answer

A lights out environment refers to a data center that is fully automated and remotely monitored, requiring minimal human intervention. "Cyborg," "starship," and "satellite" do not accurately describe this type of data center.

Question 20

A data warehouse ____ data from several databases to provide useful information.
A) deletes
B) moves
C) codes
D) merges

Accepted Answer

A data warehouse merges data from several databases to provide useful information.

Quiz 68: Industrial Databases

Which of the following tasks is the typically a primary responsibility of a database administrator?

A replicated database is a database that holds a duplicate set of frequently used data.

Industrial databases are large databases that function as the cornerstone of information systems in businesses and enterprises.

The output of data mining in a business setting is sometimes called ____.

Distributed databases connect data at different locations using ____ networks.

Installation and the ongoing maintenance of software in a database system are the job of the database ____.

A database administrator is part of a team that also includes those who program and use databases.

A data center is used by large organizations to store older archived data that is no longer needed on a day-to-day basis.

As data centers continue to grow in size to multi-acre facilities,the number of employees required to run them also grows proportionally.

A data ____ is a small data warehouse that is developed for a specific person or purpose.

The process of extracting information from a data warehouse or data mart is called ____.

A distributed database is also known as a ____ database.

A data mine is a large database that holds information to analyze pricing trends.

A distributed database takes available data stored in a single location and distributes it to many locations.

On Amazon.com,when the customer is ready to make a purchase,the database ____ manages the entire process.

Data mining is used to generate business intelligence.

A ____ is a skilled and trained computer professional who directs all activities related to an organization's database.

A data mine is a climate-controlled building or set of buildings that house servers that store and deliver mission-critical information and services.

A data center that is run and managed in an automated fashion while being monitored remotely is referred to as a ____ environment.

A data warehouse ____ data from several databases to provide useful information.