Question 1

-Referring to the figure above, the attributes of the entities shown in the table are ____.

Accepted Answer

A)  last name 
B)  first name 
C)  hire date 
D)  all of the above 
A)  last name 
B)  first name 
C)  hire date 
D)  all of the above

Question 2

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

Accepted Answer

A)  hub 
B)  portal 
C)  center 
D)  mart 
A)  hub 
B)  portal 
C)  center 
D)  mart

Question 3

Most organizations store data about entities, which are represented as ____ in a database.

Accepted Answer

A)  records 
B)  fields 
C)  characters 
D)  parameters 
A)  records 
B)  fields 
C)  characters 
D)  parameters

Question 4

Often called business ____, the business use of data mining can help increase efficiency, reduce costs, or increase profits.

Accepted Answer

A)  intelligence 
B)  smarts 
C)  technology 
D)  brainstorming 
A)  intelligence 
B)  smarts 
C)  technology 
D)  brainstorming

Question 5

-The figure above illustrates the data ____.

Accepted Answer

A)  schema 
B)  hierarchy 
C)  management system 
D)  mining system 
A)  schema 
B)  hierarchy 
C)  management system 
D)  mining system

Question 6

Identify the letter of the choice that best matches the phrase or definition.
-A climate-controlled building or set of buildings that house the servers that store and deliver mission-critical information and services

Accepted Answer

A)  file b. distributed database 
C)  relational model 
D)  data integrity 
E)  data dictionary
F) data mining
G) data warehouse
H) data hierarchy
I) data center
J) schema
K) data analysis
L) record 
A)  file b. distributed database 
C)  relational model 
D)  data integrity 
E)  data dictionary
F) data mining
G) data warehouse
H) data hierarchy
I) data center
J) schema
K) data analysis
L) record

Question 7

Identify the letter of the choice that best matches the phrase or definition.
-An outline of the logical and physical structure of the data and relationships among the data in a database

Accepted Answer

A)  file b. distributed database 
C)  relational model 
D)  data integrity 
E)  data dictionary
F) data mining
G) data warehouse
H) data hierarchy
I) data center
J) schema
K) data analysis
L) record 
A)  file b. distributed database 
C)  relational model 
D)  data integrity 
E)  data dictionary
F) data mining
G) data warehouse
H) data hierarchy
I) data center
J) schema
K) data analysis
L) record

Question 8

____ science is a line of inquiry that applies mathematical analysis and statistics to large amounts of data to interpret the relationship between natural phenomena.

Accepted Answer

A)  Hypotheses-driven 
B)  Data-driven 
C)  either a. or b. 
D)  neither a. nor b. 
A)  Hypotheses-driven 
B)  Data-driven 
C)  either a. or b. 
D)  neither a. nor b.

Question 9

Sam is a database administrator for a hockey supply store. He is reviewing old data files and recording some basic information in a spreadsheet, including the type of database.
-Sam finds that the accounting transactions were entered into Quicken. This is an example of a ____ database.

Accepted Answer

A)  single user 
B)  multiuser 
C)  flat file 
D)  general purpose 
A)  single user 
B)  multiuser 
C)  flat file 
D)  general purpose

Question 10

Together, characters, fields, records, files, and databases form the data hierarchy. _________________________

Accepted Answer

A) True 
 B)False

Question 11

Data ____________________ is a process that involves evaluating data to identify problems with the content of a database.

Accepted Answer

The answer of Data ____________________ is a process that involves...

Question 12

Relationships between tables can be illustrated through a(n) ____ relationship diagram.

Accepted Answer

A)  entity 
B)  database 
C)  attribute 
D)  key 
A)  entity 
B)  database 
C)  attribute 
D)  key

Question 13

The tables in relational databases organize data in ____, simplifying data access and manipulation.

Accepted Answer

A)  rows 
B)  columns 
C)  both a. and b. 
D)  neither a. nor b. 
A)  rows 
B)  columns 
C)  both a. and b. 
D)  neither a. nor b.

Question 14

Identify the letter of the choice that best matches the phrase or definition.
-A collection of related records, sometimes called a table

Accepted Answer

A)  file b. distributed database 
C)  relational model 
D)  data integrity 
E)  data dictionary
F) data mining
G) data warehouse
H) data hierarchy
I) data center
J) schema
K) data analysis
L) record 
A)  file b. distributed database 
C)  relational model 
D)  data integrity 
E)  data dictionary
F) data mining
G) data warehouse
H) data hierarchy
I) data center
J) schema
K) data analysis
L) record

Question 15

A(n) ____ database is designed for one purpose or a limited number of applications.

Accepted Answer

A)  special-purpose 
B)  general-purpose 
C)  industry-specific 
D)  relationship-specific 
A)  special-purpose 
B)  general-purpose 
C)  industry-specific 
D)  relationship-specific

Question 16

-Referring to the figure above, the entities in the table are the ____.

Accepted Answer

A)  employees 
B)  company 
C)  employee numbers 
D)  employee hire dates 
A)  employees 
B)  company 
C)  employee numbers 
D)  employee hire dates

Question 17

Data ____ is the process of extracting information from a data warehouse or a data mart.

Accepted Answer

A)  digging 
B)  discovery 
C)  mining 
D)  prospecting 
A)  digging 
B)  discovery 
C)  mining 
D)  prospecting

Question 18

Search engines are based on database technologies. _________________________

Accepted Answer

A) True 
 B)False

Question 19

In a database structured according to the relational model, all data elements are placed in two-dimensional tables called ____________________ that are the logical equivalent of files.

Accepted Answer

The answer of In a database structured according to the...

Question 20

What is a database administrator? Please name at least five areas of responsibility for a database administrator.

Accepted Answer

Database administrators (DBAs) are skill

-Referring to the figure above, the attributes of the entities shown in the table are ____.

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

Most organizations store data about entities, which are represented as ____ in a database.

Often called business ____, the business use of data mining can help increase efficiency, reduce costs, or increase profits.

-The figure above illustrates the data ____.

Identify the letter of the choice that best matches the phrase or definition. -A climate-controlled building or set of buildings that house the servers that store and deliver mission-critical information and services

Identify the letter of the choice that best matches the phrase or definition. -An outline of the logical and physical structure of the data and relationships among the data in a database

____ science is a line of inquiry that applies mathematical analysis and statistics to large amounts of data to interpret the relationship between natural phenomena.

Sam is a database administrator for a hockey supply store. He is reviewing old data files and recording some basic information in a spreadsheet, including the type of database. -Sam finds that the accounting transactions were entered into Quicken. This is an example of a ____ database.

Together, characters, fields, records, files, and databases form the data hierarchy. _________________________

Data ____________________ is a process that involves evaluating data to identify problems with the content of a database.

Relationships between tables can be illustrated through a(n) ____ relationship diagram.

The tables in relational databases organize data in ____, simplifying data access and manipulation.

Identify the letter of the choice that best matches the phrase or definition. -A collection of related records, sometimes called a table

A(n) ____ database is designed for one purpose or a limited number of applications.

-Referring to the figure above, the entities in the table are the ____.

Data ____ is the process of extracting information from a data warehouse or a data mart.

Search engines are based on database technologies. _________________________

In a database structured according to the relational model, all data elements are placed in two-dimensional tables called ____________________ that are the logical equivalent of files.

What is a database administrator? Please name at least five areas of responsibility for a database administrator.

Why Study Computers and Digital Technologies

Hardware Designed to Meet the Need

Software Solutions for Personal and Professional Gain

The Internet and World Wide Web

Telecommunications, Wireless Technologies, and Computer Networks

Digital Media for Work and Leisure

E-Commerce

Information, Decision Support, and Special-Purpose Systems

Systems Development

Computer Crime and Information Security

Digital Society, Ethics, and Globalization

Filters

Exam 7: Database Systems

-Referring to the figure above, the attributes of the entities shown in the table are ____.

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

Most organizations store data about entities, which are represented as ____ in a database.

Often called business ____, the business use of data mining can help increase efficiency, reduce costs, or increase profits.

-The figure above illustrates the data ____.

Identify the letter of the choice that best matches the phrase or definition. -A climate-controlled building or set of buildings that house the servers that store and deliver mission-critical information and services

Identify the letter of the choice that best matches the phrase or definition. -An outline of the logical and physical structure of the data and relationships among the data in a database

____ science is a line of inquiry that applies mathematical analysis and statistics to large amounts of data to interpret the relationship between natural phenomena.

Sam is a database administrator for a hockey supply store. He is reviewing old data files and recording some basic information in a spreadsheet, including the type of database. -Sam finds that the accounting transactions were entered into Quicken. This is an example of a ____ database.

Together, characters, fields, records, files, and databases form the data hierarchy. _________________________

Data ____________________ is a process that involves evaluating data to identify problems with the content of a database.

Relationships between tables can be illustrated through a(n) ____ relationship diagram.

The tables in relational databases organize data in ____, simplifying data access and manipulation.

Identify the letter of the choice that best matches the phrase or definition. -A collection of related records, sometimes called a table

A(n) ____ database is designed for one purpose or a limited number of applications.

-Referring to the figure above, the entities in the table are the ____.

Data ____ is the process of extracting information from a data warehouse or a data mart.

Search engines are based on database technologies. _________________________

In a database structured according to the relational model, all data elements are placed in two-dimensional tables called ____________________ that are the logical equivalent of files.

What is a database administrator? Please name at least five areas of responsibility for a database administrator.

Why Study Computers and Digital Technologies

Hardware Designed to Meet the Need

Software Solutions for Personal and Professional Gain

The Internet and World Wide Web

Telecommunications, Wireless Technologies, and Computer Networks

Digital Media for Work and Leisure

E-Commerce

Information, Decision Support, and Special-Purpose Systems

Systems Development

Computer Crime and Information Security

Digital Society, Ethics, and Globalization

Filters