Author Question: Show the INSERT INTO statements for the table VEHICLE. What will be an ideal ... (Read 75 times)

mcmcdaniel · **on:** Jul 7, 2018

Show the INSERT INTO statements for the table VEHICLE.

What will be an ideal response?

Question 2

The result table below is the result of a ________ action on the GENERICOLAPRESULT1 result table.

EE1 EE2 EE3
CC1 200 400 0
CC2 600 800 100

A) Slice and dice
B) Pivot
C) Drill-up
D) Drill-down

alexanderhamilton · **Reply #1 on:** Jul 7, 2018

Answer to Question 1

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');

Answer to Question 2

B