Observe the HAPPY INSURANCE DATABASE: CLIENT ClientGender ClientSpouseName Jenny ClientID ClientName ClientAgent C111 Tom M A1...

 

Transcribed Image Text:

Observe the HAPPY INSURANCE DATABASE: CLIENT ClientGender ClientSpouseName Jenny ClientID ClientName ClientAgent C111 Tom M A1 C222 Karin A1 Bill С333 Cole M А2 Amy Dorothy Andy Tina C444 F A2 C555 A3 Amy С666 F АЗ Matt C777 Christina A4 Mike AGENT AgentYearOfHire SupervisedBy 1990 AgentID AgentName AgentArea AgentRating A1 Kate 101 A2 Amy Luke 92 2009 A1 АЗ 3 100 1992 A4 James 3 90 2010 АЗ AREA AreaID AreaName AreaHO 1 East Boston 2 West San Francisco 3 Central Chicago Let's assume we want to add one more agent to the "AGENT' table. Each of the following examples of an INSERT statement is correct except: Select one: O a. INSERI INTO AGENTS (AgentYearofHire, AgentName, AgentArea, AgentRating, AgentID, SupervisedBy) VALUES (2014, "Nick', 2, 97, 'A9', A2') Ob. INSERT INTO AGENTS VALUES ( 'AS', 'Tom', 2, 97, 2014, 'A3') c. INSERT INTO AGENTS VALUES ( 'A5', 'Tom', 2, 97, 2014, 'A7') Od. INSERT INTO AGENTS (AgentName, AgentAre a, AgentRating, AgentID, SupervisedBy, AgentYearofHire) VALUES ( 'Tom", 2, 97, 'A5', 'Al', 2014) O e. INSERT INTO AGENTS VALUES ( 'AS', 'Tom', 2, 97, 2014, NULL) Observe the HAPPY INSURANCE DATABASE: CLIENT ClientGender ClientSpouseName Jenny ClientID ClientName ClientAgent C111 Tom M A1 C222 Karin A1 Bill С333 Cole M А2 Amy Dorothy Andy Tina C444 F A2 C555 A3 Amy С666 F АЗ Matt C777 Christina A4 Mike AGENT AgentYearOfHire SupervisedBy 1990 AgentID AgentName AgentArea AgentRating A1 Kate 101 A2 Amy Luke 92 2009 A1 АЗ 3 100 1992 A4 James 3 90 2010 АЗ AREA AreaID AreaName AreaHO 1 East Boston 2 West San Francisco 3 Central Chicago Let's assume we want to add one more agent to the "AGENT' table. Each of the following examples of an INSERT statement is correct except: Select one: O a. INSERI INTO AGENTS (AgentYearofHire, AgentName, AgentArea, AgentRating, AgentID, SupervisedBy) VALUES (2014, "Nick', 2, 97, 'A9', A2') Ob. INSERT INTO AGENTS VALUES ( 'AS', 'Tom', 2, 97, 2014, 'A3') c. INSERT INTO AGENTS VALUES ( 'A5', 'Tom', 2, 97, 2014, 'A7') Od. INSERT INTO AGENTS (AgentName, AgentAre a, AgentRating, AgentID, SupervisedBy, AgentYearofHire) VALUES ( 'Tom", 2, 97, 'A5', 'Al', 2014) O e. INSERT INTO AGENTS VALUES ( 'AS', 'Tom', 2, 97, 2014, NULL)

Answer rating: 100% (QA)

1 client count view Client Agent Client Count A1 2 A2 2 A3 2 A4 1 2 client co... View the full answer