Quiz 1z0-117

Quiz 1z0-117, Oracle Database 11g Release 2: SQL Tuning

Which interpretation is correct?

What is the prerequisite?

What does the optimizer do in this situation?

What must be the correct order of steps that the optimizer executes based on the ID column the execution plan?

Which two statements are true about the bloom filter in the execution plan?