Oracle interview question

How indexes works in sql.