Question 1

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

Accepted Answer

This is an example of "unclean" information.(Your name appears twice in a database,once with your middle initial and once without it.Or your name may appear twice in a database with two different spellings of your last name. )

Question 2

Databases and DBMSs are the technology tools that directly support OLAP.

Accepted Answer

Databases and DBMSs are the technology tools that directly support OLTP.

Question 3

The DBMS engine can process virtually any logical information view or request into its physical equivalent.

Accepted Answer

The DBMS engine can process virtually any logical information view or request into its physical equivalent.

Question 4

When you build a data warehouse and use data-mining tools to manipulate the data warehouse's information,you are actively engaging in analytics.

Accepted Answer

When you build a data warehouse and use data-mining tools to manipulate the data warehouse's information,you are actively engaging in analytics.

Question 5

When you create a database,you first create its data dictionary.

Accepted Answer

In the relational database model,a data dictionary contains the logical structure for the information in a database.When you create a database,you first create its data dictionary.The data dictionary contains important information (or logical properties)about your information.

Question 6

QBEs rely heavily on the physical relationships within a database to find information.

Accepted Answer

QBEs rely heavily on the logical relationships within a database to find information.

Question 7

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

Accepted Answer

Database administration is the function in an organization that is responsible for the more technical and operational aspects of managing the information contained in organizational information repositories (databases,data warehouses,and data marts).

Question 8

Business intelligence is a component of the overall framework or field of analytics.

Accepted Answer

Business intelligence is a resource/component of the overall framework or field of analytics.

Question 9

A primary key from one file and a foreign key from another file are used to create a relationship between two files in a relational database.

Accepted Answer

A foreign key is a primary key of one file that appears in another file.Foreign keys are essential in the relational database model.Without them,you have no way of creating logical ties among the various files.We use these relationships extensively to create business intelligence because they enable us to track the logical relationships within many types of information.

Question 10

A relational database model uses a series of physically related two-dimensional tables or files to store information in the form of a database.

Accepted Answer

It uses a series of logically related two-dimensional tables or files to store information in the form of a database.

Question 11

Which of the following is true of data administration and database administration?
A)Data administration focuses on the development of the data dictionary whereas database administration focuses on the raw data.
B)Data administration focuses on OLTP whereas database administration focuses on OLAP.
C)Data administration and database administration are terms that can be used interchangeably.
D)Data administration focuses on strategic management whereas database administration focuses on operational issues.

Accepted Answer

Data administration is the function in an organization that plans for,oversees the development of,and monitors the information resource.This function must be completely in tune with the strategic direction of the organization to assure that all information requirements can be and are being met.Database administration is the function in an organization that is responsible for the more technical and operational aspects of managing the information contained in organizational information repositories (databases,data warehouses,and data marts).

Question 12

The most popular database model is the hierarchical database model.

Accepted Answer

The most popular database model is the relational database model.

Question 13

What term is used to describe the use and distribution of information regardless of title or department?
A)Open source information
B)Info mining
C)Information sharing
D)Info distribution

Accepted Answer

Information sharing in your organization means that anyone,regardless of title or department,can access and use whatever information he or she needs.

Question 14

There is only one logical view of information but there may be numerous knowledge workers who have different physical views of the information in a database.

Accepted Answer

There is only one physical view of information but there may be numerous knowledge workers who have different logical views of the information in a database.

Question 15

A report generator allows you to see the contents of a database file,make whatever changes you want,perform simple sorting,and query to find the location of specific information.

Accepted Answer

A view allows you to see the contents of a database file,make whatever changes you want,perform simple sorting,and query to find the location of specific information.

Question 16

The physical view of information focuses on how you as a knowledge worker need to arrange and access information to meet your particular business needs.

Accepted Answer

The physical view of information deals with how information is physically arranged,stored,and accessed on some type of storage device such as a hard disk.The logical view of information,on the other hand,focuses on how you as a knowledge worker need to arrange and access information to meet your particular business needs.

Question 17

You can create logical ties among various files only in the absence of foreign keys.

Accepted Answer

Without foreign keys,you have no way of creating logical ties among the various files.

Question 18

When you create a database,you must first use the data definition subsystem to create the data dictionary and define the structure of the files.

Accepted Answer

When you create a database,you must first use the data definition subsystem to create the data dictionary and define the structure of the files.

Question 19

A foreign key is also a primary key.

Accepted Answer

A foreign key is a primary key of one file that appears in another file.

Question 20

If a salesperson attempts to order merchandise for a customer who should but does not exist in the customer database,the database will typically generate an error message.This message indicates that an integrity constraint has been violated.

Accepted Answer

By defining the logical structure of information in a relational database,you're also developing integrity constraints-rules that help ensure the quality of the information.

Quiz 3: Databases and Data Warehouses: Supporting the Analytics-Driven Organization

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

Databases and DBMSs are the technology tools that directly support OLAP.

The DBMS engine can process virtually any logical information view or request into its physical equivalent.

When you build a data warehouse and use data-mining tools to manipulate the data warehouse's information,you are actively engaging in analytics.

When you create a database,you first create its data dictionary.

QBEs rely heavily on the physical relationships within a database to find information.

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

Business intelligence is a component of the overall framework or field of analytics.

A primary key from one file and a foreign key from another file are used to create a relationship between two files in a relational database.

A relational database model uses a series of physically related two-dimensional tables or files to store information in the form of a database.

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

The most popular database model is the hierarchical database model.

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

There is only one logical view of information but there may be numerous knowledge workers who have different physical views of the information in a database.

A report generator allows you to see the contents of a database file,make whatever changes you want,perform simple sorting,and query to find the location of specific information.

The physical view of information focuses on how you as a knowledge worker need to arrange and access information to meet your particular business needs.

You can create logical ties among various files only in the absence of foreign keys.

When you create a database,you must first use the data definition subsystem to create the data dictionary and define the structure of the files.

A foreign key is also a primary key.

If a salesperson attempts to order merchandise for a customer who should but does not exist in the customer database,the database will typically generate an error message.This message indicates that an integrity constraint has been violated.