How can you see all indexes defined for a table?

SHOW INDEX FROM techpreparation_questions;