What The Index Can Serve

PostgreSQL running in the C locale, with a plain B-tree index on users(name), another on users(deleted_at), and no expression indexes. Which of these WHERE clauses can the planner satisfy with an index scan? More than one applies.

A

name LIKE '%raph'

B

deleted_at IS NULL

C

name = 'Seraph'

D

name LIKE 'Ser%'

E

name ILIKE 'ser%'