Mis Chapter 3 Study Test (2023)

1.
Which data administration facility allows you to control who has access to what information and what type of access those people have?
- A.&nbsp
  Security management facilities
- B.&nbsp
  Query optimization facilities
- C.&nbsp
  Reorganization facilities
- D.&nbsp
  Concurrency control facilities
Correct Answer
A. Security management 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.&nbsp
  Online analytical processing (OLAP)
- B.&nbsp
  Geographic information systems (GIS)
- C.&nbsp
  Enterprise resource planning (ERP)
- D.&nbsp
  Decision support systems (DSS)
Correct Answer
A. Online analytical processing (OLAP)
3.
Which type of constraint ensures the quality of information in a relational database?
- A.&nbsp
  Environmental constraint
- B.&nbsp
  Business constraint
- C.&nbsp
  Integrity constraint
- D.&nbsp
  Production constraint
Correct Answer
C. Integrity constraint
4.
Which application supports the manipulation of information to support decision making?
- A.&nbsp
  OLTP
- B.&nbsp
  CRM
- C.&nbsp
  ERP
- D.&nbsp
  OLAP
Correct Answer
D. OLAP
5.
Which organizational function is responsible for the more technical and operational aspects of managing information repositories?
- A.&nbsp
  Strategic management
- B.&nbsp
  Database administration
- C.&nbsp
  Information resource planning
- D.&nbsp
  Operational planning
Correct Answer
B. Database administration
6.
A(n) _____ is a field or group of fields that uniquely describes each record.
- A.&nbsp
  Identifying key
- B.&nbsp
  Relational key
- C.&nbsp
  Primary key
- D.&nbsp
  Main key
Correct Answer
C. Primary key
7.
In a data warehouse, which data-mining tool would you use to quickly build reports without having to write programming code?
- A.&nbsp
  Application report generator
- B.&nbsp
  Artificial intelligence
- C.&nbsp
  Multidimensional analysis tools
- D.&nbsp
  Query-and-reporting tools
Correct Answer
D. Query-and-reporting tools
8.
What type of software tool is used to query information stored in a data warehouse?
- A.&nbsp
  OLTP
- B.&nbsp
  Data dictionary
- C.&nbsp
  Data-mining
- D.&nbsp
  Decision support
Correct Answer
C. Data-mining
9.
Which term refers to a specific piece of information that is stored in a database file?
- A.&nbsp
  Relation
- B.&nbsp
  Category
- C.&nbsp
  Class
- D.&nbsp
  Attribute
Correct Answer
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.&nbsp
  Logical view
- B.&nbsp
  Physical view
- C.&nbsp
  Stored view
- D.&nbsp
  Objective view
Correct Answer
B. Physical view
11.
_____ refers to collective information that gives you the ability to make effective, important, and often strategic business decisions.
- A.&nbsp
  Query-by-example
- B.&nbsp
  Business intelligence
- C.&nbsp
  Information analysis
- D.&nbsp
  SQL
Correct Answer
B. Business intelligence
12.
Which data manipulation tool allows you to quickly define the formats of needed business reports from information stored in a database?
- A.&nbsp
  Query reporting tools
- B.&nbsp
  SQL reports
- C.&nbsp
  Report generators
- D.&nbsp
  Application reports
Correct Answer
C. Report generators
13.
A(n) _____ key is a primary key of one file that appears in another file.
- A.&nbsp
  Foreign
- B.&nbsp
  Secondary
- C.&nbsp
  Identifying
- D.&nbsp
  Duplicate
Correct Answer
A. Foreign
14.
_____ is the process of reinstalling the backup information in the event the information was lost.
- A.&nbsp
  Recovery
- B.&nbsp
  Recycling
- C.&nbsp
  Retrieval
- D.&nbsp
  Reproduction
Correct Answer
A. Recovery
15.
SQL is:
- A.&nbsp
  A standardized fourth generation language found in most DBMSs.
- B.&nbsp
  A storage tool that holds the data and definitions for a database.
- C.&nbsp
  An administrative tool that allows you to set access rights for database users.
- D.&nbsp
  A programming language that can be used instead of a DBMS.
Correct Answer
A. A standardized fourth generation language found in most DBMSs.
16.
_____ is the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information.
- A.&nbsp
  Online analytical processing (OLAP)
- B.&nbsp
  Business intelligence (BI)
- C.&nbsp
  File management systems (FMS)
- D.&nbsp
  Online transaction processing (OLTP)
Correct Answer
D. Online transaction processing (OLTP)
17.
What must you define before adding any information to a relational database?
- A.&nbsp
  The intended audience
- B.&nbsp
  The physical hardware structure
- C.&nbsp
  The administrative rights of users
- D.&nbsp
  The logical structure of the database
Correct Answer
D. The logical structure of the database
18.
Data warehouses exist to support:
- A.&nbsp
  MRP
- B.&nbsp
  OLAP.
- C.&nbsp
  OLTP.
- D.&nbsp
  SQL.
Correct Answer
C. OLTP.
19.
_____ are the most essential and important quantifiable measures used in analytics initiatives to monitor success of a business activity.
- A.&nbsp
  KPIs
- B.&nbsp
  DPIs
- C.&nbsp
  QBEs
- D.&nbsp
  SQLs
Correct Answer
A. KPIs
20.
If you were to perform a regression analysis, what type of data warehouse tool would it be?
- A.&nbsp
  Statistical
- B.&nbsp
  Multidimensional analysis
- C.&nbsp
  Production analysis
- D.&nbsp
  Hypercube
Correct Answer
A. Statistical
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.&nbsp
  Legitimate
- B.&nbsp
  Valid
- C.&nbsp
  Clean
- D.&nbsp
  Acceptable
Correct Answer
C. Clean
22.
What is the most popular model for creating databases?
- A.&nbsp
  Hierarchical database model
- B.&nbsp
  Object-oriented database model
- C.&nbsp
  Ecological database model
- D.&nbsp
  Relational database model
Correct Answer
D. Relational database model
23.
Which part of a relational database contains the logical structure for the information?
- A.&nbsp
  Data dictionary
- B.&nbsp
  Relation
- C.&nbsp
  Query
- D.&nbsp
  SQL
Correct Answer
A. Data dictionary
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.&nbsp
  Logical view
- B.&nbsp
  High-level view
- C.&nbsp
  Subjective view
- D.&nbsp
  Physical view
Correct Answer
A. Logical view
25.
Databases that support OLTP are most often referred to as ____.
- A.&nbsp
  OLAP
- B.&nbsp
  Data warehouses
- C.&nbsp
  Relational databases
- D.&nbsp
  Operational databases
Correct Answer
D. Operational databases
26.
_____ are the technology tools that directly support OLTP.
- A.&nbsp
  OLAP and Hypercubes
- B.&nbsp
  Databases and DBMSs
- C.&nbsp
  EIS and DSS
- D.&nbsp
  CRM and ERP
Correct Answer
B. Databases and DBMSs
27.
A _____ is a special form of a database that contains information gathered from operational databases for the purpose of supporting decision-making tasks.
- A.&nbsp
  Data mine
- B.&nbsp
  Data warehouse
- C.&nbsp
  Data dictionary
- D.&nbsp
  Data entry
Correct Answer
B. Data warehouse
28.
A data warehouse is:
- A.&nbsp
  A large hardware environment that supports multiple platforms.
- B.&nbsp
  A logical collection of information used to create business intelligence.
- C.&nbsp
  An operational database system used to manage and analyze transactional data.
- D.&nbsp
  An accumulation of all operational data stored by large organizations.
Correct Answer
B. A logical collection of information used to create business intelligence.
29.
_____ is a subset of a data warehouse in which only a focused portion of the data warehouse information is kept.
- A.&nbsp
  Data mart
- B.&nbsp
  Data mine
- C.&nbsp
  Data dictionary
- D.&nbsp
  Database
Correct Answer
A. Data mart
30.
Which type of database model organizes and accesses information according to its logical structure rather than its physical structure?
- A.&nbsp
  Hierarchical
- B.&nbsp
  File-based
- C.&nbsp
  Relational
- D.&nbsp
  Conventional
Correct Answer
C. Relational
31.
_____ ensure the validity of database updates when multiple users attempt to access and change the same information.
- A.&nbsp
  Backup and recovery facilities
- B.&nbsp
  Query optimization facilities
- C.&nbsp
  Change management facilities
- D.&nbsp
  Concurrency control facilities
Correct Answer
D. Concurrency control facilities
32.
A _____ is a collection of information that you organize and access according to the logical structure of that information.
- A.&nbsp
  Database
- B.&nbsp
  Data dictionary
- C.&nbsp
  Data mart
- D.&nbsp
  Data mine
Correct Answer
A. Database
33.
Which data manipulation tool allows you to graphically design the answer to your business questions?
- A.&nbsp
  Report generators
- B.&nbsp
  Application reports
- C.&nbsp
  Query-by-example tools
- D.&nbsp
  Data administration tools
Correct Answer
C. Query-by-example tools
34.
If your phone number was used in a clothing store to uniquely identify you as a customer, the phone number would be considered a(n) ____.
- A.&nbsp
  Identifying field
- B.&nbsp
  Relational field
- C.&nbsp
  Primary key
- D.&nbsp
  Principle key
Correct Answer
C. Primary key
35.
What does it mean for a data warehouse to be multidimensional?
- A.&nbsp
  The database stores data, facts, and definitions for all stored information.
- B.&nbsp
  Data can be linked to other sources of internal and external information.
- C.&nbsp
  The files stored in a warehouse contain several layers of columns and rows.
- D.&nbsp
  Customer information can be related to sales, departmental, and organizational information.
Correct Answer
C. The files stored in a warehouse contain several layers of columns and rows.
36.
_____ is the science of fact-based decision making.
- A.&nbsp
  Statistics
- B.&nbsp
  Synthesis
- C.&nbsp
  Analytics
- D.&nbsp
  Deduction
Correct Answer
C. Analytics
37.
A _____ is simply a copy of the information stored on a computer.
- A.&nbsp
  Photocopy
- B.&nbsp
  Replica
- C.&nbsp
  Duplicate
- D.&nbsp
  Backup
Correct Answer
D. Backup
38.
Which of the following functions plans for, oversees the development of, and monitors the information resource of an organization?
- A.&nbsp
  Data administration
- B.&nbsp
  Strategic management
- C.&nbsp
  Data manipulation
- D.&nbsp
  Operational planning
Correct Answer
A. Data administration
39.
Which type of application requires that you know the physical location of information before you are able to access it?
- A.&nbsp
  CRM
- B.&nbsp
  ERP
- C.&nbsp
  Spreadsheets
- D.&nbsp
  Word processor
Correct Answer
C. Spreadsheets
40.
A(n) _____ displays key information gathered from several sources on a computer screen in a format tailored to the needs and wants of an individual knowledge worker.
- A.&nbsp
  Hypercube
- B.&nbsp
  Digital dashboard
- C.&nbsp
  Intelligent agent
- D.&nbsp
  Neural network
Correct Answer
B. Digital dashboard
41.
_____ facilities find the "shortest route" to the information you want so you don't have to.
- A.&nbsp
  Backup and recovery facilities
- B.&nbsp
  Query optimization facilities
- C.&nbsp
  Change management facilities
- D.&nbsp
  Concurrency control facilities
Correct Answer
B. Query optimization facilities
42.
Which of the following is true of data administration and database administration?
- A.&nbsp
  Data administration focuses on the development of the data dictionary whereas database administration focuses on the raw data.
- B.&nbsp
  Data administration focuses on OLTP whereas database administration focuses on OLAP.
- C.&nbsp
  Data administration and database administration are terms that can be used interchangeably.
- D.&nbsp
  Data administration focuses on strategic management whereas database administration focuses on operational issues.
Correct Answer
D. Data administration focuses on strategic management whereas database administration focuses on operational issues.
43.
Which of the following data administration facilities continually maintain statistics concerning how the DBMS engine physically accesses information?
- A.&nbsp
  Security management facilities
- B.&nbsp
  Query optimization facilities
- C.&nbsp
  Reorganization facilities
- D.&nbsp
  Concurrency control facilities
Correct Answer
C. Reorganization facilities
44.
What term is used to describe the use and distribution of information regardless of title or department?
- A.&nbsp
  Open source information
- B.&nbsp
  Info mining
- C.&nbsp
  Information sharing
- D.&nbsp
  Info distribution
Correct Answer
C. Information sharing
45.
If you were able to quickly pull information from student records with course records to build students' schedules, you would be using a _____ tool.
- A.&nbsp
  Data administration
- B.&nbsp
  Query-by-example
- C.&nbsp
  Data definition
- D.&nbsp
  Data manipulation
Correct Answer
B. Query-by-example
46.
A(n) _____ helps you specify the logical organization for a database and access and use the information within a database.
- A.&nbsp
  DBMS
- B.&nbsp
  ERP
- C.&nbsp
  CRM
- D.&nbsp
  EIS
Correct Answer
A. DBMS

Mis Chapter 3 Study Test (2023)

Which data administration facility allows you to control who has access to what information and what type of access those people have?

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?

Which type of constraint ensures the quality of information in a relational database?

Which application supports the manipulation of information to support decision making?

Which organizational function is responsible for the more technical and operational aspects of managing information repositories?

A(n) _____ is a field or group of fields that uniquely describes each record.

In a data warehouse, which data-mining tool would you use to quickly build reports without having to write programming code?

What type of software tool is used to query information stored in a data warehouse?

Which term refers to a specific piece of information that is stored in a database file?

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?

_____ refers to collective information that gives you the ability to make effective, important, and often strategic business decisions.

Which data manipulation tool allows you to quickly define the formats of needed business reports from information stored in a database?

A(n) _____ key is a primary key of one file that appears in another file.

_____ is the process of reinstalling the backup information in the event the information was lost.

SQL is:

_____ is the gathering of input information, processing that information, and updating existing information to reflect the gathered and processed information.

What must you define before adding any information to a relational database?

Data warehouses exist to support:

_____ are the most essential and important quantifiable measures used in analytics initiatives to monitor success of a business activity.

If you were to perform a regression analysis, what type of data warehouse tool would it be?

If the file containing your student information appears in two different places with two different birth dates, your data would not be considered ____.

What is the most popular model for creating databases?

Which part of a relational database contains the logical structure for the information?

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?

Databases that support OLTP are most often referred to as ____.

_____ are the technology tools that directly support OLTP.

A _____ is a special form of a database that contains information gathered from operational databases for the purpose of supporting decision-making tasks.

A data warehouse is:

_____ is a subset of a data warehouse in which only a focused portion of the data warehouse information is kept.

Which type of database model organizes and accesses information according to its logical structure rather than its physical structure?

_____ ensure the validity of database updates when multiple users attempt to access and change the same information.

A _____ is a collection of information that you organize and access according to the logical structure of that information.

Which data manipulation tool allows you to graphically design the answer to your business questions?

If your phone number was used in a clothing store to uniquely identify you as a customer, the phone number would be considered a(n) ____.

What does it mean for a data warehouse to be multidimensional?

_____ is the science of fact-based decision making.

A _____ is simply a copy of the information stored on a computer.

Which of the following functions plans for, oversees the development of, and monitors the information resource of an organization?

Which type of application requires that you know the physical location of information before you are able to access it?

A(n) _____ displays key information gathered from several sources on a computer screen in a format tailored to the needs and wants of an individual knowledge worker.

_____ facilities find the "shortest route" to the information you want so you don't have to.

Which of the following is true of data administration and database administration?

Which of the following data administration facilities continually maintain statistics concerning how the DBMS engine physically accesses information?

What term is used to describe the use and distribution of information regardless of title or department?

If you were able to quickly pull information from student records with course records to build students' schedules, you would be using a _____ tool.

A(n) _____ helps you specify the logical organization for a database and access and use the information within a database.