Examice

Exam 1z0-908 All QuestionsBrowse all questions from this exam

Go to Exam

Question 41

Examine this query and output:

Which two statements are true? (Choose two.)

The country table is accessed as the first table, and then joined to the city table.

It takes more than 8 milliseconds to sort the rows.

The optimizer estimates that 51 rows in the country table have Continent = ‘Asia’.

35 rows from the city table are included in the result.

The query returns exactly 125 rows.

Correct Answer: B, E

Examining the EXPLAIN ANALYZE output, it shows that the sort operation's actual time is 8.306..8.431 milliseconds, indicating it takes more than 8 milliseconds to sort the rows. Additionally, the output mentions '125 rows' multiple times, indicating that exactly 125 rows were returned by the query.

Discussion

xjllllOptions: AE

A not sure