MIS Chapter 3 Study Test
Settings
.
- 1.Which data administration facility allows you to control who has access to what information and what type of access those people have?
- A.
Security management facilities
- B.
Query optimization facilities
- C.
Reorganization facilities
- D.
Concurrency control facilities
- 2.A senior manager who analyzes internal and external information to analyze marketing campaigns and their affect on customer buying habits is using which type of application?
- A.
Online analytical processing (OLAP)
- B.
Geographic information systems (GIS)
- C.
Enterprise resource planning (ERP)
- D.
Decision support systems (DSS)
- 3.Which type of constraint ensures the quality of information in a relational database?
- A.
Environmental constraint
- B.
Business constraint
- C.
Integrity constraint
- D.
Production constraint
- 4.Which application supports the manipulation of information to support decision making?
- A.
OLTP
- B.
CRM
- C.
ERP
- D.
OLAP
- 5.Which organizational function is responsible for the more technical and operational aspects of managing information repositories?
- A.
Strategic management
- B.
Database administration
- C.
Information resource planning
- D.
Operational planning
- 6.A(n) _____ is a field or group of fields that uniquely describes each record.
- A.
Identifying key
- B.
Relational key
- C.
Primary key
- D.
Main key
- 7.In a data warehouse, which data-mining tool would you use to quickly build reports without having to write programming code?
- A.
Application report generator
- B.
Artificial intelligence
- C.
Multidimensional analysis tools
- D.
Query-and-reporting tools
- 8.What type of software tool is used to query information stored in a data warehouse?
- A.
OLTP
- B.
Data dictionary
- C.
Data-mining
- D.
Decision support
- 9.Which term refers to a specific piece of information that is stored in a database file?
- A.
Relation
- B.
Category
- C.
Class
- D.
Attribute
- 10.If you were a programmer and needed to view information as it was stored by the database, what type of database view would you see?
- A.
Logical view
- B.
Physical view
- C.
Stored view
- D.
Objective view
- 11._____ refers to collective information that gives you the ability to make effective, important, and often strategic business decisions.
- A.
Query-by-example
- B.
Business intelligence
- C.
Information analysis
- D.
SQL
- 12.Which data manipulation tool allows you to quickly define the formats of needed business reports from information stored in a database?
- A.
Query reporting tools
- B.
SQL reports
- C.
Report generators
- D.
Application reports
- 13.A(n) _____ key is a primary key of one file that appears in another file.
- A.
Foreign
- B.
Secondary
- C.
Identifying
- D.
Duplicate
- 14._____ is the process of reinstalling the backup information in the event the information was lost.
- A.
Recovery
- B.
Recycling
- C.
Retrieval
- D.
Reproduction
- 15.SQL is:
- A.
A standardized fourth generation language found in most DBMSs.
- B.
A storage tool that holds the data and definitions for a database.
- C.
An administrative tool that allows you to set access rights for database users.
- D.
A programming language that can be used instead of a DBMS.
- 16._____ is the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information.
- A.
Online analytical processing (OLAP)
- B.
Business intelligence (BI)
- C.
File management systems (FMS)
- D.
Online transaction processing (OLTP)
- 17.What must you define before adding any information to a relational database?
- A.
The intended audience
- B.
The physical hardware structure
- C.
The administrative rights of users
- D.
The logical structure of the database
- 18.Data warehouses exist to support:
- A.
MRP
- B.
OLAP.
- C.
OLTP.
- D.
SQL.
- 19._____ are the most essential and important quantifiable measures used in analytics initiatives to monitor success of a business activity.
- A.
KPIs
- B.
DPIs
- C.
QBEs
- D.
SQLs
- 20.If you were to perform a regression analysis, what type of data warehouse tool would it be?
- A.
Statistical
- B.
Multidimensional analysis
- C.
Production analysis
- D.
Hypercube
- 21.If the file containing your student information appears in two different places with two different birth dates, your data would not be considered ____.
- A.
Legitimate
- B.
Valid
- C.
Clean
- D.
Acceptable
- 22.What is the most popular model for creating databases?
- A.
Hierarchical database model
- B.
Object-oriented database model
- C.
Ecological database model
- D.
Relational database model
- 23.Which part of a relational database contains the logical structure for the information?
- A.
Data dictionary
- B.
Relation
- C.
Query
- D.
SQL
- 24.If you were looking at information in a database and you are able to see only the information you needed in the format you wanted, what type of database view is it?
- A.
Logical view
- B.
High-level view
- C.
Subjective view
- D.
Physical view
- 25.Databases that support OLTP are most often referred to as ____.
- A.
OLAP
- B.
Data warehouses
- C.
Relational databases
- D.
Operational databases
Back to top