The database contains three tables: Suppliers_T(Key: SNUM), Parts_T(Key: PNUM) and Shipment T(Key: SNUM, PNUM). Assume all...

Transcribed Image Text:

The database contains three tables: Suppliers_T(Key: SNUM), Parts_T(Key: PNUM) and Shipment T(Key: SNUM, PNUM). Assume all the tables are connected through foreign keys. SNUM S1 S2 S3 S4 S5 PNUM P1 P2 P3 P4 P5 P6 Suppliers T SNAME STATUS CITY Smith 20 London Jones 10 Paris Blake 30 Paris 20 London. 30 Athens Clark Adams Parts T PNAME COLOR WEIGHT Nut Red 12 Bolt Green 17 Blue 17 Red 14 Cam Blue 15 Cog Red 19 Screw Screw SELECT DISTINCT Shipment_T.PNUM FROM Suppliers_T, Shipment T WHERE Suppliers_T.SNUM = Shipment_T.SNUM AND Suppliers T.SNAME = 'Jones'; A) 0 B) 2 24. What is the record returned by the following query? SELECT MIN(Parts_T.WEIGHT) FROM Parts T SNUM S1 $1 $1 S2 GROUP BY COLOR HAVING MIN(Parts_T.WEIGHT) <15; A) 12 B) 12 and 14 25. What is the record returned by the following query? SELECT DISTINCT Parts_T.PNAME S2 S3 23. How many records would the following SQL query return? S4 S4 C) 1 C) 14 Shipment T PNUM P1 P2 P6 P1 P2 P2 P2 P4 QTY 300 200 100 300 400 200 200 300 D) 3 D) Nothing is returned The database contains three tables: Suppliers_T(Key: SNUM), Parts_T(Key: PNUM) and Shipment T(Key: SNUM, PNUM). Assume all the tables are connected through foreign keys. SNUM S1 S2 S3 S4 S5 PNUM P1 P2 P3 P4 P5 P6 Suppliers T SNAME STATUS CITY Smith 20 London Jones 10 Paris Blake 30 Paris 20 London. 30 Athens Clark Adams Parts T PNAME COLOR WEIGHT Nut Red 12 Bolt Green 17 Blue 17 Red 14 Cam Blue 15 Cog Red 19 Screw Screw SELECT DISTINCT Shipment_T.PNUM FROM Suppliers_T, Shipment T WHERE Suppliers_T.SNUM = Shipment_T.SNUM AND Suppliers T.SNAME = 'Jones'; A) 0 B) 2 24. What is the record returned by the following query? SELECT MIN(Parts_T.WEIGHT) FROM Parts T SNUM S1 $1 $1 S2 GROUP BY COLOR HAVING MIN(Parts_T.WEIGHT) <15; A) 12 B) 12 and 14 25. What is the record returned by the following query? SELECT DISTINCT Parts_T.PNAME S2 S3 23. How many records would the following SQL query return? S4 S4 C) 1 C) 14 Shipment T PNUM P1 P2 P6 P1 P2 P2 P2 P4 QTY 300 200 100 300 400 200 200 300 D) 3 D) Nothing is returned

Answer rating: 100% (QA)

23 B Suppliers TSNUM ShipmentTSNUM returns all the records fr... View the full answer