Study tips 1z0-117

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?