Question 5:
Examine this query and output:
Which two statements are true?
A) The query returns exactly 125 rows.
B) It takes more than 8 milliseconds to sort the rows.
C) The country table is accessed as the first table, and then joined to the city table.
D) 35 rows from the city table are included in the result.
E) The optimizer estimates that 51 rows in the country table have continent = 'Asia'.
网友评论