Solved

HAPPY INSURANCE

Observe the HAPPY INSURANCE DATABASE AGENT AREA

Question 17

Multiple Choice

HAPPY INSURANCE

Observe the HAPPY INSURANCE DATABASE:
 CLIENT  ClientlD  ClentName  CientAgent  ClientSpouseName  C111  Tom  A1  Jenny  C212  Kanin A1 Bil  C333  Cole A2 Amy  C444  Dorothy A2 C555  Anay A3 Ams  C666  Tina A3 Mait  C777  Christina A4 Mike \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
 AgentID  AgentName  AgentArea  AgentRating  AgentYearoffire SupervisedBy  A1  Kate 11011990 A2  Amy 2922009 Al  A3  Luke 31001992 A4  James 3902010 A3\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
 ArealD  AreaName  AreaHQ 1 East  Boston 2 West  San Francisco 3 Central  Chicago \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 DISTINCT table_name
FROM user_tab_columns;


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

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions

Unlock this Answer For Free Now!

View this answer and more for free by performing one of the following actions

qr-code

Scan the QR code to install the App and get 2 free unlocks

upload documents

Unlock quizzes for free by uploading documents