MIS Chapter 3 Study Test

46 Questions | By Olgerthasko | Last updated: Mar 22, 2022 | Total Attempts: 1569

Questions

Settings

Create your own Quiz

Questions and Answers

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