• Question 1

0.5 out of 0.5 points

Within a relational database:
Selected Answer:  

All of the choices are correct

Answers: Tables are associated with one another by relationships
Tables are flat files made up of rows and columns
Data is stored in two dimensional tables sometimes referred to as relations
 

All of the choices are correct

  • Question 2

0.5 out of 0.5 points

Which of the following is NOT a database structure:
Selected Answer:  

Attribute

Answers: Hierarchical
Network
 

Attribute

Relational
  • Question 3

0.5 out of 0.5 points

The idea of data resource management is:
Selected Answer: A companies managers must be involved in data management and understand the needs of the stakeholders to manage the company’s data assets
Answers: That database administrators must be proactive in dealing with database issues like physical and logical designs
A companies managers must be involved in data management and understand the needs of the stakeholders to manage the company’s data assets
Deals with the correct back-up plan for a database to ensure that vital information is not lost
Deals with the people resources in a database operation
  • Question 4

0.5 out of 0.5 points

The database model that uses a series of two-dimensional tables or files to store information is the ________________ model. This database model has become the most popular database structure, as it is used by most microcomputer DBMS packages:
Selected Answer:  

Relational structure

Answers: Hierarchical structure
Network structure
Object-oriented structure
 

Relational structure

  • Question 5

0.5 out of 0.5 points

The physical design stage of database development:
Selected Answer:  

Determines the data storage structures and access methods

Answers: A. Develops a model of business processes
Translates conceptual models into the data models
 

Determines the data storage structures and access methods

Defines the information needs of end users in a business process
  • Question 6

0.5 out of 0.5 points

Within a customer file, one __________ would contain all the data such as name, address and phone number about a particular customer.
Selected Answer:  

Record

Answers: Table
Field
 

Record

None of the choices are correct
  • Question 7

0.5 out of 0.5 points

Using a relational database, a user can temporarily combine two or more tables so that he/she can see relevant data in a form that looks like it is all in one big table. This is described as the:
Selected Answer:  

Join operation

Answers: Select operation
 

Join operation

Project operation
None of the choices are correct
  • Question 8

0.5 out of 0.5 points

Your text discusses several major types of databases. A production database that provides detailed data needed to support the business processes of the organization is an example of which type database?
Selected Answer:  

Operational databases

Answers: Distributed databases
External databases
Local databases
 

Operational databases

  • Question 9

0.5 out of 0.5 points

The software used to specify the logical organization for a database and access it is called the:
Selected Answer:  

Database management system

Answers: Data administration subsystem
Data manipulation subsystem
Data administration subsystem
 

Database management system

  • Question 10

0.5 out of 0.5 points

According to your text, a central source of data that have been cleaned, transformed and cataloged so they can be used by managers and other business professionals for business analysis, market research and decision support is called a:
Selected Answer:  

Data warehouse

Answers: Data mart
 

Data warehouse

Transaction processing mart
Data depository
  • Question 11

0.5 out of 0.5 points

Which of the following best describes a database?
Selected Answer:  

It consolidates records previously stored in separate files into a common pool of data records

Answers: It is an integrated collection of logically related records or files
 

It consolidates records previously stored in separate files into a common pool of data records

It includes stored data that is independent of the application programs using it
All of the choices are correct
  • Question 12

0.5 out of 0.5 points

The most commonly use database structure today is:
Selected Answer:  

Relational

Answers: Network
Flat file
Object-oriented
 

Relational

  • Question 13

0.5 out of 0.5 points

What is data mining used to do:
Selected Answer:  

To revel hidden patterns and trends in historical data

Answers: Maintain the accuracy and integrity of the database
 

To revel hidden patterns and trends in historical data

To determine patterns in current operational data
To find lost data that cannot be retrieve by normal means
  • Question 14

0.5 out of 0.5 points

The primary challenge of a distributed database is:
Selected Answer:  

Data accuracy

Answers:  

Data accuracy

 Data transmission speed
Storage costs
Data security
  • Question 15

0.5 out of 0.5 points

By making use of a ________________, an end user may get an immediate response for specific information from a database.
Selected Answer:  

Query language

Answers: Database administrator
Data dictionary
 

Query language

Overhead control data
  • Question 16

0.5 out of 0.5 points

What type of database are employees using when they access online data banks, whether those data banks are free or paid for through subscriptions?
Selected Answer:  

External databases

Answers: Common databases
Distributed databases
 

External databases

Local databases
  • Question 17

0.5 out of 0.5 points

A DBMS is a set of computer programs that controls the creation, maintenance and use of the databases of an organization and its end users. As such, DBMS stands for:
Selected Answer:  

Database Management System

Answers: Database Movement Scheme
 

Database Management System

Detail Byte Movement System
Data Byte Management System
  • Question 18

0.5 out of 0.5 points

Within the tables of a relational database, each row is:
Selected Answer:  

A Single record

Answers:  

A single record

An attribute
An entity
None of the choices are correct
  • Question 19

0.5 out of 0.5 points

Which statement most accurately describes an operational database?
Selected Answer:  

Store detailed data needed to support the operations of the entire organization

Answers:  

Store detailed data needed to support the operations of the entire organization

Store data and information extracted from selected internal and external databases
Store data from current and previous years that has been extracted from the various operational and management databases of an organization
Store data of local work groups and departments, never corporate data
  • Question 20

0.5 out of 0.5 points

DBMSs using the relational model can:
Selected Answer:  

All of the choices are correct

Answers: Link data elements from various tables to provide information
Be used on mainframe computer
Be used on distributed systems
 

All of the choices are correct