Question 1

Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?

Accepted Answer

A) Database element 
B) Database management system 
C) Data governance 
D) Data File 
A) Database element 
B) Database management system 
C) Data governance 
D) Data File

Question 2

Relational database management system allows users to create, read, update, and delete data in a relational database.

Accepted Answer

A) True 
 B)False

Question 3

What maintains information about various types of objects, events, people, and places?

Accepted Answer

A) Database 
B) Data model 
C) Data mining 
D) Data intelligence 
A) Database 
B) Data model 
C) Data mining 
D) Data intelligence

Question 4

What is a foreign key?

Accepted Answer

A) A field (or group of fields) that uniquely identifies a given entity in a table. 
B) A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables. 
C) Characteristics or properties of an entity. 
D) A field (or group of fields) that uniquely identifies a given attribute in a table. 
A) A field (or group of fields) that uniquely identifies a given entity in a table. 
B) A primary key of one table that appears as an attribute in another table and acts to provide a logical relationship among the two tables. 
C) Characteristics or properties of an entity. 
D) A field (or group of fields) that uniquely identifies a given attribute in a table.

Question 5

Integrity constraints are rules that help ensure the quality of information.

Accepted Answer

A) True 
 B)False

Question 6

The example the book gave of www.EllisIsland.org, which generates more than 2.5 billion hits, is a site that offers a database that can easily adjust to handle massive volumes of information.What is this an example of?

Accepted Answer

A) Increased scalability and performance 
B) Increased information security 
C) Reduced information redundancy 
D) Increased flexibility 
A) Increased scalability and performance 
B) Increased information security 
C) Reduced information redundancy 
D) Increased flexibility

Question 7

What is immediate, up-to-date information?

Accepted Answer

A) Real-time information 
B) Real-time systems 
C) Information granularity 
D) Information governance 
A) Real-time information 
B) Real-time systems 
C) Information granularity 
D) Information governance

Question 8

Real-time information refers to the extent of detail within the information (fine and detailed or coarse and abstract).

Accepted Answer

A) True 
 B)False

Question 9

Complete information asks if there is an incorrect value in the information.

Accepted Answer

A) True 
 B)False

Question 10

What is dynamic information?

Accepted Answer

A) The person responsible for creating the original website content. 
B) The person responsible for updating and maintaining website content. 
C) Includes fixed data incapable of change in the event of a user action. 
D) Includes data that change based on user action. 
A) The person responsible for creating the original website content. 
B) The person responsible for updating and maintaining website content. 
C) Includes fixed data incapable of change in the event of a user action. 
D) Includes data that change based on user action.

Question 11

Data stewardship is the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner.

Accepted Answer

A) True 
 B)False

Question 12

Relational databases offer many advantages over using a text document or a spreadsheet, which include decreased flexibility and decreased scalability and performance.

Accepted Answer

A) True 
 B)False

Question 13

What is one of the biggest pitfalls associated with real-time information?

Accepted Answer

A) It is only available to high-level executives due to the expense. 
B) It is only available in aggregate levels of granularity. 
C) It continually changes. 
D) It rarely changes. 
A) It is only available to high-level executives due to the expense. 
B) It is only available in aggregate levels of granularity. 
C) It continually changes. 
D) It rarely changes.

Question 14

Master data management is a broad administrative area that deals with identifying individuals in a system (such as a country, a network, or an enterprise) and controlling their access to resources within that system by associating user rights and restrictions with the established identity.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table?

Accepted Answer

A) Entity 
B) Extraction 
C) Attribute 
D) Foreign key 
A) Entity 
B) Extraction 
C) Attribute 
D) Foreign key

Question 16

The physical view of information focuses on how individual users logically access information to meet their own particular business needs.

Accepted Answer

A) True 
 B)False

Question 17

The physical view of information deals with the physical storage of information on a storage device.

Accepted Answer

A) True 
 B)False

Question 18

Data element (or data field) is the smallest, or basic, unit of information.

Accepted Answer

A) True 
 B)False

Question 19

A forward integration takes information entered into a given system and sends it automatically to all upstream systems and processes.

Accepted Answer

A) True 
 B)False

Question 20

Data latency is the time it takes for data to be stored or retrieved.

Accepted Answer

A) True 
 B)False

Exam 6: Valuing and Storing Organizational Information Databases

Which of the following creates, reads, updates, and deletes data in a database while controlling access and security?

Relational database management system allows users to create, read, update, and delete data in a relational database.

What maintains information about various types of objects, events, people, and places?

What is a foreign key?

Integrity constraints are rules that help ensure the quality of information.

The example the book gave of www.EllisIsland.org, which generates more than 2.5 billion hits, is a site that offers a database that can easily adjust to handle massive volumes of information.What is this an example of?

What is immediate, up-to-date information?

Real-time information refers to the extent of detail within the information (fine and detailed or coarse and abstract).

Complete information asks if there is an incorrect value in the information.

What is dynamic information?

Data stewardship is the management and oversight of an organization's data assets to help provide business users with high-quality data that is easily accessible in a consistent manner.

Relational databases offer many advantages over using a text document or a spreadsheet, which include decreased flexibility and decreased scalability and performance.

What is one of the biggest pitfalls associated with real-time information?

Master data management is a broad administrative area that deals with identifying individuals in a system (such as a country, a network, or an enterprise) and controlling their access to resources within that system by associating user rights and restrictions with the established identity.

Which of the following stores information about a person, place, thing, transaction, or event, and is usually referred to as a table?

The physical view of information focuses on how individual users logically access information to meet their own particular business needs.

The physical view of information deals with the physical storage of information on a storage device.

Data element (or data field) is the smallest, or basic, unit of information.

A forward integration takes information entered into a given system and sends it automatically to all upstream systems and processes.

Data latency is the time it takes for data to be stored or retrieved.

Business Driven Technology

Identifying Competitive Advantages

Strategic Initiatives for Implementing Competitive Advantages

Measuring the Success of Strategic Initiatives

Organizational Structures That Support Strategic Initiatives

Accessing Organizational Information Data Warehouses

Understanding Big Data and Its Impact on Business

Enabling the Organization Decision Making

Extending the Organization Supply Chain Management

Building a Customer-Centric Organization Customer Relationship Management

Integrating the Organization From End to End Enterprise Resource Planning

Creating Innovative Organizations

E-business

Creating Collaborative Partnerships

Integrating Wireless Technology in Business

Developing Software to Streamline Operations

Methodologies for Supporting Agile Organizations

Managing Organizational Projects

B: Extension: A Business Basics

B: Extension: A Business Process

B: Extension: A Hardware and Software Basics

B: Extension: A Mis Infrastructures

B: Extension: A Networks and Telecommunications

B: Extension: A Information Security

B: Extension: A Ethics

B: Extension: A Operations Management

B: Extension: A Sustainable Mis Infrastructures

B: Extension: A Business Intelligence

B: Extension: A Global Information Systems

B: Extension: A Global Trends

Filters