ICT 285 Quiz 8 | Questions and Answers Latest Updated 2026
(Graded A+) - Murdoch University
Question 1
Correct
Mark 1.00 out of 1.00
Flag question
The Heap file organisation is an efficient structure for
Select one:
a. Range searches
c. Bulk uploading of data
,Correct
Mark 1.00 out of 1.00
Flag question
A b+tree index is good for retrieval based on:
c. Range matching
e. The b+tree index is good for retrieval based on all of these
The correct answer is: The b+tree index is good for retrieval based on all of these
Mark 1.00 out of 1.00
Flag question
Question text
Which of the following is a useful general principle for executing a query efficiently?
, Select one:
a. Do RESTRICT operations as early as possible
b. Do the most restrictive RESTRICTs first
c. Transform Cartesian Product followed by RESTRICT into JOIN
d. Do PROJECT operations as early as possible
e. All of these are useful general principles for efficient queries
Mark 1.00 out of 1.00
Flag question
Select one:
False
(Graded A+) - Murdoch University
Question 1
Correct
Mark 1.00 out of 1.00
Flag question
The Heap file organisation is an efficient structure for
Select one:
a. Range searches
c. Bulk uploading of data
,Correct
Mark 1.00 out of 1.00
Flag question
A b+tree index is good for retrieval based on:
c. Range matching
e. The b+tree index is good for retrieval based on all of these
The correct answer is: The b+tree index is good for retrieval based on all of these
Mark 1.00 out of 1.00
Flag question
Question text
Which of the following is a useful general principle for executing a query efficiently?
, Select one:
a. Do RESTRICT operations as early as possible
b. Do the most restrictive RESTRICTs first
c. Transform Cartesian Product followed by RESTRICT into JOIN
d. Do PROJECT operations as early as possible
e. All of these are useful general principles for efficient queries
Mark 1.00 out of 1.00
Flag question
Select one:
False
