HAPPY INSURANCE
Observe the HAPPY INSURANCE DATABASE:
CLIENT AGENT AREA

question 45

Multiple Choice

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.


-Which of the following sequences of DROP TABLE statements for HAPPY INSURANCE database is in correct order?

• A)DROP TABLE area
• DROP TABLE client
• DROP TABLE agent
• B)DROP TABLE area
• DROP TABLE agent
• DROP TABLE client
• C)DROP TABLE client
• DROP TABLE agent
• DROP TABLE area
• D)DROP TABLE agent
• DROP TABLE client
• DROP TABLE area

---

Definitions:

Body Mass Index

A numerical value derived from a person’s weight and height, used to classify underweight, normal weight, overweight, and obesity.

BMI

Body Mass Index, a measure calculated from a person's weight and height, used to classify underweight, normal weight, overweight, or obesity.

Celsius

A scale for temperature in which 0 degrees represents the freezing point of water and 100 degrees its boiling point at sea level.

Fahrenheit

A temperature scale in which water freezes at 32 degrees and boils at 212 degrees under standard atmospheric conditions.