Question 1

What is a report?

Accepted Answer

A report is a database front-end component whose purpose is to present the data and calculations on the data from one or more tables from the database in a formatted way.Whereas the purpose of forms is to facilitate the interaction between the end users and the database by enabling users to engage in actions such as update and search,reports are used strictly for the retrieval of data.The data that is retrieved via reports is formatted and arranged in a professional and easy-to-view fashion,to be displayed on the screen or printed as a hard copy.

Question 2

Which of the following describes the uniqueness 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 data correctly reflects the real world instances it is supposed to depict 
D) The extent to which the data properly conforms to and matches up with the other data 
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 data correctly reflects the real world instances it is supposed to depict 
D) The extent to which the data properly conforms to and matches up with the other data B

Question 3

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 CREATE TABLE statements for HAPPY INSURANCE database for the table CLIENT (assume that non-primary key columns can be optional)with the DELETE CASCADE option for its referential integrity constraint.

Accepted Answer

CREATE TABLE client
(clientid CHAR(4),
clientname CHAR(10),
clientagent CHAR(2),
clientspousename CHAR(10),
PRIMARY KEY (clientid),
FOREIGN KEY (clientagent)REFERENCES agent
ON DELETE CASCADE);

Question 4

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

Accepted Answer

The update set-to-null option allows a r

Question 5

Which of the following describes the consistency 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 6

A web site can be an interface into a database.

Accepted Answer

A) True 
 B)False

Question 7

Describe the update cascade option (for implementing a referential integrity constraint).

Accepted Answer

The update cascade option allows the pri

Question 8

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 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 { 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.
-Assume a search form for HAPPY INSURANCE database is created where a user can perform the following action:
ENTER AREA ID:
ENTER AREA NAME:
ENTER AREA HQ:
ENTER AgentID:
ENTER AgentName:
ENTER AgentArea:
ENTER AgentRating:
ENTER AgentYearOfHire: 2010 (<--- Entered by the user)
ENTER SupervisedBY: A3 (<--- Entered by the user)
(User clicks on the search button upon entering the values above. )
Write the SQL statement that will be issued on the user's behalf based on this action.

Accepted Answer

SELECT *
FROM agent

Question 10

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 SET-TO-NULL 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

Question 11

Describe the update restrict option (for implementing a referential integrity constraint).

Accepted Answer

The update restrict option doe

Question 12

What is linear search?

Accepted Answer

Linear search finds a particul

Question 13

What is a form?

Accepted Answer

A form is a database front-end component

Question 14

What are corrective data quality actions?

Accepted Answer

Corrective data qual

Question 15

Describe the delete cascade option (for implementing a referential integrity constraint).

Accepted Answer

The delete cascade option allows a recor

Question 16

Most RDBMS packages implement assertions using the CREATE ASSERTION statement.

Accepted Answer

A) True 
 B)False

Question 17

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. )
$\begin{array}{|l|l|c|c|l|l|c|c|ll| }
\hline200705&  \text {MeCormick   } & \text { Chris}& \text {Chcoormickc@arcedu}&11.10 .1992  &1.1.2010.&1.1.2014.& \text {Chicago}& \text {USA} \
\hline
\end{array}$

Accepted Answer

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

Question 18

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. )
$\begin{array}{|l|l|c|c|l|l|c|c|ll| }
\hline200603&  \text {Little  } & \text { Mark}& \text {hittlem@arcedu}&04.05 .1994 &1.1.2011.&1.1.2015.& \text { Detroit}& \text {US} \
\hline
\end{array}$

Accepted Answer

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

Question 19

Using an input mask such as DD/MM/YYYY for entry of a date value is an example of a corrective data quality action.

Accepted Answer

A) True 
 B)False

Question 20

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

What is a report?

Which of the following describes the uniqueness data quality characteristic?

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

Which of the following describes the consistency data quality characteristic?

A web site can be an interface into a database.

Describe the update cascade option (for implementing a referential integrity constraint).

Describe the update restrict option (for implementing a referential integrity constraint).

What is linear search?

What is a form?

What are corrective data quality actions?

Describe the delete cascade option (for implementing a referential integrity constraint).

Most RDBMS packages implement assertions using the CREATE ASSERTION statement.

Using an input mask such as DD/MM/YYYY for entry of a date value is an example of a corrective data quality action.

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

What is a report?

Which of the following describes the uniqueness data quality characteristic?

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

Which of the following describes the consistency data quality characteristic?

A web site can be an interface into a database.

Describe the update cascade option (for implementing a referential integrity constraint).

Describe the update restrict option (for implementing a referential integrity constraint).

What is linear search?

What is a form?

What are corrective data quality actions?

Describe the delete cascade option (for implementing a referential integrity constraint).

Most RDBMS packages implement assertions using the CREATE ASSERTION statement.

Using an input mask such as DD/MM/YYYY for entry of a date value is an example of a corrective data quality action.

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