Question 1

Identify the letter of the choice that best matches the phrase or definition.
-The process of extracting information from a data warehouse or a data mart

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 2

These are all routine processing activities that can be implemented with a database system, EXCEPT ____.

Accepted Answer

A)  Organizations of all sizes have to pay their employees 
B)  A small business needs to send out bills quickly to maintain a healthy cash flow 
C)  A manufacturing company needs to pay its suppliers for parts and raw materials 
D)  A corporation needs to decide on its business strategies for the year 
A)  Organizations of all sizes have to pay their employees 
B)  A small business needs to send out bills quickly to maintain a healthy cash flow 
C)  A manufacturing company needs to pay its suppliers for parts and raw materials 
D)  A corporation needs to decide on its business strategies for the year

Question 3

In a database, characters are put together to form a(n) ____, the smallest practical unit in most databases.

Accepted Answer

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

Question 4

The database model that is by far most popular is the ____ model.

Accepted Answer

A)  network 
B)  object-oriented 
C)  relational 
D)  hierarchical 
A)  network 
B)  object-oriented 
C)  relational 
D)  hierarchical

Question 5

The purpose of field ____________________ is to specify the type, size, format, and other aspects of each field.

Accepted Answer

The answer of The purpose of field ____________________ is to...

Question 6

Sara Lewis is a teacher at Lakeside Junior College. When she came to class late, for the second time in a row, her students suggest she get a PIM. Sara is not sure "what a PIM is" and is doing some research.
-Sara's research shows that a PIM can be described as ____.

Accepted Answer

A)  a simple data management software 
B)  a centralized database system 
C)  either a. or b. 
D)  neither a. nor b. 
A)  a simple data management software 
B)  a centralized database system 
C)  either a. or b. 
D)  neither a. nor b.

Question 7

In a(n) distributed database approach to data management, multiple application programs share a pool of related data. _________________________

Accepted Answer

A) True 
 B)False

Question 8

All of the following are benefits of a centralized database approach EXCEPT: ____.

Accepted Answer

A)  Reduced data redundancy 
B)  Improved data integrity 
C)  Easier modification and updating 
D)  Data and program dependence 
A)  Reduced data redundancy 
B)  Improved data integrity 
C)  Easier modification and updating 
D)  Data and program dependence

Question 9

Microsoft Outlook and Quicken are examples of popular single-user DBMSs used to store and manipulate personal data. _________________________

Accepted Answer

A) True 
 B)False

Question 10

A(n) ____ database contains data that is difficult or impossible to place in a traditional
Database system.

Accepted Answer

A)  structured 
B)  unstructured 
C)  either a. or b. 
D)  neither a. nor b. 
A)  structured 
B)  unstructured 
C)  either a. or b. 
D)  neither a. nor b.

Question 11

Before data can be stored, manipulated, and retrieved, the database must be logically designed. At a minimum, this requires field, record, and ____ design.

Accepted Answer

A)  chart 
B)  table 
C)  entity 
D)  report 
A)  chart 
B)  table 
C)  entity 
D)  report

Question 12

A(n) structured database contains data that is difficult or impossible to place in a traditional database system. _________________________

Accepted Answer

A) True 
 B)False

Question 13

Since the Newtonian revolution, scientific inquiry has been defined by experimentation tested by hypotheses.

Accepted Answer

A) True 
 B)False

Question 14

____ involves choosing data based on certain criteria.

Accepted Answer

A)  Selecting 
B)  Choosing 
C)  Picking 
D)  Getting 
A)  Selecting 
B)  Choosing 
C)  Picking 
D)  Getting

Question 15

Shauna is the Database Administrator for an online store that sells cosmetics. They grew so fast that they ended up with seven different databases, and Shauna is now investigating how to set up a centralized database approach.
-Shauna found that, with a centralized database approach, all application programs use the same overall procedures to retrieve data and information. This is ____ of data access.

Accepted Answer

A)  relevancy 
B)  optimization 
C)  normalization 
D)  standardization 
A)  relevancy 
B)  optimization 
C)  normalization 
D)  standardization

Question 16

A data ____ is a typically large database that holds important information from a variety of sources. It is usually a subset of multiple databases maintained by an organization or individual.

Accepted Answer

A)  club 
B)  store 
C)  warehouse 
D)  bank 
A)  club 
B)  store 
C)  warehouse 
D)  bank

Question 17

Identify the letter of the choice that best matches the phrase or definition.
-A database where data is spread across several databases at different locations

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 18

Federal databases often include the results of DNA tests as a(n) ____ in databases of convicted criminals.

Accepted Answer

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

Question 19

____ computing can be broadly defined as the development and use of application programs and computer systems by users who are not computer systems professionals.

Accepted Answer

A)  User 
B)  End-user 
C)  Client 
D)  End-client 
A)  User 
B)  End-user 
C)  Client 
D)  End-client

Question 20

Individuals use personal databases to ____.

Accepted Answer

A)  store addresses and contact information 
B)  keep track of important dates 
C)  keep track of valuables for possible insurance claims 
D)  all of the above 
A)  store addresses and contact information 
B)  keep track of important dates 
C)  keep track of valuables for possible insurance claims 
D)  all of the above

Identify the letter of the choice that best matches the phrase or definition. -The process of extracting information from a data warehouse or a data mart

These are all routine processing activities that can be implemented with a database system, EXCEPT ____.

In a database, characters are put together to form a(n) ____, the smallest practical unit in most databases.

The database model that is by far most popular is the ____ model.

The purpose of field ____________________ is to specify the type, size, format, and other aspects of each field.

Sara Lewis is a teacher at Lakeside Junior College. When she came to class late, for the second time in a row, her students suggest she get a PIM. Sara is not sure "what a PIM is" and is doing some research. -Sara's research shows that a PIM can be described as ____.

In a(n) distributed database approach to data management, multiple application programs share a pool of related data. _________________________

All of the following are benefits of a centralized database approach EXCEPT: ____.

Microsoft Outlook and Quicken are examples of popular single-user DBMSs used to store and manipulate personal data. _________________________

A(n) ____ database contains data that is difficult or impossible to place in a traditional Database system.

Before data can be stored, manipulated, and retrieved, the database must be logically designed. At a minimum, this requires field, record, and ____ design.

A(n) structured database contains data that is difficult or impossible to place in a traditional database system. _________________________

Since the Newtonian revolution, scientific inquiry has been defined by experimentation tested by hypotheses.

____ involves choosing data based on certain criteria.

A data ____ is a typically large database that holds important information from a variety of sources. It is usually a subset of multiple databases maintained by an organization or individual.

Identify the letter of the choice that best matches the phrase or definition. -A database where data is spread across several databases at different locations

Federal databases often include the results of DNA tests as a(n) ____ in databases of convicted criminals.

____ computing can be broadly defined as the development and use of application programs and computer systems by users who are not computer systems professionals.

Individuals use personal databases to ____.

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

Identify the letter of the choice that best matches the phrase or definition. -The process of extracting information from a data warehouse or a data mart

These are all routine processing activities that can be implemented with a database system, EXCEPT ____.

In a database, characters are put together to form a(n) ____, the smallest practical unit in most databases.

The database model that is by far most popular is the ____ model.

The purpose of field ____________________ is to specify the type, size, format, and other aspects of each field.

Sara Lewis is a teacher at Lakeside Junior College. When she came to class late, for the second time in a row, her students suggest she get a PIM. Sara is not sure "what a PIM is" and is doing some research. -Sara's research shows that a PIM can be described as ____.

In a(n) distributed database approach to data management, multiple application programs share a pool of related data. _________________________

All of the following are benefits of a centralized database approach EXCEPT: ____.

Microsoft Outlook and Quicken are examples of popular single-user DBMSs used to store and manipulate personal data. _________________________

A(n) ____ database contains data that is difficult or impossible to place in a traditional Database system.

Before data can be stored, manipulated, and retrieved, the database must be logically designed. At a minimum, this requires field, record, and ____ design.

A(n) structured database contains data that is difficult or impossible to place in a traditional database system. _________________________

Since the Newtonian revolution, scientific inquiry has been defined by experimentation tested by hypotheses.

____ involves choosing data based on certain criteria.

A data ____ is a typically large database that holds important information from a variety of sources. It is usually a subset of multiple databases maintained by an organization or individual.

Identify the letter of the choice that best matches the phrase or definition. -A database where data is spread across several databases at different locations

Federal databases often include the results of DNA tests as a(n) ____ in databases of convicted criminals.

____ computing can be broadly defined as the development and use of application programs and computer systems by users who are not computer systems professionals.

Individuals use personal databases to ____.

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