Question 1

A collection of data fields all related to one object, activity, or individual is called a file.

Accepted Answer

A) True 
 B)False

Question 2

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

Accepted Answer

The answer of A(n) _____ is a field or set...

Question 3

Data modeling done at the level of an entire enterprise is called _____.

Accepted Answer

enterprise

Question 4

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

Accepted Answer

A)  bandwidth 
B)  scope 
C)  slot 
D)  domain 
A)  bandwidth 
B)  scope 
C)  slot 
D)  domain

Question 5

_____ is the process of detecting and then correcting or deleting incomplete, incorrect, inaccurate, irrelevant records that reside in a database.

Accepted Answer

The answer of _____ is the process of detecting and...

Question 6

Explain entity-relationship (ER) diagrams.

Accepted Answer

entity-relationship (ER) diagrams use ba

Question 7

A ______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

Accepted Answer

A)  data dictionary 
B)  schema 
C)  data definition language 
D)  data manipulation language 
A)  data dictionary 
B)  schema 
C)  data definition language 
D)  data manipulation language

Question 8

Data warehouses allow managers to _____ to get increasing levels of detail about business conditions.

Accepted Answer

A)  roll up 
B)  drill down 
C)  slice and dice 
D)  extract data 
A)  roll up 
B)  drill down 
C)  slice and dice 
D)  extract data

Question 9

A business intelligence _____ is a data visualization tool that displays the current status of the key performance indicators (KPIs) for an organization.

Accepted Answer

The answer of A business intelligence _____ is a data...

Question 10

A(n) _____ is a database management system that stores the entire database in random access memory (RAM).

Accepted Answer

in-memory

Question 11

A _____ is a subset of a data warehouse that is used by small- and medium-sized businesses and departments within large companies to support decision making.

Accepted Answer

A)  data dictionary 
B)  data model 
C)  data mart 
D)  data mine 
A)  data dictionary 
B)  data model 
C)  data mart 
D)  data mine

Question 12

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

Accepted Answer

A) True 
 B)False

Question 13

Often, distinct yet related databases are linked to provide enterprise-wide databases.

Accepted Answer

A) True 
 B)False

Question 14

The relational database model is currently the most widely used.

Accepted Answer

A) True 
 B)False

Question 15

An attribute is a general class of people, places, or things for which data is collected, stored, and maintained.

Accepted Answer

A) True 
 B)False

Question 16

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

A) True 
 B)False

Question 17

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

Accepted Answer

A)  attribute 
B)  entity 
C)  primary key 
D)  data item 
A)  attribute 
B)  entity 
C)  primary key 
D)  data item

Question 18

The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files.

Accepted Answer

A) True 
 B)False

Question 19

Briefly describe the hierarchy of data.

Accepted Answer

data is generally organized in a hierarc

Question 20

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

Accepted Answer

A)  flat file 
B)  schema 
C)  relational system 
D)  user view 
A)  flat file 
B)  schema 
C)  relational system 
D)  user view

A collection of data fields all related to one object, activity, or individual is called a file.

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

Data modeling done at the level of an entire enterprise is called _____.

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

_____ is the process of detecting and then correcting or deleting incomplete, incorrect, inaccurate, irrelevant records that reside in a database.

Explain entity-relationship (ER) diagrams.

A ______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

Data warehouses allow managers to _____ to get increasing levels of detail about business conditions.

A business intelligence _____ is a data visualization tool that displays the current status of the key performance indicators (KPIs) for an organization.

A(n) _____ is a database management system that stores the entire database in random access memory (RAM).

A _____ is a subset of a data warehouse that is used by small- and medium-sized businesses and departments within large companies to support decision making.

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

Often, distinct yet related databases are linked to provide enterprise-wide databases.

The relational database model is currently the most widely used.

An attribute is a general class of people, places, or things for which data is collected, stored, and maintained.

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

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

The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files.

Briefly describe the hierarchy of data.

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

An Introduction to Information Systems

Information Systems in Organizations

Hardware: Input, Processing, Output, and Storage Devices

Software: Systems and Application Software

Telecommunications and Networks

The Internet, Web, Intranets, and Extranets

Electronic and Mobile Commerce

Enterprise Systems

Information and Decision Support Systems

Knowledge Management and Specialized Information Systems

Systems Development

Systems Development: Construction, Integration and Testing, Implementation, Operation an

The Personal and Social Impact of Computers

Filters

Exam 5: Database Systems and Applications

A collection of data fields all related to one object, activity, or individual is called a file.

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

Data modeling done at the level of an entire enterprise is called _____.

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

_____ is the process of detecting and then correcting or deleting incomplete, incorrect, inaccurate, irrelevant records that reside in a database.

Explain entity-relationship (ER) diagrams.

A ______ is a collection of instructions and commands used to define and describe data and relationships in a specific database.

Data warehouses allow managers to _____ to get increasing levels of detail about business conditions.

A business intelligence _____ is a data visualization tool that displays the current status of the key performance indicators (KPIs) for an organization.

A(n) _____ is a database management system that stores the entire database in random access memory (RAM).

A _____ is a subset of a data warehouse that is used by small- and medium-sized businesses and departments within large companies to support decision making.

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

Often, distinct yet related databases are linked to provide enterprise-wide databases.

The relational database model is currently the most widely used.

An attribute is a general class of people, places, or things for which data is collected, stored, and maintained.

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

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

The relational model describes data using a standard tabular format; all data elements are placed in three-dimensional tables called relations, which are the logical equivalent of files.

Briefly describe the hierarchy of data.

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

An Introduction to Information Systems

Information Systems in Organizations

Hardware: Input, Processing, Output, and Storage Devices

Software: Systems and Application Software

Telecommunications and Networks

The Internet, Web, Intranets, and Extranets

Electronic and Mobile Commerce

Enterprise Systems

Information and Decision Support Systems

Knowledge Management and Specialized Information Systems

Systems Development

Systems Development: Construction, Integration and Testing, Implementation, Operation an

The Personal and Social Impact of Computers

Filters