Question 1

A one-to-one relationship between two entities is symbolized in a diagram by a line that ends with

Accepted Answer

A)   two short marks.
B)   one short mark.
C)   a crow's foot.
D)   a crow's foot topped by a short mark. A

Question 2

Duplicate data in multiple data files is called data ________.

Accepted Answer

A)   redundancy
B)   repetition
C)   independence
D)   partitions A

Question 3

List and describe three main capabilities or tools of a DBMS.

Accepted Answer

A data definition capability to specify the structure of the content of the database. This capability would be used to create database tables and to define the characteristics of the fields in each table.
A data dictionary to store definitions of data elements in the database and their characteristics. In large corporate databases, the data dictionary may capture additional information, such as usage; ownership; authorization; security; and the individuals, business functions, programs, and reports that use each data element.
A data manipulation language, such as SQL, that is used to add, change, delete, and retrieve the data in the database. This language contains commands that permit end users and programming specialists to extract data from the database to satisfy information requests and develop applications.

Question 4

A data warehouse is typically comprised of several smaller data marts.

Accepted Answer

A) True 
 B)False

Question 5

The organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n)

Accepted Answer

A)   information policy.
B)   data definition file.
C)   data quality audit.
D)   data governance policy.

Question 6

The logical view

Accepted Answer

A)   shows how data are organized and structured on the storage media.
B)   presents an entry screen to the user.
C)   allows the creation of supplementary reports.
D)   presents data as they would be perceived by end users.

Question 7

Program-data dependence refers to the coupling of data stored in files and software programs that use this data such that changes in programs require changes to the data.

Accepted Answer

A) True 
 B)False

Question 8

The specialized language programmers use to add and change data in the database is called

Accepted Answer

A)   a data access language.
B)   a data manipulation language.
C)   structured query language.
D)   a data definition language.

Question 9

List at least three conditions that contribute to data redundancy and inconsistency.

Accepted Answer

The answer of List at least three conditions that contribute...

Question 10

A(n) ________ is software that handles all application operations between browser-based computers and a company's back-end business applications or databases.

Accepted Answer

The answer of A(n) ________ is software that handles all...

Question 11

In a Web-based database, middleware is used to transfer information from the organization's internal database back to the Web server for delivery in the form of a Web page to the user.

Accepted Answer

A) True 
 B)False

Question 12

All of the following are technologies used to analyze and manage big data except

Accepted Answer

A)   cloud computing.
B)   noSQL.
C)   in-memory computing.
D)   analytic platforms.

Question 13

Data cleansing not only corrects errors but also

Accepted Answer

A)   establishes logical relationships between data.
B)   structures data.
C)   normalizes data.
D)   enforces consistency among different sets of data.

Question 14

In ________, a data mining tool discovers different groupings within data, such as finding affinity groups for bank cards.

Accepted Answer

The answer of In ________, a data mining tool discovers...

Question 15

The special organizational function whose responsibilities include physical database design and maintenance, is called

Accepted Answer

A)   data administration.
B)   database administration.
C)   information policy administration.
D)   data auditing.

Question 16

The most prominent data manipulation language today is

Accepted Answer

A)   Access.
B)   DB2.
C)   SQL.
D)   Crystal Reports.

Question 17

Which of the following is not one of the techniques used in Web mining?

Accepted Answer

A)   content mining
B)   structure mining
C)   server mining
D)   user mining

Question 18

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called

Accepted Answer

A)   normalization.
B)   data scrubbing.
C)   data cleansing.
D)   data defining.

Question 19

A schematic of the entire database that describes the relationships in a database is called a(n)

Accepted Answer

A)   data dictionary.
B)   intersection relationship diagram.
C)   entity-relationship diagram.
D)   data definition diagram.

Question 20

In a client/server environment, a DBMS is located on a dedicated computer called a(n) ________.

Accepted Answer

The answer of In a client/server environment, a DBMS is...

Exam 6: Foundations of Business Intelligence: Databases and Information Management

A one-to-one relationship between two entities is symbolized in a diagram by a line that ends with

Duplicate data in multiple data files is called data ________.

List and describe three main capabilities or tools of a DBMS.

A data warehouse is typically comprised of several smaller data marts.

The organization's rules for sharing, disseminating, acquiring, standardizing, classifying, and inventorying information is called a(n)

The logical view

Program-data dependence refers to the coupling of data stored in files and software programs that use this data such that changes in programs require changes to the data.

The specialized language programmers use to add and change data in the database is called

List at least three conditions that contribute to data redundancy and inconsistency.

A(n) ________ is software that handles all application operations between browser-based computers and a company's back-end business applications or databases.

In a Web-based database, middleware is used to transfer information from the organization's internal database back to the Web server for delivery in the form of a Web page to the user.

All of the following are technologies used to analyze and manage big data except

Data cleansing not only corrects errors but also

In ________, a data mining tool discovers different groupings within data, such as finding affinity groups for bank cards.

The special organizational function whose responsibilities include physical database design and maintenance, is called

The most prominent data manipulation language today is

Which of the following is not one of the techniques used in Web mining?

The process of streamlining data to minimize redundancy and awkward many-to-many relationships is called

A schematic of the entire database that describes the relationships in a database is called a(n)

In a client/server environment, a DBMS is located on a dedicated computer called a(n) ________.