Question 1

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

Accepted Answer

The answer of _____ ensure the validity of database updates...

Question 2

Multidimensional analysis tools use _____ techniques to view information from different perspectives.

Accepted Answer

The answer of Multidimensional analysis tools use _____ techniques to...

Question 3

Your student ID is an example of a(n) _____.

Accepted Answer

A)  Relation 
B)  Table 
C)  Business rule 
D)  Attribute

Question 4

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

Accepted Answer

A) True 
 B)False

Question 5

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) _____.

Accepted Answer

A)  Identifying field 
B)  Relational field 
C)  Primary key 
D)  Principle key

Question 6

_____ are slice-and-dice techniques that allow you to view multidimensional information from different perspectives.

Accepted Answer

The answer of _____ are slice-and-dice techniques that allow you...

Question 7

Business intelligence is one of the hottest topics and markets today.

Accepted Answer

A) True 
 B)False

Question 8

A physical view represents how the users view the data.

Accepted Answer

A) True 
 B)False

Question 9

What is another name for a database that supports OLTP?

Accepted Answer

A)  Business intelligence 
B)  File management 
C)  Records management 
D)  Operational database

Question 10

_____ is business intelligence focused on the external competitive environment.

Accepted Answer

The answer of _____ is business intelligence focused on the...

Question 11

If you need to add a new field to a database, you would use the data manipulation system.

Accepted Answer

A) True 
 B)False

Question 12

A data administration function would include defining and organizing database structures and contents.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following contains a subset of a data warehouse in which only a focused portion of the data is kept?

Accepted Answer

A)  Data mart 
B)  Intelligent agent 
C)  Business intelligent subsystem 
D)  Operational database

Question 14

QBE allows you to query by pointing, clicking, and dragging, unlike SQL.

Accepted Answer

A) True 
 B)False

Question 15

Data 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.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following DBMS components allows you to quickly develop computer routines or tasks that will process your business transactions?

Accepted Answer

A)  Programming query 
B)  Automatic module generator 
C)  Application generation subsystem 
D)  Fast programming

Question 17

Business intelligence encompasses only internal organizational information.

Accepted Answer

A) True 
 B)False

Question 18

What is the objective of business intelligence (BI)?

Accepted Answer

A)  To process transactional information efficiently and effectively 
B)  To provide decisions makers with a great deal of information 
C)  To provide timely and quality information to decision makers 
D)  To process external information or information that is purchased from outside vendors

Question 19

_____ are databases that support OLTP.

Accepted Answer

The answer of _____ are databases that support OLTP....

Question 20

A(n) _____ defines formats of reports and what information you want to see in a report.

Accepted Answer

The answer of A(n) _____ defines formats of reports and...

Exam 3: Databases and Data Warehouses

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

Multidimensional analysis tools use _____ techniques to view information from different perspectives.

Your student ID is an example of a(n) _____.

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

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) _____.

_____ are slice-and-dice techniques that allow you to view multidimensional information from different perspectives.

Business intelligence is one of the hottest topics and markets today.

A physical view represents how the users view the data.

What is another name for a database that supports OLTP?

_____ is business intelligence focused on the external competitive environment.

If you need to add a new field to a database, you would use the data manipulation system.

A data administration function would include defining and organizing database structures and contents.

Which of the following contains a subset of a data warehouse in which only a focused portion of the data is kept?

QBE allows you to query by pointing, clicking, and dragging, unlike SQL.

Data 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.

Which of the following DBMS components allows you to quickly develop computer routines or tasks that will process your business transactions?

Business intelligence encompasses only internal organizational information.

What is the objective of business intelligence (BI) ?

_____ are databases that support OLTP.

A(n) _____ defines formats of reports and what information you want to see in a report.