HAPPY INSURANCE

Observe the HAPPY INSURANCE DATABASE AGENT AREA

question 13

Multiple Choice

HAPPY INSURANCE

Observe the HAPPY INSURANCE DATABASE:
$\begin{array} { l l c l } \text { CLIENT } & & \\ \text { ClientlD } & \text { ClentName } & \text { CientAgent } & \text { ClientSpouseName } \\ \text { C111 } & \text { Tom } & \text { A1 } & \text { Jenny } \\ \text { C212 } & \text { Kanin } & A 1 & \text { Bil } \\ \text { C333 } & \text { Cole } & A 2 & \text { Amy } \\ \text { C444 } & \text { Dorothy } & A 2 & \\ \text { C555 } & \text { Anay } & A 3 & \text { Ams } \\ \text { C666 } & \text { Tina } & A 3 & \text { Mait } \\ \text { C777 } & \text { Christina } & A 4 & \text { Mike } \end{array}$

AGENT
$\begin{array} { l l c l c c } \text { AgentID } & \text { AgentName } & \text { AgentArea } & \text { AgentRating } & \text { AgentYearoffire 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 & \mathrm {~A} 3 \end{array}$

AREA
$\begin{array}{lll}\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.
-How many records will the following query in the HAPPY INSURANCE database return?
SELECT table_name,column_name
FROM user_tab_columns;

• A)2
• B)3
• C)10
• D)13

---

Definitions:

Morbidity

The condition of being diseased or the incidence of illness in a population, as opposed to mortality which refers to death rates.

Disease

A condition characterized by specific symptoms and signs, affecting an organism's structure or function, not directly resulting from physical injury.

Longitudinal

Describes research or studies conducted over a long period of time, tracking the same subjects to observe changes.

Prospective Epidemiological

Studies designed to follow participants forward in time to examine the relationships between suspected risk or protective factors and health outcomes.