Question 1

A _____ is a simple database program whose records have no relationship to one another.
A) flat file
B) schema
C) relational system
D) user view

Accepted Answer

A flat file database is a simple database program where records have no relationship with each other. It is a type of database that stores data in a plain text file, with each line representing a record. It is usually used for small-scale projects or applications that do not require complex data structures or relationships between records. Schema, relational system, and user view are not the best choices as they are not specifically related to a simple database program with no record relationships.

Question 2

Basic data manipulations include _____ that involves eliminating rows in a relational database according to certain criteria.
A) selecting
B) joining
C) projecting
D) linking

Accepted Answer

The data manipulation operation that involves eliminating rows in a relational database according to certain criteria is called selecting. Joining involves combining rows from two or more tables based on a related column, projecting involves selecting specific columns from a table, and linking is not a common data manipulation operation in relational databases.

Question 3

One of the final steps in installing and using a large database involves "telling" the database management system (DBMS) the logical and physical structure of the data and the relationships among the data for each user.

Accepted Answer

The answer of One of the final steps in installing...

Question 4

The smallest piece of data used by a computer is a(n) _____.
A) entity
B) byte
C) bit
D) character

Accepted Answer

A bit is the smallest unit of data and can only have two values: 0 or 1. It is the basic building block of all digital data and is used to represent information in computers. Bytes are made up of multiple bits and characters are made up of multiple bytes. An entity is a general term used to refer to a distinct object or concept in a system or database.

Question 5

A database administrator (DBA) must have a clear understanding of the fundamental business of an organization, be proficient in the use of selected database management systems, and stay abreast of emerging technologies and new design approaches.

Accepted Answer

A database administrator's role involves understanding the business needs of an organization, managing database systems, and keeping up-to-date with advancements in technology and design methods.

Question 6

A database is a collection of integrated and related _____.
A) fields
B) attributes
C) records
D) files

Accepted Answer

A database is a collection of integrated and related files, which are organized to facilitate data management and retrieval.

Question 7

A data warehouse stores historical data that has been extracted from operational systems and external sources.

Accepted Answer

A data warehouse is specifically designed to store historical data that has been extracted from various sources for the purpose of analysis, reporting, and decision-making.

Question 8

Predictive analysis is a form of data mining that combines historical data with assumptions about future conditions to predict outcomes of events.

Accepted Answer

Predictive analysis relies on historical data and other variables to make predictions about future outcomes.

Question 9

Online analytical processing and data mining are essentially the same thing.

Accepted Answer

Online analytical processing (OLAP) is a technique for analyzing multidimensional data from different perspectives, while data mining involves finding patterns and relationships in large datasets using statistical and machine learning methods. While they may be used together in some cases, OLAP and data mining are distinct techniques.

Question 10

A collection of fields all related to a single object, activity, or individual is a(n) _____.
A) record
B) file
C) attribute
D) character

Accepted Answer

A collection of fields that are all related to a single object, activity, or individual is commonly referred to as a record. A file may contain multiple records, but a single record refers to a specific entity. An attribute is a single piece of data within a record, and a character is a single unit of information, such as a letter or number.

Question 11

Counterintelligence turns data into useful information that is kept closely guarded to avoid this information from falling into the hands of the wrong employees.

Accepted Answer

Counterintelligence is primarily focused on protecting an organization's sensitive information from external threats, particularly foreign intelligence services, rather than preventing internal employees from accessing it.

Question 12

As long as the tables in a relational database share one common _____, the tables can be linked to provide useful information and reports.
A) primary key
B) file
C) foreign key
D) data attribute

Accepted Answer

The answer of As long as the tables in a...

Question 13

Which of the following statements is true of a database?
A) It is accessed primarily for use by an organization's database administrator and data administrator.
B) It provides an essential foundation for an organization's knowledge management and artificial intelligence systems.
C) It is a collection of unstructured data.
D) It helps companies analyze information to open new market opportunities.

Accepted Answer

The answer of Which of the following statements is true...

Question 14

A(n) _____ is a field or set of fields in a record that uniquely identifies the record.
A) attribute
B) entity
C) primary key
D) data item

Accepted Answer

A primary key is a field or set of fields in a record that uniquely identifies the record. This means that no other record in the database can have the same value in the primary key field(s). This is an important concept in database design and allows for efficient retrieval and manipulation of data.

Question 15

A database administrator is an important nontechnical position responsible for defining and implementing consistent principles for a variety of data issues, including setting data standards and data definitions that apply across all the databases in an organization.

Accepted Answer

A database administrator is a technical position responsible for the physical and technical aspects of managing databases, including database design, implementation, maintenance, and security, rather than focusing solely on non-technical issues like setting data standards and definitions.

Question 16

Online analytical processing involves the automated discovery of patterns and relationships in a data warehouse.

Accepted Answer

Online analytical processing (OLAP) is a technique for analyzing data within a data warehouse in multiple dimensions, primarily aimed at complex querying and reporting, rather than the automated discovery of patterns and relationships, which is more characteristic of data mining.

Question 17

Each attribute in a relational database model can be constrained to a range of allowable values called a _____.
A) bandwidth
B) scope
C) slot
D) domain

Accepted Answer

The term "domain" is commonly used in relational database models to refer to the range of allowable values that can be assigned to an attribute. This ensures data integrity and consistency within the database. Therefore, option D is the best choice as it uses the term "domain" to describe the range of allowable values for an attribute in a relational database.

Question 18

_____ is an approach that starts by investigating the general data and information needs of an organization at the strategic level and then examines more specific data and information needs for the functional areas and departments within the organization.
A) Data selecting
B) Enterprise data modeling
C) Data cleansing
D) Social graph analysis
​

Accepted Answer

Enterprise data modeling is an approach that begins by identifying the general data and information requirements of an organization at the strategic level and then examines more specific data and information needs for the various functional areas and departments within the organization. The goal is to create a comprehensive view of the organization's data and information needs and to develop a unified data architecture that supports those needs. Options A, C, and D are not correct as they refer to different data management techniques.

Question 19

Competitive intelligence is espionage.

Accepted Answer

Competitive intelligence is the process of gathering, analyzing, and using information about competitors and the marketplace to make business decisions, while espionage is the practice of obtaining secret information without authorization. While there is some overlap between the two, competitive intelligence is generally conducted ethically and legally, while espionage is not.

Question 20

Unstructured data comes from sources such as word-processing documents and scientific research.

Accepted Answer

Unstructured data refers to data that does not have a defined data model or format, such as text in word-processing documents or unstructured datasets from scientific research.

Quiz 5: Database Systems and Applications

A _____ is a simple database program whose records have no relationship to one another.

Basic data manipulations include _____ that involves eliminating rows in a relational database according to certain criteria.

One of the final steps in installing and using a large database involves "telling" the database management system (DBMS) the logical and physical structure of the data and the relationships among the data for each user.

The smallest piece of data used by a computer is a(n) _____.

A database administrator (DBA) must have a clear understanding of the fundamental business of an organization, be proficient in the use of selected database management systems, and stay abreast of emerging technologies and new design approaches.

A database is a collection of integrated and related _____.

A data warehouse stores historical data that has been extracted from operational systems and external sources.

Predictive analysis is a form of data mining that combines historical data with assumptions about future conditions to predict outcomes of events.

Online analytical processing and data mining are essentially the same thing.

A collection of fields all related to a single object, activity, or individual is a(n) _____.

Counterintelligence turns data into useful information that is kept closely guarded to avoid this information from falling into the hands of the wrong employees.

As long as the tables in a relational database share one common _____, the tables can be linked to provide useful information and reports.

Which of the following statements is true of a database?

A(n) _____ is a field or set of fields in a record that uniquely identifies the record.

A database administrator is an important nontechnical position responsible for defining and implementing consistent principles for a variety of data issues, including setting data standards and data definitions that apply across all the databases in an organization.

Online analytical processing involves the automated discovery of patterns and relationships in a data warehouse.

Each attribute in a relational database model can be constrained to a range of allowable values called a _____.

_____ is an approach that starts by investigating the general data and information needs of an organization at the strategic level and then examines more specific data and information needs for the functional areas and departments within the organization.

Competitive intelligence is espionage.

Unstructured data comes from sources such as word-processing documents and scientific research.