CPS 521 - Introduction to Data Science | Midterm Exam | Complete Questions and Answers | Latest Updated 2025/2026 - Toronto Metropolitan University.

CSP521 Past Midterm


Questions 1-5 (below image)
e



SUPPLIER

supplier# | supplier name city
1 Acme Supplies [Toronto
2 Sona Systems Ottawa
3 AtoZ Systems |New York
4 Quality Supplies (London
5 Best Supplies Saskatoon


PART

part#| part name weight
1 |Tower case 25
2 |Sony display 4.5
3 |Mother board 0.6
4 |Yamaha speakers 2
5 |Power supply


CAN_SUPPLY

part# | supplier# | quantity
1 1 20
1 2 34
2 2 23
3 3 33
3 5 43
4 5 45
5 4 22

,Question 1 (1 point)

Which of the following SQL statements generates following table from the PART
table?

part#| part name
1 |Tower case
2 |Sony display
3 |Mother board
4 |Yamaha speakers
5 |Power supply


() SELECT *
FROM PART
WHERE weight > 10

() SELECT part#,part_name
FROM PART


() SELECT part#, weight
FROM PART
WHERE weight > 10

() None of these options

() SELECT *
FROM PART

2nd

, Question 1 (1 point) Saved

Which of the following SQL statements generates following table from the PART
table?

part#| part name
1 |Tower case
2 [Sony display
3 |Mother board
4 |Yamaha speakers
5 |Power supply


() SELECT *
FROM PART
WHERE weight > 10


() SELECT part#, weight
FROM PART
WHERE weight > 10

() SELECT*
FROM PART

() None of these options

@ SELECT part#,part_name
FROM PART