Question 1

One goal of normalization is to make ________.

Accepted Answer

A)  duplicate copies of essential information 
B)  primary keys correspond to all tables 
C)  data hierarchically dependent 
D)  data functionally dependent 
A)  duplicate copies of essential information 
B)  primary keys correspond to all tables 
C)  data hierarchically dependent 
D)  data functionally dependent

Question 2

Structured query language is a standard query language ________.

Accepted Answer

A)  used to manipulate information in relational databases 
B)  which uses the signals transmitted via the phone to access databases 
C)  that offers voice commands as a means to access a database 
D)  used to enhance security, plan capacity requirements, and design backup 
A)  used to manipulate information in relational databases 
B)  which uses the signals transmitted via the phone to access databases 
C)  that offers voice commands as a means to access a database 
D)  used to enhance security, plan capacity requirements, and design backup

Question 3

In an organization, each employee might work for one or more projects, as well as for different employers. In such a case, the best approach by a database manager would be to create multiple records for the employee.

Accepted Answer

A) True 
 B)False

Question 4

Shadow systems are managed by individuals or departments.

Accepted Answer

A) True 
 B)False

Question 5

While saving her word-processed academic documents, Ashley includes the subject, title, and the author's name in the properties. Which type of information is she adding to her document?

Accepted Answer

A)  metadata 
B)  sharded data 
C)  factual data 
D)  clerical data 
A)  metadata 
B)  sharded data 
C)  factual data 
D)  clerical data

Question 6

Which of the following is an advantage of using shadow systems?

Accepted Answer

A)  the ability to document the system 
B)  the ability to automate the system 
C)  the ability to control data in the system 
D)  the ability to support the system 
A)  the ability to document the system 
B)  the ability to automate the system 
C)  the ability to control data in the system 
D)  the ability to support the system

Question 7

In a firm, an employee might be working on any number of projects, each of which can have any number of employees assigned to it. In the context of database architecture, this is an example of a ________ relationship.

Accepted Answer

A)  one-to-many 
B)  many-to-one 
C)  many-to-many 
D)  one-to-one 
A)  one-to-many 
B)  many-to-one 
C)  many-to-many 
D)  one-to-one

Question 8

In enterprise information management, data ownership issues arise because ________.

Accepted Answer

A)  data is often taken from external sources 
B)  the quality of data varies across departments 
C)  data is often stored in databases on external servers 
D)  data is shared by all the stakeholders in the organization 
A)  data is often taken from external sources 
B)  the quality of data varies across departments 
C)  data is often stored in databases on external servers 
D)  data is shared by all the stakeholders in the organization

Question 9

Shards should be accessed from the same computer for improved performance.

Accepted Answer

A) True 
 B)False

Question 10

Which of the following database architectures works well for one-to-many relationships, but is not effective with many-to-many relationships?

Accepted Answer

A)  network database 
B)  hierarchical database 
C)  object-oriented database 
D)  cluster database 
A)  network database 
B)  hierarchical database 
C)  object-oriented database 
D)  cluster database

Question 11

How are databases used across organizational boundaries? Illustrate with an example.

Accepted Answer

In databases without boundaries, people

Question 12

What are the database ownership issues faced by management at a typical company?

Accepted Answer

A company may set the policy that all in

Question 13

Companies often use the same relational DBMS for their data warehouse as they use for their operational database, but loaded onto a separate server and tuned for fast retrieval and reporting.

Accepted Answer

A) True 
 B)False

Question 14

Which of the following is a good master data management strategy?

Accepted Answer

A)  upgrading technology 
B)  creating shadow systems 
C)  creating a database schema 
D)  focusing on limited, key entities 
A)  upgrading technology 
B)  creating shadow systems 
C)  creating a database schema 
D)  focusing on limited, key entities

Question 15

Trekking blindly into terabytes of data to sniff out meaningless relationships that occur just by accident is called ________.

Accepted Answer

A)  data mining 
B)  data dredging 
C)  data sharding 
D)  normalizing 
A)  data mining 
B)  data dredging 
C)  data sharding 
D)  normalizing

Question 16

Define relational database. Why has it been predicted that the relational database will be the mainstay for organizations in the years ahead?

Accepted Answer

Relational database is the most widely u

Question 17

A credit card company wants to spot elusive patterns in credit card transaction records to be able to block fraudulent transactions. This company should use ________.

Accepted Answer

A)  data mining 
B)  data warehouse appliance 
C)  data dredging 
D)  database schema 
A)  data mining 
B)  data warehouse appliance 
C)  data dredging 
D)  database schema

Question 18

Compared to unstructured information, semi-structured information ________.

Accepted Answer

A)  is more difficult to break down 
B)  has no inherent order 
C)  is easier to query and aggregate 
D)  is more difficult to link together 
A)  is more difficult to break down 
B)  has no inherent order 
C)  is easier to query and aggregate 
D)  is more difficult to link together

Question 19

The operational database is not a good candidate for high-level management reporting because it is not equipped to ________.

Accepted Answer

A)  handle complex queries for strategic planning 
B)  support a format that is easily applied to what-if type questioning 
C)  manipulate business performance related information 
D)  draw high-quality information from an organization's databases 
A)  handle complex queries for strategic planning 
B)  support a format that is easily applied to what-if type questioning 
C)  manipulate business performance related information 
D)  draw high-quality information from an organization's databases

Question 20

David Geilhufe of the Social Source Foundation worked with a team of volunteers to create a standardized data format called ________.

Accepted Answer

A)  Structured Query Format 
B)  Volunteer Finder Format 
C)  the People Finder Interchange Format 
D)  Data Language Format 
A)  Structured Query Format 
B)  Volunteer Finder Format 
C)  the People Finder Interchange Format 
D)  Data Language Format

One goal of normalization is to make ________.

Structured query language is a standard query language ________.

In an organization, each employee might work for one or more projects, as well as for different employers. In such a case, the best approach by a database manager would be to create multiple records for the employee.

Shadow systems are managed by individuals or departments.

While saving her word-processed academic documents, Ashley includes the subject, title, and the author's name in the properties. Which type of information is she adding to her document?

Which of the following is an advantage of using shadow systems?

In a firm, an employee might be working on any number of projects, each of which can have any number of employees assigned to it. In the context of database architecture, this is an example of a ________ relationship.

In enterprise information management, data ownership issues arise because ________.

Shards should be accessed from the same computer for improved performance.

Which of the following database architectures works well for one-to-many relationships, but is not effective with many-to-many relationships?

How are databases used across organizational boundaries? Illustrate with an example.

What are the database ownership issues faced by management at a typical company?

Companies often use the same relational DBMS for their data warehouse as they use for their operational database, but loaded onto a separate server and tuned for fast retrieval and reporting.

Which of the following is a good master data management strategy?

Trekking blindly into terabytes of data to sniff out meaningless relationships that occur just by accident is called ________.

Define relational database. Why has it been predicted that the relational database will be the mainstay for organizations in the years ahead?

A credit card company wants to spot elusive patterns in credit card transaction records to be able to block fraudulent transactions. This company should use ________.

Compared to unstructured information, semi-structured information ________.

The operational database is not a good candidate for high-level management reporting because it is not equipped to ________.

David Geilhufe of the Social Source Foundation worked with a team of volunteers to create a standardized data format called ________.

Information Systems and People

Systems Development and Procurement

Project Management and Strategic Planning

Information Systems and Strategy

Information and Communications Technologies: The Enterprise Architecture

Information Systems for the Enterprise

The Web and E-Commerce

Ethics, Privacy, and Security

Business Intelligence and Decision Support

Collaborating with Technology

Knowledge Management and E-Learning

Filters

Exam 4: Managing Information Resources with Databases

One goal of normalization is to make ________.

Structured query language is a standard query language ________.

In an organization, each employee might work for one or more projects, as well as for different employers. In such a case, the best approach by a database manager would be to create multiple records for the employee.

Shadow systems are managed by individuals or departments.

While saving her word-processed academic documents, Ashley includes the subject, title, and the author's name in the properties. Which type of information is she adding to her document?

Which of the following is an advantage of using shadow systems?

In a firm, an employee might be working on any number of projects, each of which can have any number of employees assigned to it. In the context of database architecture, this is an example of a ________ relationship.

In enterprise information management, data ownership issues arise because ________.

Shards should be accessed from the same computer for improved performance.

Which of the following database architectures works well for one-to-many relationships, but is not effective with many-to-many relationships?

How are databases used across organizational boundaries? Illustrate with an example.

What are the database ownership issues faced by management at a typical company?

Companies often use the same relational DBMS for their data warehouse as they use for their operational database, but loaded onto a separate server and tuned for fast retrieval and reporting.

Which of the following is a good master data management strategy?

Trekking blindly into terabytes of data to sniff out meaningless relationships that occur just by accident is called ________.

Define relational database. Why has it been predicted that the relational database will be the mainstay for organizations in the years ahead?

A credit card company wants to spot elusive patterns in credit card transaction records to be able to block fraudulent transactions. This company should use ________.

Compared to unstructured information, semi-structured information ________.

The operational database is not a good candidate for high-level management reporting because it is not equipped to ________.

David Geilhufe of the Social Source Foundation worked with a team of volunteers to create a standardized data format called ________.

Information Systems and People

Systems Development and Procurement

Project Management and Strategic Planning

Information Systems and Strategy

Information and Communications Technologies: The Enterprise Architecture

Information Systems for the Enterprise

The Web and E-Commerce

Ethics, Privacy, and Security

Business Intelligence and Decision Support

Collaborating with Technology

Knowledge Management and E-Learning

Filters