Home › Courses › MGIS402 Management Information Systems › Information Management System Chapter 5 Quiz

Information Management System Chapter 5 Quiz

Posted on Posted in MGIS402 Management Information Systems
  • 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

 

Related Posts