MIS Chapter 3 Study Test

46 Questions | By Olgerthasko | Last updated: May 21, 2018 | Total Attempts: 799

Questions

Settings

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