STUDENT Observe the table STUDENT: STUDENT \[\begin{array} { l c l l } \text { StudentID } & \text { SSN } & \text { Nane } & { \text { Class } } \\ \hline D 111 & 111 - 11 - 1111 & \text { Connor } & \text { Freshman } \\ D 222 & 222 - 22 - 2121 & \text { Trevor } & \text { Freshman } \\ D 333 & 333 - 33 - 3333 & \text { Connor } & \text { Sophomore } \\ D 444 & 444 - 44-4444 & \text { Parker } & \text { Sophomore } \\ D 555 & 555 - 55 - 5555 & \text { Connor } & \text { Sophomore } \end{array}\] This table will be used for the following questions citing table STUDENT. -What will be the result of the following query on table STUDENT? SELECT * from STUDENT;

A) The entire relation STUDENT will be displayed B) StudentID column of the relation STUDENT will be displayed C) First record of the relation STUDENT will be displayed D) Last record of the relation STUDENT will be displayed A) The entire relation STUDENT will be displayed B) StudentID column of the relation STUDENT will be displayed C) First record of the relation STUDENT will be displayed D) Last record of the relation STUDENT will be displayed

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 { Madt } \\ \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. -Show the CREATE TABLE statements for the table AGENT (assume that non-primary key columns can be optional. )

CREATE TABLE agent (agentid CHAR(2), age

A view is a mechanism in SQL that allows

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. -What will be retrieved by the following query on the table CLIENT? SELECT DISTINCT clientname FROM client WHERE clientspousename = 'Amy';

A) Name Amy twice B) Name Amy C) Name Cole D) Names Andy and Cole A) Name Amy twice B) Name Amy C) Name Cole D) Names Andy and Cole

Exam 5: SQL | Examlex

VEHICLE Observe the table VEHICLE that contains the following four records: VEHICLE Vehiclell Type Make OwnerID OwnerName 111 Car Ford O1 Pam 222 Car Ford O2 Pat 333 Truck Honda O3 Pam 444 Car Honda O1 Pam This table will be used for the following questions citing table VEHICLE. -Show the INSERT INTO statements for the table VEHICLE.

Free

(Essay)

4.8/5

(24)

Question 1

Correct Answer:

Verified

INSERT INTO vehicle VALUES ('111','Car' ,'Ford' ,'O1','Pam');
INSERT INTO vehicle VALUES ('222','Car' ,'Ford' ,'O2','Pat');
INSERT INTO vehicle VALUES ('333','Truck','Honda','O3','Pam');
INSERT INTO vehicle VALUES ('444','Car' ,'Honda','O1','Pam');

What is the purpose of the DELETE command in SQL?

Free

(Essay)

4.8/5

(29)

Question 2

Correct Answer:

Verified

The DELETE command in SQL is used for deleting the data stored in database relations.

What is the purpose of a ";" (semicolon)in the SQL statement?

Free

(Essay)

4.9/5

(39)

Question 3

Correct Answer:

Verified

A semicolon ";" following the end of an SQL statement indicates the end of the SQL command.In a list of multiple SQL statements,the semicolon indicates where each SQL statement ends.