Question 1

Describe the update set-to-default option (for implementing a referential integrity constraint).

Accepted Answer

The update set-to-default option allows

Question 2

Which of the following describes the completeness data quality characteristic?

Accepted Answer

A) The degree to which all the required data is present in the data collection 
B) The characteristic that requires each real-world instance to be represented only once in the data collection 
C) The extent to which the data properly conforms to and matches up with the other data 
D) The degree to which the data is aligned with the proper time window in its representation of the real world 
A) The degree to which all the required data is present in the data collection 
B) The characteristic that requires each real-world instance to be represented only once in the data collection 
C) The extent to which the data properly conforms to and matches up with the other data 
D) The degree to which the data is aligned with the proper time window in its representation of the real world

Question 3

ARC UNIVERSITY
Observe the following scenario in ARC UNIVERSITY,taking place in 2013.An office worker was given a task to enter into a table all currently enrolled students at ARC UNIVERSITY.He just started and so far he has correctly entered five records,shown in the table CURRENTLY ENROLLED STUDENTS.There are no errors in any of the five records entered so far.

CURRENTLY ENROLLED STUDENTS (YEAR 2013)

This scenario will be used for the following questions citing table CURRENTLY ENROLLED STUDENTS.
-Observe the three records below that are NOT YET entered in the table CURRENTLY ENROLLED STUDENTS.(Assume all the shown values in all three records are correct. )

Which of these three records that are not yet entered should be entered into the table CURRENTLY ENROLLED STUDENTS in order to avoid the timeliness problem?

Accepted Answer

A) The record with Student ID value 201001 (for student Susan Smith) 
B) The record with Student ID value 201002 (for student Meg Still) 
C) The record with Student ID value 201003 (for student Alex Soto) 
D) All three records 
A) The record with Student ID value 201001 (for student Susan Smith) 
B) The record with Student ID value 201002 (for student Meg Still) 
C) The record with Student ID value 201003 (for student Alex Soto) 
D) All three records

Question 4

Describe the delete set-to-null option (for implementing a referential integrity constraint).

Accepted Answer

The delete set-to-null option allows a r

Question 5

ARC UNIVERSITY
Observe the following scenario in ARC UNIVERSITY,taking place in 2013.An office worker was given a task to enter into a table all currently enrolled students at ARC UNIVERSITY.He just started and so far he has correctly entered five records,shown in the table CURRENTLY ENROLLED STUDENTS.There are no errors in any of the five records entered so far.

CURRENTLY ENROLLED STUDENTS (YEAR 2013)

This scenario will be used for the following questions citing table CURRENTLY ENROLLED STUDENTS.
-If the office worker inserts the record below into the table CURRENTLY ENROLLED STUDENTS,which problem will occur? (Assume that all the dates in the record below are correct. )

Accepted Answer

A) Accuracy 
B) Completeness 
C) Conformity 
D) No data quality problem with this record 
A) Accuracy 
B) Completeness 
C) Conformity 
D) No data quality problem with this record

Question 6

HAPPY INSURANCE

Observe the HAPPY INSURANCE DATABASE:
CLIENT
 $$\begin{array} { l l c l } 
\text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \
\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \
\text { C222 } & \text { Kain } & A 1 & \text { Bill } \
\text { C333 } & \text { Cole } & A 2 & \text { Amy } \
\text { C444 } & \text { Dorothy } & A 2 & \
\text { C555 } & \text { Anay } & A 3 & \text { Amy } \
\text { C666 } & \text { Tina } & A 3 & \text { Matt } \
\text { C777 } & \text { Christina } & A 4 & \text { Mike }
\end{array}$$ AGENT
 $$\begin{array} { l l l l l c } 
\text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \
\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \
\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \
\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \
\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }
\end{array}$$ AREA
 $$\begin{array} { l l l } 
\text { ArealD } & \text { AreaName } & \text { AreaHQ } \
1 & \text { East } & \text { Boston } \
2 & \text { West } & \text { San Francisco } \
3 & \text { Central } & \text { Chicago }
\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.
-If a DBMS enforces a DELETE RESTRICT option on the referential integrity constraint between CLIENT and AGENT in the HAPPY INSURANCE database,what will be the outcome after aUser tries to delete the last record (C777,Christina,A4,Mike)from CLIENT?

Accepted Answer

A) CLIENT will have 7 records
AGENT will have 4 records 
B) CLIENT will have 6 records
AGENT will have 3 records 
C) CLIENT will have 7 records
AGENT will have 3 records 
D) CLIENT will have 6 records
AGENT will have 4 records 
A) CLIENT will have 7 records
AGENT will have 4 records 
B) CLIENT will have 6 records
AGENT will have 3 records 
C) CLIENT will have 7 records
AGENT will have 3 records 
D) CLIENT will have 6 records
AGENT will have 4 records

Question 7

HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT
 
$$\begin{array} { l l c l } 
\text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \
\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \
\text { C222 } & \text { Kain } & A 1 & \text { Bill } \
\text { C333 } & \text { Cole } & A 2 & \text { Amy } \
\text { C444 } & \text { Dorothy } & A 2 & \
\text { C555 } & \text { Anay } & A 3 & \text { Amy } \
\text { C666 } & \text { Tina } & A 3 & \text { Madt } \
\text { C777 } & \text { Christina } & A 4 & \text { Mike }
\end{array}$$ AGENT
 $$\begin{array} { l l l l l c } 
\text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \
\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \
\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \
\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \
\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }
\end{array}$$ AREA
 $$\begin{array} { l l l } 
\text { ArealD } & \text { AreaName } & \text { AreaHQ } \
1 & \text { East } & \text { Boston } \
2 & \text { West } & \text { San Francisco } \
3 & \text { Central } & \text { Chicago }
\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.
-If a DBMS enforces in the HAPPY INSURANCE database a DELETE RESTRICT option on the referential integrity constraint between AREA and AGENT,and a DELETE CASCADE between AGENT and CLIENT,the first record in the table AREA can be deleted.

Accepted Answer

A) True 
 B)False

Question 8

What is a trigger?

Accepted Answer

A trigger is a rule that is ac

Question 9

HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT
 
$$\begin{array} { l l c l } 
\text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \
\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \
\text { C222 } & \text { Kain } & A 1 & \text { Bill } \
\text { C333 } & \text { Cole } & A 2 & \text { Amy } \
\text { C444 } & \text { Dorothy } & A 2 & \
\text { C555 } & \text { Anay } & A 3 & \text { Amy } \
\text { C666 } & \text { Tina } & A 3 & \text { Madt } \
\text { C777 } & \text { Christina } & A 4 & \text { Mike }
\end{array}$$ AGENT
 $$\begin{array} { l l l l l c } 
\text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \
\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \
\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \
\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \
\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }
\end{array}$$ AREA
 $$\begin{array} { l l l } 
\text { ArealD } & \text { AreaName } & \text { AreaHQ } \
1 & \text { East } & \text { Boston } \
2 & \text { West } & \text { San Francisco } \
3 & \text { Central } & \text { Chicago }
\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.
-If a DBMS enforces in the HAPPY INSURANCE database a DELETE RESTRICT option on the referential integrity constraint between AGENT and AGENT (i.e. ,circular referential integrity constraint for table AGENT)in the HAPPY INSURANCE database,and a DELETE CASCADE between AGENT and CLIENT,the second record in the table AGENT can be deleted.

Accepted Answer

A) True 
 B)False

Question 10

Mandating instantaneous entry of all new data is an example of a preventive data quality action.

Accepted Answer

A) True 
 B)False

Question 11

What are preventive data quality actions?

Accepted Answer

Preventive data qual

Question 12

What is the purpose of an index?

Accepted Answer

An index is a mechanism for in

Question 13

Describe the delete set-to-default option (for implementing a referential integrity constraint).

Accepted Answer

The delete set-to-default option allows

Question 14

HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT
 
$$\begin{array} { l l c l } 
\text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \
\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \
\text { C222 } & \text { Kain } & A 1 & \text { Bill } \
\text { C333 } & \text { Cole } & A 2 & \text { Amy } \
\text { C444 } & \text { Dorothy } & A 2 & \
\text { C555 } & \text { Anay } & A 3 & \text { Amy } \
\text { C666 } & \text { Tina } & A 3 & \text { Madt } \
\text { C777 } & \text { Christina } & A 4 & \text { Mike }
\end{array}$$ AGENT
 $$\begin{array} { l l l l l c } 
\text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \
\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \
\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \
\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \
\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }
\end{array}$$ AREA
 $$\begin{array} { l l l } 
\text { ArealD } & \text { AreaName } & \text { AreaHQ } \
1 & \text { East } & \text { Boston } \
2 & \text { West } & \text { San Francisco } \
3 & \text { Central } & \text { Chicago }
\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.
-If a DBMS enforces in the HAPPY INSURANCE database an UPDATE RESTRICT option on the referential integrity constraint between AGENT and AGENT (i.e. ,circular referential referential integrity constraint for table AGENT)in the HAPPY INSURANCE database,and an UPDATE CASCADE between AGENT and CLIENT,value A1 in the second record in the table AGENT can be changed to A5.

Accepted Answer

A) True 
 B)False

Question 15

HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT
 
$$\begin{array} { l l c l } 
\text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \
\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \
\text { C222 } & \text { Kain } & A 1 & \text { Bill } \
\text { C333 } & \text { Cole } & A 2 & \text { Amy } \
\text { C444 } & \text { Dorothy } & A 2 & \
\text { C555 } & \text { Anay } & A 3 & \text { Amy } \
\text { C666 } & \text { Tina } & A 3 & \text { Madt } \
\text { C777 } & \text { Christina } & A 4 & \text { Mike }
\end{array}$$ AGENT
 $$\begin{array} { l l l l l c } 
\text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \
\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \
\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \
\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \
\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }
\end{array}$$ AREA
 $$\begin{array} { l l l } 
\text { ArealD } & \text { AreaName } & \text { AreaHQ } \
1 & \text { East } & \text { Boston } \
2 & \text { West } & \text { San Francisco } \
3 & \text { Central } & \text { Chicago }
\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.
-If a DBMS enforces in the HAPPY INSURANCE database a DELETE RESTRICT option on the referential integrity constraint between AGENT and AGENT (i.e. ,circular referential integrity constraint for table AGENT)in the HAPPY INSURANCE database,and a DELETE CASCADE between AGENT and CLIENT,the first record in the table AGENT can be deleted.

Accepted Answer

A) True 
 B)False

Question 16

Which of the following describes the conformity data quality characteristic?

Accepted Answer

A) The degree to which all the required data is present in the data collection 
B) The extent to which the data properly conforms to and matches up with the other data 
C) The extent to which data correctly reflects the real world instances it is supposed to depict 
D) The extent to which the data conforms to its specified format 
A) The degree to which all the required data is present in the data collection 
B) The extent to which the data properly conforms to and matches up with the other data 
C) The extent to which data correctly reflects the real world instances it is supposed to depict 
D) The extent to which the data conforms to its specified format

Question 17

HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT
 
$$\begin{array} { l l c l } 
\text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \
\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \
\text { C222 } & \text { Kain } & A 1 & \text { Bill } \
\text { C333 } & \text { Cole } & A 2 & \text { Amy } \
\text { C444 } & \text { Dorothy } & A 2 & \
\text { C555 } & \text { Anay } & A 3 & \text { Amy } \
\text { C666 } & \text { Tina } & A 3 & \text { Madt } \
\text { C777 } & \text { Christina } & A 4 & \text { Mike }
\end{array}$$ AGENT
 $$\begin{array} { l l l l l c } 
\text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \
\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \
\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \
\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \
\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }
\end{array}$$ AREA
 $$\begin{array} { l l l } 
\text { ArealD } & \text { AreaName } & \text { AreaHQ } \
1 & \text { East } & \text { Boston } \
2 & \text { West } & \text { San Francisco } \
3 & \text { Central } & \text { Chicago }
\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.
-If a DBMS enforces in the HAPPY INSURANCE database a DELETE RESTRICT option on the referential integrity constraint between AREA and AGENT,and a DELETE CASCADE between AGENT and CLIENT,the first record in the table AGENT can be deleted.

Accepted Answer

A) True 
 B)False

Question 18

HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT
 
$$\begin{array} { l l c l } 
\text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \
\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \
\text { C222 } & \text { Kain } & A 1 & \text { Bill } \
\text { C333 } & \text { Cole } & A 2 & \text { Amy } \
\text { C444 } & \text { Dorothy } & A 2 & \
\text { C555 } & \text { Anay } & A 3 & \text { Amy } \
\text { C666 } & \text { Tina } & A 3 & \text { Matt } \
\text { C777 } & \text { Christina } & A 4 & \text { Mike }
\end{array}$$ AGENT
 $$\begin{array} { l l l l l l } 
\text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearOfHire } & \text { SupervisedBy } \
\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \
\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { A1 } \
\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \
\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }
\end{array}$$ AREA
 $$\begin{array} { l l l } 
\text { ArealD } & \text { AreaName } & \text { AreaHQ } \
1 & \text { East } & \text { Boston } \
2 & \text { West } & \text { San Francisco } \
3 & \text { Central } & \text { Chicago }
\end{array}$$
This database will be used for the following questions citing tables from the HAPPY INSURANCE database.
-Show the SQL statement that will for HAPPY INSURANCE database create and index on the ClientName column of the table CLIENT.

Accepted Answer

CREATE INDEX clientn

Question 19

HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT
 
$$\begin{array} { l l c l } 
\text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \
\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \
\text { C222 } & \text { Kain } & A 1 & \text { Bill } \
\text { C333 } & \text { Cole } & A 2 & \text { Amy } \
\text { C444 } & \text { Dorothy } & A 2 & \
\text { C555 } & \text { Anay } & A 3 & \text { Amy } \
\text { C666 } & \text { Tina } & A 3 & \text { Madt } \
\text { C777 } & \text { Christina } & A 4 & \text { Mike }
\end{array}$$ AGENT
 $$\begin{array} { l l l l l c } 
\text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \
\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \
\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \
\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \
\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }
\end{array}$$ AREA
 $$\begin{array} { l l l } 
\text { ArealD } & \text { AreaName } & \text { AreaHQ } \
1 & \text { East } & \text { Boston } \
2 & \text { West } & \text { San Francisco } \
3 & \text { Central } & \text { Chicago }
\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.
-If a DBMS enforces in the HAPPY INSURANCE database an UPDATE RESTRICT option on the referential integrity constraint between AGENT and AGENT (i.e. ,circular referential integrity constraint for table AGENT)in the HAPPY INSURANCE database,and an UPDATE CASCADE between AGENT and CLIENT,value A1 in the first record in the table AGENT can be changed to A5.

Accepted Answer

A) True 
 B)False

Question 20

HAPPY INSURANCE

Observe the HAPPY INSURANCE DATABASE:
CLIENT
 $$\begin{array} { l l c l } 
\text { ClientID } & \text { ClientName } & \text { CientAgent } & \text { ClientSpouseName } \
\text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \
\text { C222 } & \text { Kain } & A 1 & \text { Bill } \
\text { C333 } & \text { Cole } & A 2 & \text { Amy } \
\text { C444 } & \text { Dorothy } & A 2 & \
\text { C555 } & \text { Anay } & A 3 & \text { Amy } \
\text { C666 } & \text { Tina } & A 3 & \text { Matt } \
\text { C777 } & \text { Christina } & A 4 & \text { Mike }
\end{array}$$ AGENT
 $$\begin{array} { l l l l l c } 
\text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearofHire } & \text { SupervisedBy } \
\text { A1 } & \text { Kate } & 1 & 101 & 1990 & \
\text { A2 } & \text { Amy } & 2 & 92 & 2009 & \text { Al } \
\text { A3 } & \text { Luke } & 3 & 100 & 1992 & \
\text { A4 } & \text { James } & 3 & 90 & 2010 & \text { A3 }
\end{array}$$ AREA
 $$\begin{array} { l l l } 
\text { ArealD } & \text { AreaName } & \text { AreaHQ } \
1 & \text { East } & \text { Boston } \
2 & \text { West } & \text { San Francisco } \
3 & \text { Central } & \text { Chicago }
\end{array}$$

This database will be used for the following questions citing tables from the HAPPY INSURANCE database.
-If a DBMS enforces an UPDATE RESTRICT option on the referential integrity constraint between CLIENT and AGENT in the HAPPY INSURANCE database,what will be the outcome after a User tries to change the AgentID value in the last record to A5?

Accepted Answer

A) Value A4 appears once in column AgentID in AGENT,and value A4 appears once in column ClientAgent in table CLIENT 
B) Value A5 appears once in column AgentID in AGENT,and value A5 appears once in column ClientAgent in table CLIENT 
C) Value A5 appears once in column AgentID in AGENT,and value A5 does not appear in column ClientAgent in table CLIENT 
D) Value A5 does not appear in column AgentID in AGENT,and value A5 appears once in column ClientAgent in table CLIENT 
A) Value A4 appears once in column AgentID in AGENT,and value A4 appears once in column ClientAgent in table CLIENT 
B) Value A5 appears once in column AgentID in AGENT,and value A5 appears once in column ClientAgent in table CLIENT 
C) Value A5 appears once in column AgentID in AGENT,and value A5 does not appear in column ClientAgent in table CLIENT 
D) Value A5 does not appear in column AgentID in AGENT,and value A5 appears once in column ClientAgent in table CLIENT

Describe the update set-to-default option (for implementing a referential integrity constraint).

Which of the following describes the completeness data quality characteristic?

Describe the delete set-to-null option (for implementing a referential integrity constraint).

What is a trigger?

Mandating instantaneous entry of all new data is an example of a preventive data quality action.

What are preventive data quality actions?

What is the purpose of an index?

Describe the delete set-to-default option (for implementing a referential integrity constraint).

Which of the following describes the conformity data quality characteristic?

Introduction

Database Requirements and ER Modeling

Relational Database Modeling

Update Operations, update Anomalies, and Normalization

SQL

Data Warehousing Concepts

Data Warehouse and Data Mart Modeling

Data Warehouse Implementation and Use

Overview of Dbms Functionalities and Database Administration

Filters

Exam 6: Database Implementation and Use

Describe the update set-to-default option (for implementing a referential integrity constraint).

Which of the following describes the completeness data quality characteristic?

Describe the delete set-to-null option (for implementing a referential integrity constraint).

What is a trigger?

Mandating instantaneous entry of all new data is an example of a preventive data quality action.

What are preventive data quality actions?

What is the purpose of an index?

Describe the delete set-to-default option (for implementing a referential integrity constraint).

Which of the following describes the conformity data quality characteristic?

Introduction

Database Requirements and ER Modeling

Relational Database Modeling

Update Operations, update Anomalies, and Normalization

SQL

Data Warehousing Concepts

Data Warehouse and Data Mart Modeling

Data Warehouse Implementation and Use

Overview of Dbms Functionalities and Database Administration

Filters