Question 1

A(n) ___________ is the common term for the representation of multi-dimensional information.

Accepted Answer

The answer of A(n) ___________ is the common term for...

Question 2

The ______ is accurate and complete.

Accepted Answer

The answer of The ______ is accurate and complete....

Question 3

A(n) ___________ key in the relational database model is a primary key of one table that appears as an attribute in another table.

Accepted Answer

The answer of A(n) ___________ key in the relational database...

Question 4

An entity class (often called a(n) __________) in the relational database model is a collection of similar entities.

Accepted Answer

The answer of An entity class (often called a(n) __________)...

Question 5

What is information redundancy?

Accepted Answer

A)   Duplication of information
B)   Storing the same information in multiple places
C)   Storing duplicate information in multiple places
D)   All of these choices are correct.E) A) and C)
F) B) and D)

Question 6

The ___________ database model is a type of database that stores its information in the form of logically related two-dimensional tables.

Accepted Answer

The answer of The ___________ database model is a type...

Question 7

Explain the relationship between business intelligence and a data warehouse.

Accepted Answer

A data warehouse is an enabler of busine...

Question 8

Bill Inmon, known as the "Father of Data Warehousing" described a data warehouse as a collection of data that is:

Accepted Answer

A)   subject-oriented
B)   integrated and time-variant
C)   non-volatile
D)   All of these choices are correct.E) A) and B)
F) A) and C)

Question 9

Operational systems are designed to perform:

Accepted Answer

A)   Business analysis
B)   Decision support
C)   Decision latency
D)   Transaction processingE) B) and D)
F) A) and D)

Question 10

Which of the following determines which things go together?

Accepted Answer

A)   Classification
B)   Estimation
C)   Affinity grouping
D)   ClusteringE) B) and C)
F) C) and D)

Question 11

Data warehousing is about extending the transformation of ____ into analytical information.

Accepted Answer

A)   transactional data
B)   corporate data
C)   employee data
D)   None of these choices are correct.E) A) and D)
F) A) and C)

Question 12

A data __________ contains a subset of data warehouse information.

Accepted Answer

The answer of A data __________ contains a subset of...

Question 13

All of the following are relational integrity constraints, except

Accepted Answer

A)   System will not allow an entry for an order for a non-existent customer
B)   System will not allow returns of fresh produce after 15 days past delivery
C)   System will not allow shipping a product to a customer who does not have a valid address
D)   Systems will not allow shipping of a non-existent product to a customerE) C) and D)
F) B) and C)

Question 14

Describe the role and purpose of a database management system.

Accepted Answer

A database management system (DBMS) is s...

Question 15

What is a forward integration?

Accepted Answer

A)   Takes information entered into a given system and sends it to the application generation component
B)   Takes information entered into a given system and sends it automatically to all downstream systems and processes
C)   Takes information entered into a given system and sends it automatically to all upstream systems and processes
D)   Takes information entered into a given system and sends it to the DBMSE) A) and B)
F) B) and C)

Question 16

Which of the following is a valid type of integrity constraint?

Accepted Answer

A)   Performance integrity constraint
B)   Scalability integrity constraint
C)   Physical integrity constraint
D)   Business-critical integrity constraintE) All of the above
F) B) and C)

Question 17

To manage and organize various tables within the ________, developers must identify primary keys and foreign keys and use them to create logical relationships.

Accepted Answer

relational...

Question 18

Distinguish between information accuracy and completeness with examples.

Accepted Answer

A birth date of 31/02/1991 is an example...

Question 19

Which of the following is a data mining approach for decision making?

Accepted Answer

A)   Classification
B)   Estimation
C)   Affinity grouping
D)   All of the aboveE) All of the above
F) C) and D)

Question 20

______________ integrity constraints are rules that enforce business rules vital to an organization's success.

Accepted Answer

The answer of ______________ integrity constraints are rules that enforce...

Exam 4: Ethics and Information Security

Which of the following determines which things go together?

Correct AnswerverifiedShow Answer

What is information redundancy?

Correct AnswerverifiedShow Answer

Bill Inmon, known as the "Father of Data Warehousing" described a data warehouse as a collection of data that is:

Correct AnswerverifiedShow Answer

Explain the relationship between business intelligence and a data warehouse.

Correct AnswerverifiedA data warehouse is an enabler of busine...View AnswerShow Answer

Which of the following is a data mining approach for decision making?

Correct AnswerverifiedShow Answer

The ___________ database model is a type of database that stores its information in the form of logically related two-dimensional tables.

Correct AnswerverifiedShow Answer

Data warehousing is about extending the transformation of ____ into analytical information.

Correct AnswerverifiedShow Answer

Operational systems are designed to perform:

Correct AnswerverifiedShow Answer

All of the following are relational integrity constraints, except

Correct AnswerverifiedShow Answer

Describe the role and purpose of a database management system.

Correct AnswerverifiedA database management system (DBMS) is s...View AnswerShow Answer

A(n) ___________ is the common term for the representation of multi-dimensional information.

Correct AnswerverifiedShow Answer

A data __________ contains a subset of data warehouse information.

Correct AnswerverifiedShow Answer

Distinguish between information accuracy and completeness with examples.

Correct AnswerverifiedA birth date of 31/02/1991 is an example...View AnswerShow Answer

The ______ is accurate and complete.

Correct AnswerverifiedShow Answer

______________ integrity constraints are rules that enforce business rules vital to an organization's success.

Correct AnswerverifiedShow Answer

To manage and organize various tables within the ________, developers must identify primary keys and foreign keys and use them to create logical relationships.

Correct Answerverifiedrelational...View AnswerShow Answer

Which of the following is a valid type of integrity constraint?

Correct AnswerverifiedShow Answer

What is a forward integration?

Correct AnswerverifiedShow Answer

A(n) ___________ key in the relational database model is a primary key of one table that appears as an attribute in another table.

Correct AnswerverifiedShow Answer

An entity class (often called a(n) __________) in the relational database model is a collection of similar entities.

Correct AnswerverifiedShow Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A data warehouse is an enabler of busine...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A database management system (DBMS) is s...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
A birth date of 31/02/1991 is an example...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified
relational...
View Answer

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified

Correct Answer
verified