A designer sorts all clubs by meeting day and expects the result to show only Friday clubs. Why does the result still include clubs meeting on other days?

A

Sorting removes records only when the sorted field contains numbers.

B

Sorting permanently replaces all meeting-day values with Friday.

C

Sorting changes record order but does not exclude records that fail a condition.

D

Sorting can work only on primary-key fields.

Question 3

View answer

A borrowing system needs to compare return deadlines to identify overdue equipment. The most suitable data type for return_deadline is __________.

Integer

Date

Text

Boolean

Question 4

View answer

True or False: A product code can serve as a primary key only if someone can work out the product's name or category from the code.

A

True

B

False

Question 5

View answer

A workshop welcomes students in either Year 8 or Year 9. The query condition should be year = 8 __________ year = 9.

AND

ORDER BY

OR

DESC

Unlock all 61 questions with a free account

Sign up for a free account to keep practicing.

Sign up - it's free Log in

Practice MYP MYP Design Topic Databases and Data Handling with authentic exam-style questions for both SL and HL students. This question bank focuses on the exact syllabus content for Databases and Data Handling and mirrors Paper 1, 2 style where relevant.

Get instant solutions, detailed explanations, and build confidence with questions aligned to MYP examiner expectations.

Question 1

View answer

A trip is open only to C2 members who are in either Year 8 or Year 9. Which query condition selects exactly the eligible members?

A

(year = 8 AND year = 9) AND club_id = "C2"

B

(year = 8 OR year = 9) OR club_id = "C2"

C

year = 8 OR (year = 9 AND club_id = "C2")

D

(year = 8 OR year = 9) AND club_id = "C2"

Question 2

View answer

A designer sorts all clubs by meeting day and expects the result to show only Friday clubs. Why does the result still include clubs meeting on other days?

A

Sorting removes records only when the sorted field contains numbers.

B

Sorting permanently replaces all meeting-day values with Friday.

C

Sorting changes record order but does not exclude records that fail a condition.

D

Sorting can work only on primary-key fields.

Question 3

View answer

A borrowing system needs to compare return deadlines to identify overdue equipment. The most suitable data type for return_deadline is __________.

Integer

Date

Text

Boolean

Question 4

View answer

True or False: A product code can serve as a primary key only if someone can work out the product's name or category from the code.

A

True

B

False

Question 5

View answer

A workshop welcomes students in either Year 8 or Year 9. The query condition should be year = 8 __________ year = 9.

AND

ORDER BY

OR

DESC

Unlock all 61 questions with a free account

Sign up for a free account to keep practicing.

Sign up - it's free Log in

Practice MYP MYP Design Topic Databases and Data Handling with authentic exam-style questions for both SL and HL students. This question bank focuses on the exact syllabus content for Databases and Data Handling and mirrors Paper 1, 2 style where relevant.

Get instant solutions, detailed explanations, and build confidence with questions aligned to MYP examiner expectations.

MYP Design Databases and Data Handling Questionbank

MYP Design Databases and Data Handling Questionbank

Unlock all 61 questions with a free account

MYP MYP Design Topic Databases and Data Handling Questionbank

Unlock all 61 questions with a free account

MYP MYP Design Topic Databases and Data Handling Questionbank